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?
Take a look at the following 🙂
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."
Actually, it's working with range but startcol and endcol.it doesn't work.
Cool. Does that solve your problem then? 🙂
STARTCOL=, STARTROW=, ENDCOL=, ENDROW=, are not available to XLSX engine, try dbms=xls or dbms=excel
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;
Please don't start a new thread for the same question.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.