Extract data dictionaries from SAS file into MySQL
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.
This class can calculate statistics on weighted data sets.
It can take as parameters one data set array with numeric values and another array with the respective weights for the values in the first parameter array.
The class can calculate several types of common statistics on the data set values considering the weight values, like: the mean, average, standard deviation, percentile and skew.