Reading MS-Access data on SODA

[PGStats]

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.

[JBailey]

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&doc...

Best wishes,

Jeff

[PGStats]

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?

[JBailey]

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