topic Re: Problem in Proc import Datarow in SAS Procedures

Problem in Proc import Datarow

Aman4SAS — Mon, 14 Apr 2014 13:50:05 GMT

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 — Mon, 14 Apr 2014 14:06:20 GMT

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 — Mon, 14 Apr 2014 14:14:40 GMT

Great thanks....