DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 42

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

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 numberDobSalaryexperience
111/12/8725002
512/04/5634003
303/06/7912004
204/05/94445604
403/07/99129083
603/07/99129087

Thanks a lot in advance for help.

Regards,

S Ravuri.

Super User
Posts: 10,500

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

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?

Contributor
Posts: 42

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

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

Regards,

S Ravuri.

Super User
Posts: 10,500

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

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.

Regular Contributor
Posts: 233

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

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


Ask a Question
Discussion stats
  • 4 replies
  • 162 views
  • 0 likes
  • 3 in conversation