MySQL database connect

[BrahmanandaRao]

/*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;

[SASKiwi]

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.

[BrahmanandaRao]

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

[ChrisNZ]

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.

[SASKiwi]

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

[andreas_lds]

---

@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.