Dear,
I am trying ti import a csv file(excel). I am not able to import. Please help. The log is shown in the attachment
Mycode;
proc import datafile="C:\Users\nn\Desktop\pp.csv" DBMS=csv out=mm;
run;
The message about more variables found than values means that some of your columns didn't have a header.
Mismatch types usually mean the 'guessingrows' default isn't large enough.
Try
proc import datafile="C:\Users\nn\Desktop\pp.csv" DBMS=csv out=mm;
guessingrows = 100;
run;
Based on your knowledge of the dataset, I would suggest taking the code from the log and manually fixing it to match your desired formats.
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.