https://communities.sas.com/t5/SAS-Procedures/how-to-import-an-excel-file-when-column-names-are-on-third-rows/m-p/72679#M21055 The excel file starts with<BR /> "The data was created on mm-dd-yyyy"<BR /> then a blank row<BR /> then column names<BR /> then data.<BR /> <BR /> Is there any way to import the excel into SAS dataset and skip the first two lines and get the third row as column names?<BR /> <BR /> Thanks Thu, 16 Sep 2010 13:38:54 GMT neilxu 2010-09-16T13:38:54Z https://communities.sas.com/t5/SAS-Procedures/how-to-import-an-excel-file-when-column-names-are-on-third-rows/m-p/72679#M21055 The excel file starts with<BR /> "The data was created on mm-dd-yyyy"<BR /> then a blank row<BR /> then column names<BR /> then data.<BR /> <BR /> Is there any way to import the excel into SAS dataset and skip the first two lines and get the third row as column names?<BR /> <BR /> Thanks Thu, 16 Sep 2010 13:38:54 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-import-an-excel-file-when-column-names-are-on-third-rows/m-p/72679#M21055 neilxu 2010-09-16T13:38:54Z https://communities.sas.com/t5/SAS-Procedures/how-to-import-an-excel-file-when-column-names-are-on-third-rows/m-p/72680#M21056 Suggested reading from the SAS support website <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> -- use the search facility or here's a Google advanced search argument, this topic / post:<BR /> <BR /> proc import skip first row site:sas.com<BR /> <BR /> <BR /> Reading Delimited Text Files into SAS®9<BR /> <A href="http://support.sas.com/techsup/technote/ts673.pdf" target="_blank">http://support.sas.com/techsup/technote/ts673.pdf</A><BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Thu, 16 Sep 2010 14:19:05 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-import-an-excel-file-when-column-names-are-on-third-rows/m-p/72680#M21056 sbb 2010-09-16T14:19:05Z