Help using Base SAS procedures

Problem in Proc import Datarow

Reply
Super Contributor
Posts: 266

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.

Super User
Posts: 9,769

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: 266

Re: Problem in Proc import Datarow

Great thanks....

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