12-28-2016 02:55 AM
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."
12-28-2016 11:34 AM - edited 12-28-2016 11:36 AM
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;