BookmarkSubscribeRSS Feed
sambasiva_ravuri_tcs_com
Calcite | Level 5

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.

4 REPLIES 4
ballardw
Super User

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
Calcite | Level 5

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

Regards,

S Ravuri.

ballardw
Super User

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
Obsidian | Level 7

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


sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 868 views
  • 0 likes
  • 3 in conversation