Dear All,
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
out=tele.base_data
dbms=dlm
replace;
delimiter='09'x;
datarow=2;
run;
Regards,
Siddhartha
can u send the log and ERROR your are getting.
In addition to the log, it will also help if can you post the first 3 lines or so of your datafile.
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;
Tom
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.)
Ksharp
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.