SAS/ACCESS to PC Files

[milts]

Hi,

I'm currently using EG (connected to a server) and while importing an Excel file the SAS/ACCESS to PC Files is grayed out, leaving me with the other options. Will installing SAS PC Files Server in my local PC enable me to have the option to be selectable? Greatly appreciate your advise. Thank you!

Best Regards,

Milton

[jakarman]

EG has his own import and connection options. Behind the scenes: importing Excel files using SAS Enterprise Guide - The SAS Dummy.

When the SAS/ACCESS to PC files is licensed on the server your support staff could implement a PC-files-server running on a Windows-server (virtualized) being part of an AD domain. You could also run a pc-files server on your local-pc but that one should be accessible from the server as ip/address dhcp defined name.

[milts]

Thanks for your response Jaap. But is the PC Files server necessary? or the SAS/ACCESS Interface to PC files enough?

[SASKiwi]

If your SAS Server operates on Windows then no PC Files server is necessary as long as the MS Office components also required on your SAS server for SAS/Access to PC files to work are the same "bit-ness" as your SAS install. The SAS Server is a 64-bit application so requires Office 64-bit components to avoid using the PC Files server.   

[LineMoon]

Hello,

Please, you have said :

"If your SAS Server operates on Windows then no PC Files server is necessary as long as the MS Office components also required"

But "f your SAS Server operates on unix"

What's I need ?

[SASKiwi]

If you are running on Unix then you still need the PC File Server unless you have SAS 9.4 M2 in which case....

If you are using SAS 9.4 M2 or higher on Unix then you can try the XLSX engine instead of the EXCEL engine because it doesn't require the PC File Server. There are a number of restrictions with XLSX versus EXCEL but at least set up is a lot easier.

[Kurt_Bremser]

Forget ACCESS to PC Files. Export your data in a sensible, textual format (csv) and use a very basic, simple data step to import the data. Works on ALL platforms, no licensing beyond SAS/Base necessary.

[jakarman]

PC file-server is part of the SAS/Access PC files. You cannot see them separately.

http://support.sas.com/software/products/access/ see the remarks on xlsx files.

Suppose you have an Unix server you can use PC-fileserver with data directly accessing in the Windows domain. The access is being done in a normal (central managed) authentication way.