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;
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;
According to the preview of your data file, it does contain six rows? 🙂
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.
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.