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

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

sambasiva_ravuri_tcs_com — Tue, 13 Mar 2012 15:06:42 GMT

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.

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

ballardw — Tue, 13 Mar 2012 15:35:48 GMT

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?

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

sambasiva_ravuri_tcs_com — Tue, 13 Mar 2012 15:42:28 GMT

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

Regards,

S Ravuri.

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

ballardw — Tue, 13 Mar 2012 18:58:33 GMT

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.

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

Hima — Tue, 13 Mar 2012 19:59:18 GMT

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