BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi again.

How do I remove the first row from reading into the DATA step?

I have a file which has a Header Record that has titles of the columns on the first row followed by the actual data - how do I remove this line before sending to the DATA step.

Thanks again.
Shelton.
5 REPLIES 5
Peter_C
Rhodochrosite | Level 12
in what part of the sas system are you reading the file?
EG, Data Step, DI?
The options are different in each.
ieva
Pyrite | Level 9
Maybe option firstobs=2 is what you need
deleted_user
Not applicable
I was doing it in the datastep - I will try what ieva suggested.

Thanks Message was edited by: shelton
deleted_user
Not applicable
Is it possible to do this at the DATA step and not at the gobal OPTIONS level ?

Regards
Shelton
Patrick
Opal | Level 21
data test;
infile .... firstobs=2...
...
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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 16506 views
  • 1 like
  • 4 in conversation