topic Re: Proc export error in SAS Programming

Proc export error

Mushy — Fri, 05 Jan 2024 19:16:32 GMT

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

Re: Proc export error

Tom — Fri, 05 Jan 2024 19:22:45 GMT

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.

Re: Proc export error

Mushy — Fri, 05 Jan 2024 22:56:07 GMT

@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

Re: Proc export error

Kurt_Bremser — Fri, 05 Jan 2024 23:36:47 GMT

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.

Re: Proc export error

SASKiwi — Fri, 05 Jan 2024 23:59:16 GMT

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.

Re: Proc export error

Mushy — Fri, 02 Feb 2024 18:02:39 GMT

@SASKiwi Thanks for the guidance!