DATA Step, Macro, Functions and more

SAS programming

Reply
Occasional Contributor
Posts: 11

SAS programming

proc import
datafile='D:\Exchange of data\shoes.xlsx'
dbms=xlsx
out=shoes
replace;
ENDCOL="4";
STARTCOL="2";

run;

error.png

In the above code it showing error.suggest me where I am going wrong?

PROC Star
Posts: 551

Re: SAS programming

Take a look at the following Smiley Happy

 

http://support.sas.com/documentation/cdl/en/acpcref/69731/HTML/default/viewer.htm#n0msy4hy1so0ren1ac...

 

I usually follow the thumb rule that says

 

"Use RANGE= instead of STARTCOL=, STARTROW=, ENDCOL=, ENDROW=, or any combination of these because RANGE= already contains all of these values."

Occasional Contributor
Posts: 11

Re: SAS programming

Actually, it's working with range but startcol and endcol.it doesn't work.

PROC Star
Posts: 551

Re: SAS programming

Cool. Does that solve your problem then? Smiley Happy

Super User
Posts: 9,671

Re: SAS programming

STARTCOL=, STARTROW=, ENDCOL=, ENDROW=,

are not available to XLSX engine, try 

dbms=xls

or

dbms=excel

Super User
Super User
Posts: 6,499

Re: SAS progrmming

[ Edited ]

The error message you showed is a side effect of the an earlier error. Fix that first.

I would not recommend using PROC IMPORT to read a CSV file with four columns. You will end up typing less code to just write the data step to read it yourself.  Plus then you won't need to run a PROC DATASETS step to remove unneccessary labels or formats that PROC IMPORT adds.

 

data shoes;
   infile 'D:\Exchange of data\shoes.csv' dsd truncover ;
   length Subsidiary $20 Stores Sales Inventory 8;
   input subsidiary -- inventory;
run;

 

Super User
Posts: 17,784

Re: SAS programming

Please don't start a new thread for the same question. 

Ask a Question
Discussion stats
  • 6 replies
  • 246 views
  • 2 likes
  • 5 in conversation