Dear All,
I would like to Read Input file directly from the third record and create a new table using DATA Step, Is it possible ?
Input File:
Roll number | Dob | Salary | experience |
1 | 11/12/87 | 2500 | 2 |
5 | 12/04/56 | 3400 | 3 |
3 | 03/06/79 | 1200 | 4 |
2 | 04/05/94 | 44560 | 4 |
4 | 03/07/99 | 12908 | 3 |
6 | 03/07/99 | 12908 | 7 |
Thanks a lot in advance for help.
Regards,
S Ravuri.
Do you want to read from an existing SAS data set or from an external file? If an external file, what type is it, text, csv, Excel or something else?
Imazine this is as CSV File only. From CSV File, needs to read from the 3rd Record.
Regards,
S Ravuri.
If using an INFILE statement then FIRSTOBS=3 will start reading at the third line.
If using PROC IMPORT the option DATAROW=3 would start reading at the third line.
Is this what you are looking for?
data test;
input Roll_number Dob $8. Salary experience;
cards;
1 11/12/87 2500 2
5 12/04/56 3400 3
3 03/06/79 1200 4
2 04/05/94 44560 4
4 03/07/99 12908 3
6 03/07/99 12908 7
;
run;
data test1;
set test;
if _n_ ge 3 then output;
run;
proc print; run;
Output:
The SAS System 15:17 Tuesday, March 13, 2012 1
Roll_
Obs number Dob Salary experience
1 3 03/06/79 1200 4
2 2 04/05/94 44560 4
3 4 03/07/99 12908 3
4 6 03/07/99 12908 7
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.