Help using Base SAS procedures

Microsoft Access Files import to SAS 9.0

Accepted Solution Solved
Reply
Occasional Contributor Bal
Occasional Contributor
Posts: 18
Accepted Solution

Microsoft Access Files import to SAS 9.0

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


Accepted Solutions
Solution
‎03-26-2016 11:57 AM
Super User
Posts: 6,928

Re: Microsoft Access Files import to SAS 9.0

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
SAS Employee
Posts: 10

Re: Microsoft Access Files import to SAS 9.0

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

Super User
Posts: 17,750

Re: Microsoft Access Files import to SAS 9.0

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

Occasional Contributor Bal
Occasional Contributor
Posts: 18

Re: Microsoft Access Files import to SAS 9.0

Yeah Reeza, I still have it.

NOTE: SAS (r) Proprietary Software Version 9.00

Super User
Posts: 17,750

Re: Microsoft Access Files import to SAS 9.0

Upgrades are free...

Occasional Contributor Bal
Occasional Contributor
Posts: 18

Re: Microsoft Access Files import to SAS 9.0

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

Super User
Posts: 17,750

Re: Microsoft Access Files import to SAS 9.0

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.

SAS Employee
Posts: 10

Re: Microsoft Access Files import to SAS 9.0

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.

Solution
‎03-26-2016 11:57 AM
Super User
Posts: 6,928

Re: Microsoft Access Files import to SAS 9.0

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 8 replies
  • 317 views
  • 6 likes
  • 4 in conversation