topic Re: SAS/ACCESS Interface to MYSQL in SAS Data Management

SAS/ACCESS Interface to MYSQL

VocanyP — Thu, 22 Jun 2017 18:02:09 GMT

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.

Re: SAS/ACCESS Interface to MYSQL

Reeza — Thu, 22 Jun 2017 18:23:45 GMT

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#n1lyg1d0crcejin1v7zaeteeniuu.htm

Re: SAS/ACCESS Interface to MYSQL

VocanyP — Thu, 22 Jun 2017 18:31:22 GMT

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.

Re: SAS/ACCESS Interface to MYSQL

Reeza — Thu, 22 Jun 2017 18:44:38 GMT

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.

Re: SAS/ACCESS Interface to MYSQL

VocanyP — Thu, 22 Jun 2017 19:12:13 GMT

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.

Re: SAS/ACCESS Interface to MYSQL

Reeza — Thu, 22 Jun 2017 19:19:43 GMT

Yes, looks correct to me 🙂

Re: SAS/ACCESS Interface to MYSQL

daniel_ward — Thu, 17 May 2018 12:04:10 GMT

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