topic Re: to read flatfiles without header and footer in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140454#M2183 <HTML><HEAD></HEAD><BODY><P>You mean that you file has header and footer, and you want wish to avoid those?</P><P>Header is on row 1 i guess, so just if _n_ = 1 then delete;</P><P>Footer, if yo are sure that there always is a footer, make use of the END= infile option.</P><P>And what do you mean that you have 100 pages in the file, what kind of file is it?</P></BODY></HTML> Thu, 11 Sep 2014 09:30:13 GMT LinusH 2014-09-11T09:30:13Z to read flatfiles without header and footer https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140453#M2182 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>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.</P></BODY></HTML> Thu, 11 Sep 2014 08:45:16 GMT https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140453#M2182 venkatnaveen 2014-09-11T08:45:16Z Re: to read flatfiles without header and footer https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140454#M2183 <HTML><HEAD></HEAD><BODY><P>You mean that you file has header and footer, and you want wish to avoid those?</P><P>Header is on row 1 i guess, so just if _n_ = 1 then delete;</P><P>Footer, if yo are sure that there always is a footer, make use of the END= infile option.</P><P>And what do you mean that you have 100 pages in the file, what kind of file is it?</P></BODY></HTML> Thu, 11 Sep 2014 09:30:13 GMT https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140454#M2183 LinusH 2014-09-11T09:30:13Z Re: to read flatfiles without header and footer https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140455#M2184 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>infile &lt;filename&gt; firstobs=2 will skip the first header record.</P></BODY></HTML> Thu, 11 Sep 2014 10:02:43 GMT https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140455#M2184 damanaulakh88 2014-09-11T10:02:43Z Re: to read flatfiles without header and footer https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140456#M2185 <HTML><HEAD></HEAD><BODY><P>Is there anything in your source which identifies a header and a footer? Eg. a column "record type"?</P></BODY></HTML> Thu, 11 Sep 2014 10:09:24 GMT https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140456#M2185 Patrick 2014-09-11T10:09:24Z Re: to read flatfiles without header and footer https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140457#M2186 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Thu, 11 Sep 2014 18:09:43 GMT https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140457#M2186 venkatnaveen 2014-09-11T18:09:43Z Re: to read flatfiles without header and footer https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140458#M2187 <HTML><HEAD></HEAD><BODY><P>thanks</P></BODY></HTML> Thu, 11 Sep 2014 18:10:19 GMT https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140458#M2187 venkatnaveen 2014-09-11T18:10:19Z Re: to read flatfiles without header and footer https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140459#M2188 <HTML><HEAD></HEAD><BODY><P>thanks</P></BODY></HTML> Thu, 11 Sep 2014 18:11:10 GMT https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140459#M2188 venkatnaveen 2014-09-11T18:11:10Z Re: to read flatfiles without header and footer https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140460#M2189 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Tue, 16 Sep 2014 06:42:04 GMT https://communities.sas.com/t5/SAS-Data-Management/to-read-flatfiles-without-header-and-footer/m-p/140460#M2189 venkatnaveen 2014-09-16T06:42:04Z