i have run below code by using Sas Enterprice Guide 5.1(32 Bit) and it's runs successfully but proc import datafile= "C:/PARAMETERS/Deviate_Param.XLS"
out=WORK.param
dbms=XLS
replace;
sheet="Parameters";
getnames=Yes;
run; i have run same code in Sas Enterprice Guide 5.1(64 Bit) and log shows physical files doesn't exist.. after that i have changed(refer below code) the XLS to xls (upper case to lower case) and program runs successfully without error and warning. proc import datafile= "C:/PARAMETERS/Deviate_Param.xls"
out=WORK.param
dbms=XLS
replace;
sheet="Parameters";
getnames=Yes;
run; is there any rules are in sas enterprice guide?kindly anyone explain this ?????
... View more