BookmarkSubscribeRSS Feed
venkatnaveen
Obsidian | Level 7

Hi,

How I can read flat files without reading header and footer,suppose I have an flat files with 100pages,I wanna to read those files into my sas environment ,without reading header and footer.

7 REPLIES 7
LinusH
Tourmaline | Level 20

You mean that you file has header and footer, and you want wish to avoid those?

Header is on row 1 i guess, so just if _n_ = 1 then delete;

Footer, if yo are sure that there always is a footer, make use of the END= infile option.

And what do you mean that you have 100 pages in the file, what kind of file is it?

Data never sleeps
damanaulakh88
Obsidian | Level 7

Hi.

infile <filename> firstobs=2 will skip the first header record.

Patrick
Opal | Level 21

Is there anything in your source which identifies a header and a footer? Eg. a column "record type"?

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 7 replies
  • 3025 views
  • 0 likes
  • 4 in conversation