The DBLOAD Procedure for Relational Databases PROC DBLOAD Statement 315
PROC DBLOAD <options>;
database connection statements;
TABLE= <’>table-name<’>;
ACCDESC= <libref.>access-descriptor;
COMMIT= commit-frequency;
DELETE variable-identifier-1
<…variable-identifier-n>;
ERRLIMIT= error-limit;
LABEL;
LIMIT= load-limit;
LIST <ALL | COLUMN | variable-identifier>;
NULLS variable-identifier-1 =Y|N
<…variable-identifier-n =Y|N>;
QUIT;
RENAME variable-identifier-1 =<’>column-name-1<’>
<…variable-identifier-n =<’>column-name-n<’>>;
RESET ALL | variable-identifier-1<…variable-identifier-n>;
SQL DBMS-specific-SQL-statement;
TYPE variable-identifier-1 = ’column-type-1’ <…variable-identifier-n = ’column-type-n’>;
WHERE SAS-where-expression;
LOAD;
RUN;
PROC DBLOAD Statement
PROC DBLOAD <options>;
Options
DBMS=database-management-system
specifies which database management system you want to access. This DBMS-specific
option is required. See the SAS/ACCESS documentation for your DBMS.
DATA=<libref.>SAS-data-set
specifies the input data set. The input data can be retrieved from a SAS data file, a
PROC SQL view, a DATA step view, a SAS/ACCESS view descriptor, or another
DBMS table that is referenced by a SAS/ACCESS libref. If the SAS data set is
permanent, you must use its two-level name, libref.SAS-data-set. If you omit the
DATA= option, the default is the last SAS data set that was created.
APPEND
