BookmarkSubscribeRSS Feed
PaalNavestad
Pyrite | Level 9

HI, I'm trying to import tables from an access database in a Linux Environment.

 

I have Access to PC files installed. However when trying to import I get 

ERROR: Server Name is invalid or missing.

 

I can't find anywhere in the documentation where I can identicate where the PC Files server is located. The code I'm trying to run is

proc import  out=ofm_data_dca_case
table="OFM_DATA_DCA_CASE"
DBMS=ACCESSCS REPLACE

;

DATABASE="/shared/winshare/teams_no/SAS_General/subsurface/dev/GGRE_IN/OFM_Avocet.mdb"; run;

We are running on a LINUX Grid version 9.4 M5

1 REPLY 1
ybolduc
Quartz | Level 8

Hi PaalNavestad,

 

I believe you would have more success with the libname pcfiles engine: https://documentation.sas.com/?docsetId=acpcref&docsetTarget=n1qk7lv0f535qkn1mydookwetyrp.htm&docset...

 

Thanks,

Yoan

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 2287 views
  • 0 likes
  • 2 in conversation