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
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.
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
Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF
View now: on-demand content for SAS users
SAS 9.0 was released in 2002, 13 years ago. Are you sure that's the version you have?
Yeah Reeza, I still have it.
NOTE: SAS (r) Proprietary Software Version 9.00
Upgrades are free...
How is it? I don't have any idea to free upgrade.
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.
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.
Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF
View now: on-demand content for SAS users
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.