PHP Classes
elePHPant
Icontem

SAS to MySQL: Extract data dictionaries from SAS file into MySQL

Recommend this page to a friend!
  Info   View files Example   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2017-08-08 (4 months ago) RSS 2.0 feedNot yet rated by the usersTotal: 54 All time: 9,035 This week: 623Up
Version License PHP version Categories
sas2sql 1.0Freely Distributable5PHP 5, Databases, Files and Folders, P...
Description Author

This class can extract data dictionaries from SAS file into MySQL.

It can parse SAS files and extract values of data dictionaries (Format, Input, Label).

The class creates a table on MySQL database to insert the extracted data.

It replaces numeric data values with full text data.

The class can optimize data replacing VARCHAR default into appropriate INT or ENUM for easier data browsing. It also split tables along columns when there are too many columns during optimization.

Innovation Award
PHP Programming Innovation award nominee
January 2017
Number 12
SAS is a programming language used for statistical analysis.

Its source code may include the definition of arrays of data, also known as data dictionaries.

This package can extract data dictionaries from SAS files into a MySQL database.

Manuel Lemos
  Performance   Level  
Name: Greg Neyman <contact>
Classes: 1 package by
Country: United States United States
Age: 40
All time rank: 4142465 in United States United States
Week rank: 916 Up89 in United States United States Up
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files  
File Role Description
Accessible without login Plain text file example.php Example Example Script
Plain text file sas2sql.php Class Class Source

 Version Control Unique User Downloads Download Rankings  
 0%
Total:54
This week:0
All time:9,035
This week:623Up