topic Re: Microsoft Access Files import to SAS 9.0 in SAS Procedures

Microsoft Access Files import to SAS 9.0

Bal — Tue, 10 Feb 2015 02:04:17 GMT

I'm trying to connect or import Microsoft access ( .accdb) files into SAS 9.0. I tried by using proc import procedure and also tried libname statement but i could not get success. My access file in my desktop.I run this syntax:

libname new access 'c:\users\...\desktop\access_file.accdb';

run;

ERROR: Connect: Unrecognized database format 'c:\users\...\desktop\Access_File.accdb'

Step by step explain would be better for me.

Thanks

Re: Microsoft Access Files import to SAS 9.0

AjmalFarzam — Tue, 10 Feb 2015 02:37:05 GMT

Hi Bal,

Check out this SAS Note: http://support.sas.com/kb/40/547.html. Looks like you need a newer version of SAS to work with the version of Access your're running.

Thanks

Re: Microsoft Access Files import to SAS 9.0

Reeza — Tue, 10 Feb 2015 04:49:26 GMT

SAS 9.0 was released in 2002, 13 years ago. Are you sure that's the version you have?

Re: Microsoft Access Files import to SAS 9.0

Bal — Tue, 10 Feb 2015 05:00:30 GMT

Yeah Reeza, I still have it.

NOTE: SAS (r) Proprietary Software Version 9.00

Re: Microsoft Access Files import to SAS 9.0

Reeza — Tue, 10 Feb 2015 05:01:40 GMT

Upgrades are free...

Re: Microsoft Access Files import to SAS 9.0

Bal — Tue, 10 Feb 2015 05:04:52 GMT

How is it? I don't have any idea to free upgrade.

Re: Microsoft Access Files import to SAS 9.0

Reeza — Tue, 10 Feb 2015 05:12:00 GMT

If you have a valid SAS license contact your SAS rep and you can get an updated version. SAS is licensed yearly and the yearly license includes free upgrades.

If have an invalid SAS product then obviously you can't get an upgrade.

Re: Microsoft Access Files import to SAS 9.0

AjmalFarzam — Tue, 10 Feb 2015 05:14:53 GMT

Hi Bal, where are you located? If you get in touch with your local SAS office, they will be able to get a newer version of the software for you. As Reeza mentioned, upgrades are free.

Re: Microsoft Access Files import to SAS 9.0

Kurt_Bremser — Tue, 10 Feb 2015 07:04:49 GMT

But be aware that newer SAS versions may also require upgrades in operating system and hardware (32 to 64 bit).

9.0 is clearly much too old.