BookmarkSubscribeRSS Feed
GeorgeSAS
Lapis Lazuli | Level 10

Hello All,

 

I can use both windows SAS and Unix SAS on my company's work computer.

 

I can use libname XL excel 'C:\temp\abc.xlsx'; in windows SAS. But I can't use it in Unix SAS.

it will tells me the engine can not be found(in unix).

 

My question is what is the difference and how to configure for unix to solve the problem? 

 

Thanks!

 

(In UNIX:  Proc product_status; run;)

 

For Base SAS Software ...
Custom version information: 9.3
Image version information: 9.03.01M0P051111
For SAS/STAT ...
Custom version information: 9.3
For SAS/GRAPH ...
Custom version information: 9.3
For SAS/ETS ...
Custom version information: 9.3
For SAS/FSP ...
Custom version information: 9.3
For SAS/OR ...
2 The SAS System 09:08 Tuesday, May 2, 2017

Custom version information: 9.3
For SAS/AF ...
Custom version information: 9.3
For SAS/IML ...
Custom version information: 9.3
For SAS/QC ...
Custom version information: 9.3
For SAS/SHARE ...
Custom version information: 9.3
For SAS/LAB ...
Custom version information: 9.3
For SAS/CONNECT ...
Custom version information: 9.3
For SAS/TOOLKIT ...
Custom version information: 9.3
For SAS/INSIGHT ...
Custom version information: 9.3
For SAS OLAP Server ...
Custom version information: 9.3
For SAS Enterprise Miner ...
Custom version information: 7.1
Image version information: 9.03.01B0P060111
For SAS/IntrNet ...
Custom version information: 9.3
For SAS Integration Technologies ...
Custom version information: 9.3
For SAS/Secure 168-bit ...
Custom version information: 9.3
For SAS Text Miner ...
Custom version information: 5.1
Image version information: 9.03.01B0P060111
For SAS High-Performance Forecasting ...
Custom version information: 4.1
For SAS/ACCESS Interface to DB2 ...
Custom version information: 9.3
For SAS/ACCESS Interface to Oracle ...
Custom version information: 9.3
For SAS/ACCESS Interface to Sybase ...
Custom version information: 9.3
For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.3
For SAS/ACCESS Interface to ODBC ...
Custom version information: 9.3
For SAS/ACCESS Interface to INFORMIX ...
Custom version information: 9.3
For SAS/ACCESS Interface to Teradata ...
Custom version information: 9.3
For SAS/ACCESS Interface to Microsoft SQL Server ...
Custom version information: 9.3
For SAS/ACCESS Interface to MySQL ...
Custom version information: 9.3
For SAS Forecast Server Mid-Tier ...
Custom version information: 4.1
Image version information: 9.03.01B0P060111
For SAS Table Server ...
Custom version information: 9.3
NOTE: PROCEDURE PRODUCT_STATUS used (Total process time):

 

-----------------------------------------------------------

(In windows SAS: Proc product_status; run;)

 

 

For Base SAS Software ...
Custom version information: 9.3
Image version information: 9.03.01M0P052511
For SAS/STAT ...
Custom version information: 9.3
For SAS/GRAPH ...
Custom version information: 9.3
For SAS/ETS ...
Custom version information: 9.3
For SAS/FSP ...
Custom version information: 9.3
For SAS/OR ...
Custom version information: 9.3
For SAS/AF ...
Custom version information: 9.3
For SAS/IML ...
Custom version information: 9.3
For SAS/QC ...
Custom version information: 9.3
For SAS/LAB ...
Custom version information: 9.3
For SAS/ASSIST ...
Custom version information: 9.3
For SAS/CONNECT ...
Custom version information: 9.3
For SAS/INSIGHT ...
Custom version information: 9.3
For SAS/EIS ...
Custom version information: 9.3
For SAS/Secure Windows ...
Custom version information: 9.3
For SAS/ACCESS Interface to DB2 ...
Custom version information: 9.3
For SAS/ACCESS Interface to Oracle ...
Custom version information: 9.3
For SAS/ACCESS Interface to Sybase ...
Custom version information: 9.3
For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.3
For SAS/ACCESS Interface to ODBC ...
Custom version information: 9.3
For SAS/ACCESS Interface to OLE DB ...
Custom version information: 9.3
For SAS/ACCESS Interface to Teradata ...
Custom version information: 9.3
For SAS/ACCESS Interface to MySQL ...
Custom version information: 9.3

 

1 REPLY 1
Tom
Super User Tom
Super User

Easiest thing is to update your version of SAS to the most recent. Then you can use the XLSX engine on both Windows and SAS and not worry about Execl.  Note the Unix machine will need access to where the Excel files are stored.

 

Otherwise you need to install SAS PC FILES server on a windows machine somewhere. Then you can use that to access your Excel files, but the Windows machine will need access to location that the Excel files are stored.

 

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!

How to Concatenate Values

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.

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
  • 1 reply
  • 687 views
  • 1 like
  • 2 in conversation