Runs a script basic routine which invokes the MYSQL command LOAD DATA LOCAL INFILE.
Proc SQL Syntax
proc sql data=DATAFILE db=DBTYPE;
connect CONNECT;
table TABLENAME;
Proc SQL - Parameters Used
There are four primary parameters for the load statement:
DATAFILE - the datafile to be loaded
DBTYPE - type of database, always 'mysql'
CONNECT - the mysql connection parameter name in the Scriptbasic ini file
TABLENAME - name of the table to be loaded with data
Proc SQL - Example Script
*;
* myload1.ezs;
* Proc SQL for data load handling;
* ;
libname test 'c:\test\model';
libname drug 'c:\cloop\data';
proc sql data = test.b db=mysql;
connect test;
table x;
The Proc SQL procedure is part of EZ-R Stats for Windows.
Analysts interested in Proc SQL may also be interested in Proc Means, Proc Outlier, Proc Benford and Proc Univariate.