SAS Procedures

Help using Base SAS procedures
BookmarkSubscribeRSS Feed
SB12
Calcite | Level 5

Is there a way to read access database file format in UNIX SAS other than using PC file server.

 

If i use the libname statement or Proc Import, it gives me either of the following error:

 

ERROR: The ACCESS engine cannot be found.

 

 

ERROR: DBMS type ACCESS not valid for import.

 

5 REPLIES 5
ChrisHemedinger
Community Manager

If you have SAS Enterprise Guide, the File->Import Data task can read these files for you and create SAS data sets.  It gets the data into SAS, but not by using a SAS program that you can run within a UNIX session.

 

The other method is by using ODBC to connect to the MS Access database file, but I don't think that would work from UNIX either -- it relies on the Windows ACE drivers to read the data.

 

Chris

 

 

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!
SB12
Calcite | Level 5

Hi Chris,

           I was aware of the Import Wizard in the Enterprise Guide, however i would have to manually do the import and run the remaining part of the program. My Access file is very huge and when i used the import wizard, it almost took me 1 hour to complete the whole process. So, i had to wait for that. I was looking for something that i could just do everything in one process run.

LinusH
Tourmaline | Level 20
Why don't you want to use a PC Files Server?
Data never sleeps
SB12
Calcite | Level 5

Hi LinusH,

We have pc file server macro created by the developers, but that can be only used to import/export from NAS drive. I dont think i can have the PC file server installed in my desktop or the grid.

SASKiwi
PROC Star

If you have a macro using the PC File Server, why can't you write your own code to do the same thing? The PC File Server doesn't have to be installed on the same Windows computer as your Access database. It could also be installed on your desktop.

PROC IMPORT DATATABLE='Customers'
     DBMS=ACCESSCS
     OUT=SASCUSTOMERS REPLACE;
     DATABASE='mydrive:\yourAccessdirectory\AnnualFiles.accdb';
     SERVER="yourPCFServer.com";
     PORT=9621;
     DBDSOPTS='READBUFF=30';
RUN;

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 9969 views
  • 0 likes
  • 4 in conversation