SAS programming

[Tap222]

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

run;

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

[PeterClemmensen]

Take a look at the following 🙂

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."

[Tap222]

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

[PeterClemmensen]

Cool. Does that solve your problem then? 🙂

[Ksharp]

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

are not available to XLSX engine, try 

dbms=xls

or

dbms=excel

[Tom]

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;

[Reeza]

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