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
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.
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.
add an option datarow=8 .
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.