Hi guys
Good Morning
please fix following error
/*Here I want to connect MySQL database in sas9.4 */ proc sql; connect to mysql as dbcon (user=root password=root server=mysql database=mysqldb port=9876); quit; /*This example connects to MySQL and sends it two EXECUTE statements to process:*/ proc sql; connect to mysql (user=myusr1 password=mypwd1 server=mysrv1 database=mysqldb port=9876); execute (create table whotookorders as select ordernum, takenby, firstname, lastname, phone from orders, employees where orders.takenby=employees.empid) by mysql; execute (grant select on whotookorders to myusr1) by mysql; disconnect from mysql; quit;
Looks as if the mysql engine is not installed. proc product_status show the installed modules, so execute:
proc product_status;run;
and have a look at the log.
In further posts ALWAYS post the log as text using the "Insert Code"
It seems that you do not have SAS/Access for MySQL installed. Apart from installing it, there is also the possibility of setting up an ODBC connection to the database and use that - if you have SAS/Access for ODBC, of course. If you do have it, the ODBC option may save you some license money.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.