The SAS Output Delivery System and reporting techniques

access SAS through ODBC?

Reply
Regular Contributor
Posts: 163

access SAS through ODBC?

could I access SAS data in a UNIX machine from ODBC?
Super User
Posts: 9,676

Re: access SAS through ODBC?

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
Occasional Contributor
Posts: 5

Re: access SAS through ODBC?

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

Regular Contributor
Posts: 213

Re: access SAS through ODBC?

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

Occasional Contributor
Posts: 5

Re: access SAS through ODBC?

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.

Regular Contributor
Posts: 213

Re: access SAS through ODBC?

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

Occasional Contributor
Posts: 5

Re: access SAS through ODBC?

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.

SAS Super FREQ
Posts: 8,743

Re: access SAS through ODBC?

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

Ask a Question
Discussion stats
  • 7 replies
  • 582 views
  • 0 likes
  • 5 in conversation