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.
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
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?
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.