topic Re: SAS programming in SAS Programming

SAS programming

Tap222 — Wed, 28 Dec 2016 07:48:27 GMT

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?

Re: SAS programming

PeterClemmensen — Wed, 28 Dec 2016 07:55:50 GMT

Take a look at the following 🙂

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

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

Re: SAS programming

Tap222 — Wed, 28 Dec 2016 08:42:45 GMT

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

Re: SAS programming

PeterClemmensen — Wed, 28 Dec 2016 09:10:37 GMT

Cool. Does that solve your problem then? 🙂

Re: SAS programming

Ksharp — Wed, 28 Dec 2016 10:07:03 GMT

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

are not available to XLSX engine, try 

dbms=xls

or

dbms=excel

Re: SAS progrmming

Tom — Wed, 28 Dec 2016 16:36:33 GMT

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;

Re: SAS programming

Reeza — Wed, 28 Dec 2016 16:39:48 GMT

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