I have two PCs with SAS on them. One with 32 bit and one with 64 bit. I have code that has worked fine for a long time with 32 bit. I updated a program with the 64 bit PC that was originally written with the 32 bit. In running it now on the 32 bit, it now is having a problem with the last proc export statement below. This worked fine in 32 bit prior. I also included the error, which has nothing to do with the lib ref statements. They are fine.
The Access DB is 32 bit.
PROC EXPORT DATA=s1PermComb
DATABASE="R:\CIP\Projects - Data\Court CW Data Metrics Project\SharePoint Prototype Files\accessTest.accdb";
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
If that is case, check this out:
Basically you need to install Microsoft Access Engine 64 bit. The blog is about Excel, but the engine works for both. It has the exactly same name as the 32 bit when lookup in control panel, so be careful.
Also, you make sure you have valid SAS/ACCESS license pc files on this 64 bit box.
Two possible reasons:
a) you have a bitness problem
b) you don't have the necessary SAS/ACCESS license, or the SAS/ACCESS module was not installed correctly
Just putting my worthless 2 cents in. Is the export wizard working (with the PC files server)? At the end of the wizard it allows you to save the datasteps to a file and you could check that code with your own to see if anything is different. I've had a export statement work in a previous SAS version but not with a newer version (I know not the same as your problem) due to a slight difference in code. In addition, I've seen your error statement before since the SAS 9.3 version when I don't select the 'accessdb on a PCfiles server'.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.