BookmarkSubscribeRSS Feed
RajeshManickam
Calcite | Level 5

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 ?????

 

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

What bit version is your Office software?  By exporting/importing your data using XLS your invoking the Office software to use the file, if that bit type doesn't match your SAS bit version then you will have problems.  I would recommend using one of the other options possibly even libname excel may work in this scenario if you have 9.4:

libname tmp excel "c:/paramters/deviate_param.xlsx";

data work.param;
  set tmp.parameters;
run;

libname tmp clear;

 Avoiding proprietary file formats such as Office is always an option, plain text CSV files can be read in by any system on any OS. 

ChrisHemedinger
Community Manager

Where is SAS installed in this case?  Are you running with local SAS (installed on Windows along with SAS Enterprise Guide), or are you connecting to a remote SAS session?  If the latter, then the Excel file might not be accessible from that session using the path you specified.

 

In this case, users often need to copy the Excel file to the remote SAS session in order to complete the import step.  Fortunately this is easy to do with a Copy Files task -- a custom task for EG 5.1 but built-in for EG 7.13 and later.

 

 

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 3285 views
  • 1 like
  • 3 in conversation