Problem in Proc import Datarow

[Aman4SAS]

Hi,

I am using code to import file

i am facing error:

proc import out= old datafile =  "...\test.xls" dbms=excel  replace;

getnames = yes;

datarow=3;

run;

    Having in Datarow

ERROR 180-322: Statement is not valid or it is used out of proper order.

[Ksharp]

you can't use this option under EXCEL engine check documentation firstly.

proc import out= old datafile =  "c:\temp\url.xls" dbms=xls  replace;
getnames = yes;
startrow=3;
run;

Xia Keshan

[Aman4SAS]

Great thanks....