topic Removing the first row in SAS Programming

Removing the first row

deleted_user — Mon, 16 Nov 2009 05:59:14 GMT

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.

Re: Removing the first row

Peter_C — Mon, 16 Nov 2009 08:06:14 GMT

in what part of the sas system are you reading the file?
EG, Data Step, DI?
The options are different in each.

Re: Removing the first row

ieva — Mon, 16 Nov 2009 08:07:02 GMT

Maybe option firstobs=2 is what you need

Re: Removing the first row

deleted_user — Tue, 17 Nov 2009 06:27:12 GMT

I was doing it in the datastep - I will try what ieva suggested.

Thanks Message was edited by: shelton

Re: Removing the first row

deleted_user — Wed, 18 Nov 2009 03:03:18 GMT

Is it possible to do this at the DATA step and not at the gobal OPTIONS level ?

Regards
Shelton

Re: Removing the first row

Patrick — Wed, 18 Nov 2009 04:02:53 GMT

data test;
infile .... firstobs=2...
...