topic Re: startrow/datarow problem in New SAS User

startrow/datarow problem

Sk4r — Fri, 08 Mar 2019 21:27:17 GMT

Hi, I have a problem where I try to specify the start row to fetch data on my proc import, but I always get this error ERROR 180-322: Statement is not valid or it is used out of proper order for the following program

PROC IMPORT OUT= WORK.name 
DATAFILE= routeFile 
DBMS=EXCEL REPLACE;
RANGE="'Sheet 1$'"; 
startrow = 25;
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;

I also tried specifying a range after sheet 1$, but it also got me an error Name ''Sheet 1$'A25:J180' is too long for a SAS name in this
context.

Re: startrow/datarow problem

VDD — Fri, 08 Mar 2019 22:05:13 GMT

have you tried DATAROW=25 rather than startrow = 25?

Re: startrow/datarow problem

Sk4r — Fri, 08 Mar 2019 22:57:35 GMT

Indeed, I tried both. I think it's a html file with an excel extension. But, Id like a better opinion, because Im kind of newbie in SAS

Re: startrow/datarow problem

VDD — Fri, 08 Mar 2019 23:11:23 GMT

open the file with a text editor and see if you are getting what you expect. If not then likely it is an html file.

Re: startrow/datarow problem

Ksharp — Sat, 09 Mar 2019 10:46:05 GMT

Try other engine.

DBMS=xls

DBMS=xlsx