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

Hello, I work as Tech Support at the Unviersity of North Texas. One of our faculty member requested the installation of SAS Studio and SAS/ACCESS Interface to MYSQL. Installing SAS Studio is no problem, however I have not been able to find any useful informatino on what SAS/ACCESS Interface to MYSQL is or how to install/use it. Any help will be appreciated.

 

Also this is my first time posting/asking a question so please let me know if this is not the proper way/place to do it.

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

Welcome to SAS. 

 

The component should be part of your installation, an option to click when you're walked through the installation process or setting up a depot. In a lot of academic institutions you get the whole package anyways rather than parts. You can run SETINIT or PRODUCT_STATUS procs to see what's installed/licensed already. See the link here for more information:

http://blogs.sas.com/content/sgf/2012/11/12/how-to-find-your-sas-version-and-components-list/

 

The interface to MySQL allows SAS to connect to a MySQL database and use it as a data source in SAS. There are multiple ways to do this, for example you could try ODBC or OLEDB, which are more generic. But they don't always work and sometimes have issues so using a DB specific product to connect to MySQL is recommended if you can. 

 

More than likely the user requesting it will know how to use it 😉

 

Documentation reference is here:

https://support.sas.com/documentation/cdl/en/acreldb/69580/HTML/default/viewer.htm#n1lyg1d0crcejin1v...

View solution in original post

6 REPLIES 6
Reeza
Super User

Welcome to SAS. 

 

The component should be part of your installation, an option to click when you're walked through the installation process or setting up a depot. In a lot of academic institutions you get the whole package anyways rather than parts. You can run SETINIT or PRODUCT_STATUS procs to see what's installed/licensed already. See the link here for more information:

http://blogs.sas.com/content/sgf/2012/11/12/how-to-find-your-sas-version-and-components-list/

 

The interface to MySQL allows SAS to connect to a MySQL database and use it as a data source in SAS. There are multiple ways to do this, for example you could try ODBC or OLEDB, which are more generic. But they don't always work and sometimes have issues so using a DB specific product to connect to MySQL is recommended if you can. 

 

More than likely the user requesting it will know how to use it 😉

 

Documentation reference is here:

https://support.sas.com/documentation/cdl/en/acreldb/69580/HTML/default/viewer.htm#n1lyg1d0crcejin1v...

VocanyP
Fluorite | Level 6

Thank you so much for the quick reply. After running the proc setinit command, I got the following output.

 

Original site validation data
Current version: 9.04.01M4P110916
Site name: 'UNIVERSITY OF NORTH TEXAS - T&R - SFA'.
Site number: 70194722.
Expiration: 30DEC2017.
Grace Period: 45 days (ending 13FEB2018).
Warning Period: 47 days (ending 01APR2018).
System birthday: 31MAR2017.
Operating System: WX64_WKS.
Product expiration dates:
---Base SAS Software
30DEC2017
---SAS/STAT
30DEC2017
---SAS/GRAPH
30DEC2017
---SAS/ETS
30DEC2017
---SAS/FSP
30DEC2017
---SAS/OR
30DEC2017
---SAS/AF
30DEC2017
---SAS/IML
30DEC2017
---SAS/QC
30DEC2017
---SAS/SHARE
30DEC2017
---SAS/ASSIST
30DEC2017
---SAS/CONNECT
30DEC2017
---SAS/EIS
30DEC2017
---SAS/SHARE*NET
30DEC2017
---SAS Enterprise Miner
30DEC2017
---MDDB Server common products
30DEC2017
---SAS Integration Technologies
30DEC2017
---SAS/Secure 168-bit
30DEC2017
---SAS/Secure Windows
30DEC2017
---SAS Text Miner
30DEC2017
---SAS Enterprise Guide
30DEC2017
---SAS Bridge for ESRI
30DEC2017
---OR OPT
30DEC2017
---OR PRS
30DEC2017
---OR IVS
30DEC2017
---OR LSO
30DEC2017
---SAS/ACCESS Interface to DB2
30DEC2017
---SAS/ACCESS Interface to Oracle
30DEC2017
---SAS/ACCESS Interface to SAP ASE
30DEC2017
---SAS/ACCESS Interface to PC Files
30DEC2017
---SAS/ACCESS Interface to ODBC
30DEC2017
---SAS/ACCESS Interface to OLE DB
30DEC2017
---SAS/ACCESS Interface to Teradata
30DEC2017
---SAS/ACCESS Interface to Microsoft SQL Server
30DEC2017
---SAS/ACCESS Interface to MySQL
30DEC2017
---Text Miner for Spanish
30DEC2017
---SAS Enterprise Miner for Desktop
30DEC2017
---SAS/IML Studio
30DEC2017
---SAS Workspace Server for Local Access
30DEC2017
---SAS/ACCESS Interface to Netezza
30DEC2017
---SAS/ACCESS Interface to Aster nCluster
30DEC2017
---SAS/ACCESS Interface to Greenplum
30DEC2017
---SAS/ACCESS Interface to SAP IQ
30DEC2017
---SAS/ACCESS to Hadoop
30DEC2017
---SAS/ACCESS to Vertica
30DEC2017
---SAS/ACCESS to Postgres
30DEC2017
---SAS/ACCESS to Impala
30DEC2017
---SAS/ACCESS to HAWQ
30DEC2017
---SAS/ACCESS to Amazon Redshift
30DEC2017
---High Performance Suite
30DEC2017
---SAS Add-in for Microsoft Excel
30DEC2017
---SAS/ACCESS to SAP HANA
30DEC2017
---SAS/ACCESS Interface to the PI System
30DEC2017
NOTE: PROCEDURE SETINIT used (Total process time):
real time 42.32 seconds
cpu time 0.32 seconds

 

I bolded where it says SAS/ACCESS to MYSQL. So I'm assuming it's installed, I just wanted to double check with you to make sure I did it right.

Reeza
Super User

SetINIT tells you what you're licensed for, so this means you have a valid license. 

PRODUCT_STATUS will tell you what's actually installed so you need to check that one as well.

VocanyP
Fluorite | Level 6

This was part of the output from running proc product_status

 

For SAS/ACCESS Interface to MySQL ...
Custom version information: 9.4_M4

 

I'm assuming this means that it is also installed, correct?

 

And thanks again for all your help.

Reeza
Super User

Yes, looks correct to me 🙂

 

daniel_ward
Calcite | Level 5

SAS offers extensive support to most of the popular relational databases by using SQL queries inside SAS programs. Most of the ANSI SQL syntax is supported. The procedure PROC SQL is used to process the SQL statements. This procedure can not only give back the result of an SQL query, it can also create SAS tables & variables. Base SAS Certification questions

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 connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 6 replies
  • 2613 views
  • 2 likes
  • 3 in conversation