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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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: