topic Re: MySQL database connect in SAS Programming

MySQL database connect

BrahmanandaRao — Wed, 02 Sep 2020 07:14:28 GMT

/*How to connect mysql database in sas 9.4 */
libname mysql1 mysql user=xxxx pwd=xxx;
proc sql;
create table mysql1.t1 as select * from mysql1.city ;
quit;

Re: MySQL database connect

SASKiwi — Wed, 02 Sep 2020 07:31:47 GMT

The error you are getting suggests that the SAS product SAS/ACCESS to MySQL is not installed and/or licensed.

You can check by running this:

proc product_status; run;
proc setinit; run;

If you have SAS/ACCESS to ODBC that is another way to connect to MySQL.

Re: MySQL database connect

BrahmanandaRao — Wed, 02 Sep 2020 07:42:21 GMT

hi SASKiwi
the above code tells product production validation data
so please give solution to access MySQL Access engine in SAS 9.4

Re: MySQL database connect

ChrisNZ — Wed, 02 Sep 2020 08:39:16 GMT

The validation data lists the licensed software.

Do you have a license for SAS/ACCESS to MySQL?

If not, maybe you have SAS/ACCESS to ODBC?

If you have no SAS/ACCESS software license, you cannot have SAS talk to other software. In that case you can use CSV files.

Re: MySQL database connect

SASKiwi — Thu, 03 Sep 2020 00:52:23 GMT

@BrahmanandaRao - Please post the SAS log of the code I posted.

Re: MySQL database connect

andreas_lds — Thu, 03 Sep 2020 05:30:07 GMT

@BrahmanandaRao wrote:
hi SASKiwi
the above code tells product production validation data
....

And this exactly what @SASKiwi wanted you to check, because the error-message you got is raised if Access To MySQL is not installed or if it is not configured, so checking whether it is installed and licenced is the first step to fix the issue.