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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.