Unix server et SAS/ACCESS to PC Files

Reply
Super Contributor
Posts: 371

Unix server et SAS/ACCESS to PC Files

If I have a sas on unix.

Is there any other solution can do the job of "

SAS/ACCESS to PC Files"   ?
Super User
Super User
Posts: 6,502

Re: Unix server et SAS/ACCESS to PC Files

SAS on Unix can read and write XLS and XLSX files directly using PROC IMPORT and PROC EXPORT.

Just make sure to use DBMS=XLSX or DBMS=XLS in the PROC EXPORT statement.

Super Contributor
Posts: 371

Re: Unix server et SAS/ACCESS to PC Files

That's correct
But, I want to use excel libname Engine, to allocation a library on sas EG under unix , like this
libname  toto  excel "\\bob\test.xlsx";
I think to do that's we need two things :
1- SAS/ACCESS to PC Files ( it is ok, I have it )
2 - windows server ( it is Ko, i do not have it)
In my question, there is two question
Quesion 1:  Is there any method to work   << libname  toto  excel "\\bob\test.xlsx"; " >> under unix without windows server ?

Question 2: Is there any othor method (or libname) can give the same results as SAS/ACCESS to PC Files ? ( yes, we can think about proc import ) ?

Valued Guide
Posts: 3,208

Re: Unix server et SAS/ACCESS to PC Files

SAS/ACCESS(R) 9.4 Interface to PC Files: Reference, Third Edition The XLSX engine can be used at Unix. It uses NO ACE/JET drivers of Microsoft. All other engines like EXCEL ore XLS are supporting Office 2003 excel that will need those MS drivers ACE/JET. Microsoft office drivers are not available for Unix.

---->-- ja karman --<-----
Super Contributor
Posts: 371

Re: Unix server et SAS/ACCESS to PC Files

@Jaap: Thank you very much

Ask a Question
Discussion stats
  • 4 replies
  • 208 views
  • 0 likes
  • 3 in conversation