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
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.
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.
@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
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.
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.
@SASKiwi Thanks for the guidance!
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.