BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jakewendt
Calcite | Level 5

 

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.

 

ERROR: The MYSQL engine cannot be found.
ERROR: Error in the LIBNAME statement.
 
I've searched online and can't find a solution.
 
Do I need to set some environment variable?
Does the free version not include something that I need here?
Is SAS not compatible with the MariaDB version of MySQL?
Do I need to install something else?
Do I need to tell SAS where it can find the MYSQL engine?
Is this a VirtualBox issue?
 
Thank you in advance.
Jake
1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

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;

View solution in original post

4 REPLIES 4
SASKiwi
PROC Star

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;
jakewendt
Calcite | Level 5
Original site validation data
Current version: 9.04.01M3P062415
Site name: 'UNIVERSITY EDITION 2.2 9.4M3 WITH ETS FOR PLAYER'.
Site number: 70186327.
CPU A: Model name='' model number='' serial='+2'.
Expiration: 15JUN2016.
Grace Period: 0 days (ending 15JUN2016).
Warning Period: 46 days (ending 31JUL2016).
System birthday: 02JUL2015.
Operating System: LIN X64 .
Product expiration dates:
---Base SAS Software 15JUN2016 (CPU A)
---SAS/STAT 15JUN2016 (CPU A)
---SAS/ETS 15JUN2016 (CPU A)
---SAS/IML 15JUN2016 (CPU A)
---SAS/ACCESS Interface to PC Files 15JUN2016 (CPU A)
---SAS/IML Studio 15JUN2016 (CPU A)
---SAS Workspace Server for Local Access 15JUN2016 (CPU A)
---SAS Workspace Server for Enterprise Access 15JUN2016 (CPU A)
---High Performance Suite
 
I presume then that "SAS/ACCESS Interface to PC Files" does not include access to a MySQL database.  Bummer.
 
Thank you.
LinusH
Tourmaline | Level 20

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

Data never sleeps
jakewendt
Calcite | Level 5

This seems to be the case.  Thank you.

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 4599 views
  • 1 like
  • 3 in conversation