08-19-2015 02:26 PM
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.
08-19-2015 03:21 PM
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.
08-20-2015 03:18 AM
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
08-20-2015 10:18 AM
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'.
08-20-2015 10:51 AM
I don't use an export wizard for exporting. I just execute the above statement in Enterprise Guide just as plain SAS code. I don't use any of the GUI in EG for running processes at all.