With built-in dynamic metadata querying, you can easily visualize and analyze MySQL data in SAS. When you issue complex SQL queries from SAS to MySQL, the driver pushes supported SQL operations, like filters and aggregations, directly to MySQL and utilizes the embedded SQL engine to process unsupported operations (often SQL functions and JOIN operations) client-side. The CData ODBC Driver offers unmatched performance for interacting with live MySQL data in SAS due to optimized data processing built into the driver. This articles walks through creating a library for MySQL in SAS and creating a simple report based on real-time MySQL data. When you pair SAS with the CData ODBC Driver for MySQL, you gain database-like access to live MySQL data from SAS, expanding your reporting and analytics capabilities. SAS is a software suite developed for advanced analytics, multivariate analysis, business intelligence, data management, and predictive analytics.
