import excel from specific row

[Mike_Davis]

Hello everyone,

How could I import an excel file from a sepcified row?

Thanks

Mike

PROC IMPORT

OUT= test

DATAFILE= "c:temp\in.xls"

DBMS=EXCEL REPLACE;

SHEET="test$";

GETNAMES=YES;

MIXED=YES;

DATAROW=5;  /*this has a problem,i want to import data from the fifth row*/

USEDATE=YES;

SCANTIME=YES;

SCANTEXT=YES;

RUN;

[art297]

Mike,

You can do it by including a Range statement.  It is described at:

http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003103761.htm