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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.