I want to access the sas data table outside sas software and in Microsoft Access where I can edit the records more conveniently.
The version of sas I have is 9.3 and I googled the sas ODBC driver and came across the following link.
http://support.sas.com/downloads/browse.htm?cat=40#tab:2:
Initially, I installed the “Aug 2014” version, but it is for SAS 9.4 and didn’t work.
I uninstalled the sas ODBC for 9.4 and then installed the “July 2011” version which didn’t work either because I have Win 7.
Then I had to uninstalled ODBC for 9.3 and download the “Dec 2011” version.
Hope this time it works but it doesn’t. 🙁
Got this error message.
When launching setup.exe for ODBC installation. Got the following error message.
While having no success in installing SAS ODBC 9.3, I found some good reference resource on the website.
http://www.sascommunity.org/planet/blog/category/sql/
With some investigation, I found the odbcad32.exe hiding in a winsxs folder.
C:\Windows\winsxs\x86_microsoft-windows-m..-odbc-administrator_31bf3856ad364e35_6.1.7600.16385_none_44263d819f0aa19e
This might came from one of the windows service patch installed previously, but it is not the same ODBC administrator when I run from the “Control Panel” > “Administrative Tools”, which point to a different odbcad32.exe under C:\Windows\System32.
Apparently, the SAS ODBC 9.4 has already been recognized in the “ODBC Data Source Administrator”. Under the “System DSN” tab, click “Add”.
Find the “SAS” driver at the bottom of the list and click “Finish”.
In the “SAS ODBC Driver Configuration” window, there are 3 tabs, “General”, “Servers” and “Libraries”. Notice the Server name is defined as “__5001” which is the default “Local (Single User)” and if you change the name to something else, it will cause error in connection. Click “Configure…” on the “Servers” tab.
On the “Local Options” setting, check if the Path for sas.exe is correct and don’t change the default setting for “Startup parameters”. Click “OK” to go back.
Click “Library” tab and under the “Library Setting” give a Name for the library which holds the SAS data file you want to access through ODBC. In the “Host File”, provide the directory of the folder that contains the SAS data files. You can create many libraries for different SAS folders. Click “Add” to add the library and then “OK” to go back.
This completes the configuration of the “SAS ODBC Driver”.
I. A.