I am very new to SAS, but otherwise very experienced in computing. I'm using a 5 year old MacBook Pro running El Capitan. I installed Oracle VirtualBox and started the free SAS University Edition on it. I have mariadb (the now open source version of MySQL) installed locally via MacPorts. I can use mysql from the command line without issue. I am trying to simply connect SAS to a database, any database at this point, just to prove that it can be done.
I have tried many versions of the following one-liner with and without some of the options
libname mysqllib mysql user=root password="" database=mytestdb server=localhost;
from the example in
https://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a002913931.htm
but I always get the same error in the log.
I suspect that the SAS/ACCESS to MySQL product is not in SAS University Edition.
Run PROC SETINIT to confirm the products available:
proc setinit noalias;
run;
I suspect that the SAS/ACCESS to MySQL product is not in SAS University Edition.
Run PROC SETINIT to confirm the products available:
proc setinit noalias;
run;
Generally, it might work with MariaDB, but SAS would probably not support this.
When it comes to the University Edition, I don't see MySQL in list of ACCESS engines included,
http://support.sas.com/software/products/university-edition/index.html
This seems to be the case. Thank you.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.