Proc export error

[Mushy]

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

[Tom]

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]

@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]

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 · Accepted solution]

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]

@SASKiwi  Thanks for the guidance!