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