DATA Step, Macro, Functions and more

Reading data from CSV file

Reply
Super Contributor
Posts: 272

Reading data from CSV file

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;

Super Contributor
Posts: 272

Reading CSV file

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;

PROC Star
Posts: 552

Re: Reading CSV file

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

Super User
Posts: 10,516

Re: Reading CSV file

[ Edited ]

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.

 

Super User
Super User
Posts: 7,407

Re: Reading data from CSV file

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

Ask a Question
Discussion stats
  • 4 replies
  • 217 views
  • 3 likes
  • 4 in conversation