topic Reading CSV file in SAS Programming

Reading data from CSV file

knveraraju91 — Wed, 16 Nov 2016 16:25:39 GMT

Dear,

I attached a notepad file containing first 5 rows from a csv file. I used the following code. It worked. But I am not understanding why I have use firstrow=6 rather than firstrow=5 when the data starts in the 5 row.

data dv;
infile "C:\Users\tt\Desktop\three.csv"
delimiter=',' firstobs=6 missover dsd;
format Screening_no DescOfDev Day DateDev DateIdentified Classification Category Outcome ReportedToRA ReportedToIRB ActionRequired $200.;
input Deviation_no Screening_no Subject DescOfDev Day DateDev DateIdentified Classification Category Outcome ReportedToRA ReportedToIRB ActionRequired;
run;

Reading CSV file

knveraraju91 — Wed, 16 Nov 2016 16:29:01 GMT

Dear,

I attached a notepad file containing first 5 rows from a csv file. I used the following code. It worked. But I am not understanding why I have use firstobs=6 rather than firstobs=5 when the data starts in the 5 row. I am getting variable names in first row when I used firstrow=5. Please. Thanks

data one;
infile "C:\User\tt\Desk\thre.csv"
delimiter=',' firstobs=6 missover dsd;
format Screening_no DescOfDev Day DateDev DateIdentified Classification Category Outcome ReportedToRA ReportedToIRB ActionRequired $200.;
input Deviation_no Screening_no Subject DescOfDev Day DateDev DateIdentified Classification Category Outcome ReportedToRA ReportedToIRB ActionRequired;
run;

Re: Reading CSV file

PeterClemmensen — Wed, 16 Nov 2016 16:43:13 GMT

According to the preview of your data file, it does contain six rows? 🙂

Re: Reading CSV file

ballardw — Wed, 16 Nov 2016 16:49:05 GMT

It looks like you may have extra linefeeds in your data.

For instance:

Deviation #,"Screening 
Number",Subject ID                     Number,Description

looks like the field containng Screening Number has a line feed and Number" starts on a different obs when SAS reads the file.

If the first line of actual data is the one that starts this way:

0,O-0000,1000

Then that is the 6th line of the file.

Re: Reading data from CSV file

RW9 — Wed, 16 Nov 2016 16:49:00 GMT

Row 5 doesn't contain data from what I can see, it contains variables names. As you specify variable names on your input statement:

input Deviation_no Screening_no Subject DescOfDev Day DateDev DateIdentified Classification Category Outcome ReportedToRA ReportedToIRB ActionRequired;

You don't need to read Row 5, just the data, which starts at row 6