topic How to import CSV (excel) file in SAS Procedures

How to import CSV (excel) file

knveraraju91 — Mon, 31 Oct 2016 16:20:05 GMT

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 — Mon, 31 Oct 2016 16:52:44 GMT

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 — Mon, 31 Oct 2016 19:25:49 GMT

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.