Runs a script basic routine to issue a DML command. The connection must be specified in the Scriptbasic INI file.
Proc SQL - DML command syntax
proc SQL db=DBNAME;
connect CONNECT;
DML;
Proc SQL - DML parameters used
There are three primary parameters for the Proc SQL DML statement:
CONNECT - the name of the mysql connection defined in the Script basic INI file
DBNAME - always MYSQL when running a DML statement against a MySQL database
DML - the text of the DML command
DML example script
*;
*;
* mydml1.ezs;
* Proc SQL to perform mysql dml handling;
*;
libname test 'c:\test\model';
libname drug 'c:\cloop\data';
proc sql db=mysql;
connect test;
drop 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.