topic Re: import excel from specific row in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/import-excel-from-specific-row/m-p/125206#M34407 <HTML><HEAD></HEAD><BODY><P>Mike,</P><P></P><P>You can do it by including a Range statement.&nbsp; It is described at:</P><P><A href="http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003103761.htm" title="http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003103761.htm">http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003103761.htm</A></P></BODY></HTML> Wed, 19 Sep 2012 16:01:35 GMT art297 2012-09-19T16:01:35Z import excel from specific row https://communities.sas.com/t5/SAS-Procedures/import-excel-from-specific-row/m-p/125205#M34406 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>How could I import an excel file from a sepcified row?</P><P></P><P>Thanks</P><P></P><P>Mike</P><P></P><P>PROC IMPORT</P><P>OUT= test</P><P>DATAFILE= "c:temp\in.xls"</P><P>DBMS=EXCEL REPLACE;</P><P>SHEET="test$";</P><P>GETNAMES=YES;</P><P>MIXED=YES;</P><P><STRONG>DATAROW=5;&nbsp; /*this has a problem,i want to import data from the fifth row*/</STRONG></P><P>USEDATE=YES;</P><P>SCANTIME=YES;</P><P>SCANTEXT=YES;</P><P>RUN;</P></BODY></HTML> Wed, 19 Sep 2012 15:21:48 GMT https://communities.sas.com/t5/SAS-Procedures/import-excel-from-specific-row/m-p/125205#M34406 Mike_Davis 2012-09-19T15:21:48Z Re: import excel from specific row https://communities.sas.com/t5/SAS-Procedures/import-excel-from-specific-row/m-p/125206#M34407 <HTML><HEAD></HEAD><BODY><P>Mike,</P><P></P><P>You can do it by including a Range statement.&nbsp; It is described at:</P><P><A href="http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003103761.htm" title="http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003103761.htm">http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003103761.htm</A></P></BODY></HTML> Wed, 19 Sep 2012 16:01:35 GMT https://communities.sas.com/t5/SAS-Procedures/import-excel-from-specific-row/m-p/125206#M34407 art297 2012-09-19T16:01:35Z