How to import CSV (excel) file

[knveraraju91]

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;

[ballardw]

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;

[Reeza]

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.