Read the input file directly from the third record and create a new table using DATA Step ?

[sambasiva_ravuri_tcs_com]

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.

[ballardw]

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?

[sambasiva_ravuri_tcs_com]

Imazine this is as CSV File only. From CSV File, needs to read from the 3rd Record.

Regards,

S Ravuri.

[ballardw]

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.

[Hima]

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