SAS Connectivity to MySQL

In order to process tables froim MySQL tables, a number of steps must be taken.

First, you must install SAS with the ACCESS/MySQL module. If SAS is already installed on your system you may check what is installed by running the following SAS code:

proc setinit noalias;
run;

If you do not see MySQL listed in the output, you will need to install that module by running the setup program again.

The next step is to install MySQL server with the client extensions. Unfortunately you must install the server even thuough you will not be using the local server. It is necessary for you to have an Oracle Login to be able to download the MySQL software. Once ready to download go to the following link: http://www.mysql.com/downloads/mysql/5.5.html

Download the correct install file for the version of Windows running on your system.

Install MySQL with all of the defaults.

once installed you will need to add the following to your global path if it is not already on the path:

;C:\Program Files\MySQL\MySQL Server 5.5\lib;C:\Program Files\MySQL\MySQL Server 5.5\bin

The following steps may be followed to edit the path.

1. From the start menu right clight on computer
2. click on properties
3. On the properties window click the change settings button (lower right)
4. Click on the advanced tab
5. Click the Environment Variables button
6. In the system variables list , scroll down and click on the path line when you see it. Then click the edit button.
7. By default the path will be highlighted. Press the right arrow key. Then type in or cut and paste the path element given above. The semicolon at the beginning must be included. All path entries are separated by a semicolon in the list.
8. Click OK on each window till you are back at the Properties window.

Reboot your system. You should now have access to your mysql tables through SAS.