topic Reading MS-Access data on SODA in SAS Studio

Reading MS-Access data on SODA

PGStats — Mon, 16 Dec 2019 21:09:33 GMT

Hi friends,

How can I read MS-Access data on SODA? What server name should I specify in my LIBNAME statement? Do I need to also specify a PORT number?

libname STM PCFILES SERVER=?? path="/home/pg/sasuser.v94/STM/myDB.accdb" access=readonly;

Thanks.

Re: Reading MS-Access data on SODA

JBailey — Tue, 17 Dec 2019 13:50:58 GMT

Hi @PGStats

SERVER= points to the machine where SAS PC Files Server is running; your SAS admin may be able to provide this information to you. SERVER= can be a computer name (mycomp120), a full network name (mycomp120.mycompany.com), or an IP address (111.111.111).

If you are connecting from UNIX SERVER= is required. On Windows clients, if you omit SERVER= it invokes AUTOSTART.

PORT= specifies the port the SAS PC Files Server is listening on. The default is 9621. If SAS was configured to use a different port, you must specify PORT=. Once again, your SAS admin can tell you the values to use.

Just in case you want to look at the doc: https://go.documentation.sas.com/?docsetId=acpcref&docsetTarget=n1qk7lv0f535qkn1mydookwetyrp.htm&docsetVersion=9.4&locale=en

Best wishes,

Jeff

Re: Reading MS-Access data on SODA

PGStats — Tue, 17 Dec 2019 22:18:30 GMT

Thank you Jeff. I don't understand how to apply your advice to my use of SAS OnDemand for Academics. How can I reach my SAS admin (ultimately, someone from SAS, I guess) there?

Re: Reading MS-Access data on SODA

JBailey — Thu, 19 Dec 2019 16:14:00 GMT

Hi @PGStats

I have never used SAS OnDemand for Academics. SAS/ACCESS to PC Files may not be included.

You can find help here - https://support.sas.com/en/software/ondemand-for-academics-support.html#get-help

Best wishes,
Jeff