SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS/ACCESS Interface to MYSQL

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

SAS/ACCESS Interface to MYSQL

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.


Accepted Solutions
Solution
‎06-22-2017 03:20 PM
Super User
Posts: 19,772

Re: SAS/ACCESS Interface to MYSQL

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 Smiley Wink

 

Documentation reference is here:

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

View solution in original post


All Replies
Solution
‎06-22-2017 03:20 PM
Super User
Posts: 19,772

Re: SAS/ACCESS Interface to MYSQL

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 Smiley Wink

 

Documentation reference is here:

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

New Contributor
Posts: 3

Re: SAS/ACCESS Interface to MYSQL

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.

Super User
Posts: 19,772

Re: SAS/ACCESS Interface to MYSQL

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.

New Contributor
Posts: 3

Re: SAS/ACCESS Interface to MYSQL

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.

Super User
Posts: 19,772

Re: SAS/ACCESS Interface to MYSQL

Yes, looks correct to me Smiley Happy

 

New Contributor
Posts: 2

Re: SAS/ACCESS Interface to MYSQL

[ Edited ]

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

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