topic Re: SAS/ACCESS to PC Files in Administration and Deployment

SAS/ACCESS to PC Files

milts — Tue, 29 Apr 2014 07:00:25 GMT

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

Re: SAS/ACCESS to PC Files

jakarman — Tue, 29 Apr 2014 07:36:37 GMT

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.

Re: SAS/ACCESS to PC Files

milts — Tue, 29 Apr 2014 14:24:39 GMT

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

Re: SAS/ACCESS to PC Files

jakarman — Tue, 29 Apr 2014 17:17:48 GMT

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.

Re: SAS/ACCESS to PC Files

SASKiwi — Tue, 29 Apr 2014 21:54:09 GMT

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.

Re: SAS/ACCESS to PC Files

LineMoon — Sat, 25 Jul 2015 23:25:01 GMT

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 ?

Re: SAS/ACCESS to PC Files

SASKiwi — Sun, 26 Jul 2015 23:24:16 GMT

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.

Re: SAS/ACCESS to PC Files

Kurt_Bremser — Mon, 27 Jul 2015 05:29:47 GMT

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.