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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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