BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Mushy
Quartz | Level 8

Hi All,

I have an issue where I am trying to export a dataset from EG to the sas server to access databse using export procedure.

PROC EXPORT DATA=cars
OUTTABLE='Acces'
DBMS=ACCESSCS REPLACE;
DATABASE='ss.accdb';
RUN;

I get the following error:

ERROR: Server Name is invalid or missing.

Note that I have logged in to SAS server and executing the sas program.. so i dont need to 

sepecify server details in proc export statement.

also I have the license for sas/access interface to PC files

could you help me fix the issue.

 

Thanks,

Mushy

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

The DBMS ACCESS option is only valid if your SAS Server runs on the Windows OS. For other OSs then ACCESSCS is the only option but it requires the SAS PC Files Server product to be installed, either on your client PC or on an accessible Windows server. The link is to where you can download the appropriate version.

View solution in original post

5 REPLIES 5
Tom
Super User Tom
Super User

By using DBMS=ACCESSCS you are asking SAS to connect to SAS PC Files Server where it can run Microsoft code to create an ACCESS file.  But you did not tell your SAS session what the name of the SAS PC Files Server was that it should use.

 

If your SAS code is already running on a Windows machine that has ACCESS installed try using DBMS=ACCESS instead.

Mushy
Quartz | Level 8

@Tom  Thanks for the response and the explanation. When the change the DBMS=ACCESS, I get the following error message:

ERROR: DBMS type ACCESS not valid for export.

Let me know if you know the root cause.

Thanks Mushy

Kurt_Bremser
Super User

Please share more information.

Do you use a local SAS installation, or a client/server setup?

Which interface do you use? SAS Studio, Enterprise Guide, Display Manager?

If C/S, which operating system does the server use?

 

Run PROC SETINIT and post the complete log.

SASKiwi
PROC Star

The DBMS ACCESS option is only valid if your SAS Server runs on the Windows OS. For other OSs then ACCESSCS is the only option but it requires the SAS PC Files Server product to be installed, either on your client PC or on an accessible Windows server. The link is to where you can download the appropriate version.

Mushy
Quartz | Level 8

@SASKiwi  Thanks for the guidance!

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 5 replies
  • 1137 views
  • 5 likes
  • 4 in conversation