Dear All,
I have a file with .accdb format in my local drive and i want to import that into SAS. Please help me in this issue.
Regards,
Anil
Is SAS installed locally or remotely on a server?
Do you use Enterprise Guide, SAS Studio, or Display Manager as frontend?
SAS installed remotely and the accdb file also there in that sas server.
I need to convert that accdb file into sas7bdat file for my further analysis.
Regards,
Anil
The server has to be running on Windows, and you need SAS/ACCESS to PC Files licensed and installed.
proc import dbms=access or libname access should work (you might need to have MS ACE installed).
If your server runs on a non-Windows system, you need to set up the SAS PC Files Server on a Windows computer where the accdb files are accessible, and use dbms=accesscs.
Yes SAS/Access PC files are installed and but I'm getting an error like failed to connect to server
Please suggest me if you have any reference code or file.
See the documentation. The code would likely be
proc import
datafile="\path\file.accdb"
table="name_of_table"
out=mylib.mydata
dbms=access
replace
;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: