DBLOAD Procedure

LOAD Statement

Creates and loads the new DBMS table

Restriction: in the DBLOAD procedure (required statement for loading or appending data)
Requirements: This statement is required to create and load a new DBMS table or to append data to an existing table.
When you create and load a DBMS table, you must place statements or groups of statements in a certain order after the PROC DBLOAD statement and its options, as listed in Statement Sequence for Accomplishing Common Tasks.
Note: The LOAD statement informs the DBLOAD procedure to execute the action that you request, including loading or appending data.
Example: This example creates the SummerTemps table in Oracle based on the DLib.TempEmps data file. 
proc dbload dbms=oracle data=dlib.tempemps;
    user=myusr1; password=mypwd1; path='mysrv1';
    table=summertemps; rename firstnam=firstname middlena=middlename;
    type hiredate 'date' empid 'number(6,0)' familyid 'number(6,0)';
    nulls 1=n; list; load;
run;

Syntax

LOAD;
Last updated: February 3, 2026