Common problem. I have lots of issues importing Excel spreadsheets with observations like #N/A, ot blanks in what should be numeric columns. Here's what you do:
Really obvious... NOT.
Reason for the Import from Excel (and actually other databases) mystery: use of Microsoft or other application data engine that responds to a SAS request from the named source. So there are no lines of code resulting that SAS could execute.
I had the same problem when importing a .csv. Drove me crazy because I have done it a 1000 times in the past. Solution:
options source;
I had options nonsource.
I just had the same problem. Was trying to import with a very simple proc import, csv. Got an error but no information. Had done this a million times before and couldn't figure out the problem. Finally I closed down SAS and re-opened it and it worked. Go figure.
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.