04-06-2015 10:55 PM
I have created spread sheet in excel and trying to import data file to SAS.
My program version is SAS94 and excel is 34 bit. I found out SAS94 requires excel data convert to cvs.
When I try to import cvs file using import wizard, I get following error message:
Unable to sample external file, no data in first 5 records.
ERROR: Import unsuccessful. See SAS Log for details.
What is it mean?
I do have some blank spaces in first 5 lines (which is missing values)
How can I import cvs. file into SAS? Please help me
04-06-2015 11:22 PM
I found out SAS94 requires excel data convert to cvs.
I don't think that's true unless your licensing has changed.
Have you tried Proc Import to import the data, or a data step? You'll need to post either code or a sample file for more help.
04-07-2015 02:20 AM
You need to know the structure of the csv file, then you can write a suiting data step, which does not need any license beyond base at all. Ask for the documentation of the file; if there is none, return to sender.