Help using Base SAS procedures

Problem in Proc import Datarow

Reply
Super Contributor
Posts: 265

Problem in Proc import Datarow

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.

Grand Advisor
Posts: 9,463

Re: Problem in Proc import Datarow

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

Super Contributor
Posts: 265

Re: Problem in Proc import Datarow

Great thanks....

Ask a Question
Discussion stats
  • 2 replies
  • 1160 views
  • 0 likes
  • 2 in conversation