12-12-2011 07:05 AM
Can anyone please help me on the following code.
I am facing difficulty while downloading the data from TSV file, the issue is the code that I have mentioned below is not reading all the characters per column and stops reading the data afterwards including the rest of the columns in the same row ( column / variable is having 350+ characters.)
getting following errors.
ERROR: Limit set by ERRORS= option reached. Further errors of this type will not be printed.
ERROR: Import unsuccessful. See SAS Log for details.
filename in 'Path\meetings.tsv' encoding='utf8';
proc import datafile=in
12-12-2011 05:20 PM
I think your PROC IMPORT code is fine. SAS limits the size of OS datasets, and that can jump up and bite you at unexpected times. Try changing your FILENAME statement to
filename in 'Path\meetings.tsv' encoding='utf8' lrecl=32767;
12-12-2011 09:08 PM
I think your data is not matched with your variable type. Did you try 'gussingrow=' option to let SAS decide the right variable type and write some error check?
The best way is to use data step to make all variables are character Like: (var1-var200) (: $200.)