topic Re: Mysql connect to SAS in SAS Procedures

Mysql connect to SAS

kaushal2040 — Tue, 06 Jan 2015 21:11:01 GMT

Hello Forum,

I need to connect mysql database to SAS. I was wondering how it can be done? I appreciate any idea on syntax.

Thanks !!!

Patrick — Tue, 06 Jan 2015 21:29:48 GMT

You need either SAS/Access to ODBC or SAS/Access to MySQL licensed, installed and configured. SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Sixth Edition What do you have?

There are code examples in the docu link posted above.

kaushal2040 — Tue, 06 Jan 2015 21:55:29 GMT

Hi Patrick,

We have SAS/ACCESS interface to ODBC.

Thanks !!!

kaushal2040 — Tue, 06 Jan 2015 22:14:34 GMT

Hi Patrick,

In my computer, I can see only Oracle and SQL Server on ODBC data source (When I went to add). How to connect to MySQL?

Thanks !!!

Tom — Tue, 06 Jan 2015 22:53:42 GMT

I haven't used it myself, but there seems to be a nice MYSQL site with a driver for ODBC.

kaushal2040 — Tue, 06 Jan 2015 23:01:24 GMT

Thanks, Patrick and Tom,

I realized I need to install ODBC Driver for MySql.

Patrick — Tue, 06 Jan 2015 23:07:18 GMT

Not something I'm doing often - but I would say you need first the MySQL driver/connector installed MySQL :: Download Connector/ODBC

Installation must be on the machine where your SAS Server runs (and that's then also where you define the ODBC datasource).