Reading data from CSV file

[knveraraju91]

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;

[knveraraju91]

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;

[PeterClemmensen]

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

[ballardw]

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.

[RW9]

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