12-14-2014 08:03 AM
Provide much more information to us - and if you're lucky then while collecting this information you might even understand by yourself what's happening and how to resolve it.
12-15-2014 03:00 PM
Did you use proc import? If so what was the source file type?
You can search this forum for truncated and you'll find a number of related posts, especially if the data source is Excel.
12-16-2014 01:32 AM
it's a csv file. i am importing through proc import. Yes i will search in this group. Thanks.
what are the differences(adv and dis adv) in Proc import and infile. which one is best to use.
12-16-2014 03:02 AM
Again you can find numerous answers if you search in this forum like 'differences between infile and proc import' or simply 'proc import'
12-16-2014 03:14 AM
PROC IMPORT makes an educated guess about the file structure and then creates a suitable data step to read the data.
This means that a change in the file structure (or the data in the first n records inspected by proc import) will result in an automatic structural change in the dataset, which may cause problems farther down the line.
A manually written DATA step to read an external file will show unexpected data, either by causing a WARNING or ERROR condition, or at least by writing ERROR messages to the log. This will enable you to catch faulty data before it causes serious trouble.
12-16-2014 05:41 AM
Clue is in the title there, guessingrows. If your ok with letting SAS guess your data then go ahead, I would recommend writing a specific import program yourself for the data you know.