DATA Step, Macro, Functions and more

windows SAS and unix SAS differece

Reply
Regular Contributor
Posts: 205

windows SAS and unix SAS differece

[ Edited ]

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; runSmiley Wink

 

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; runSmiley Wink

 

 

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

 

Super User
Super User
Posts: 6,500

Re: windows SAS and unix SAS differece

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.

 

Ask a Question
Discussion stats
  • 1 reply
  • 95 views
  • 1 like
  • 2 in conversation