topic Re: access SAS through ODBC? in ODS and Base Reporting

access SAS through ODBC?

jplarios — Mon, 09 May 2011 21:30:08 GMT

could I access SAS data in a UNIX machine from ODBC?

Re: access SAS through ODBC?

Ksharp — Tue, 10 May 2011 05:45:29 GMT

I think it is much difficult.
For accessing sas dataset in a UNIX machine, it has usually three method.
SAS/SHARE SAS/CONNECT and Integrated Open Model (Example: sas/EG can use this
method to talk with SAS UNIX server.)

I recommend you to setup JDBC for sas, then you can use Java C++ VB to communicate with SAS.

Ksharp

Re: access SAS through ODBC?

rwan — Tue, 03 Feb 2015 10:36:05 GMT

I ran proc setinit and it lists Access to ODBC as one of the products. I just wonder if it is for real.

Re: access SAS through ODBC?

AhmedAl_Attar — Tue, 03 Feb 2015 11:51:14 GMT

Rwan,

SAS/ACCESS to ODBC means that you SAS installation can access data stored in ODBC compliant software, such as MS SQL Server, ORACLE, and any other RDBMS that support ODBC connections.

Accessing SAS tables via ODBC is completely different. You'll need

- Software licenses for either SAS/SHARE or SAS Scalable Performance Data Server (SPDS), or SAS Integration Technology

- A running server instance (SAS/SHARE, SPDS, Metadata Server/Object Spawner)

- The Corresponding SAS ODBC drivers installed on the Windows machine desired to access the SAS tables

Hope this helps,

Ahmed

Re: access SAS through ODBC?

rwan — Tue, 03 Feb 2015 12:49:45 GMT

Sorry I got confused by the various posts. Here is what I was trying to do. I have university edition of SAS and I also have data in MYSQL database. I was trying to get at my data from SAS. Now I know that ACCESS to ODBC is not on the product list of the university edition but I did a proc setinit and it clearly showed that ACCESS to ODBC is installed. I was wondering if there is a way to set up SAS to access my data on MYSQL. Any help you can provide would be much appreciated.

Re: access SAS through ODBC?

AhmedAl_Attar — Tue, 03 Feb 2015 13:10:14 GMT

The way I understand it, SAS University Edition runs in its own virtual (Linux) machine, which is "completely" isolated from your Windows (I'm guessing) machine, and the only link between them is how you setup the SAS Shared Folder, based on the installation instructions.

With that said, I don't know of a way, whereby you can modify the pre-installed SAS software, nor the Virtual Linux Environment variables, in order to configure the SAS/ACCESS product.

By the Way, you'll need SAS/ACCESS to MySQL and NOT SAS/ACCESS to ODBC!! Having SAS/ACCESS to ODBC listed in the proc setinit listing/output, does not mean it is installed!

You probably will get better answer posting your question to the

Good luck,

Ahmed

Re: access SAS through ODBC?

rwan — Tue, 03 Feb 2015 13:47:27 GMT

Thanks Ahmed. A SAS technical sales person told be that ACCESS to ODBC should get me connected to MYSQL in a normal installation. It might be a bit slower but theoretically it should work.

Re: access SAS through ODBC?

Cynthia_sas — Tue, 03 Feb 2015 14:44:56 GMT

But, you do not have a "normal" installation. You have an isolated installation. SAS University Edition runs in a Virtual Machine that does not really ever see the files on your C: drive. It only sees the files that you define to Virtual Box or VMware Player as shared. As explained by Ahmed, you cannot get to the Virtual Machine to make any configuration changes, so the chances are good that you will not be able to read your MySQL database directly with the University Edition. This is a question for Tech Support when they understand your whole configuration and how you are running SAS -- whether what you want to do will work specifically when you are using the SAS University Edition.

cynthia