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

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 2300 views
  • 0 likes
  • 2 in conversation