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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.