topic proc import with CSV in SAS Procedures

proc import with CSV

Tal — Fri, 25 Sep 2015 18:05:30 GMT

hi,

can i use namerow,getnames,startrow and sheet within proc import when trying to import a CSV file?

Getting errors when trying to import.

Anyone pls?

Thanks,

Re: proc import with CSV

ballardw — Fri, 25 Sep 2015 18:46:42 GMT

CSV files will not have sheets, so that won't work with csv, NAMEROW only applies to Excel spread sheet, not CSV.

Getnames will look for the names on the first line of the data. Datarow specifies which line of the file has the first row of data that you want read. You may also want to add a quessingrows =32000 to examine more values before guessing type of variable and length of character variables.

Post the code and the log results of errors for more specific help.

Re: proc import with CSV

Tal — Mon, 28 Sep 2015 19:40:42 GMT

thanks ballardw