The DBLOAD Procedure for Relational Databases RENAME Statement 321
Details
Note: Some DBMSs have three valid values for this statement, Y, N, and D. See the
SAS/ACCESS documentation for your DBMS for further details.
The NULLS statement specifies whether the DBMS columns that are associated
with the listed input SAS variables allow null values. Specify Y to accept null values.
Specify N to reject null values and to require data in that column.
If you specify N for a numeric column, none of the observations that contain missing
values in the corresponding SAS variable are loaded into the table, and a message is
written to the SAS log. The current error count is increased by one for each observation
that is not loaded. See “ERRLIMIT Statement” on page 318 for more information.
If a character column contains blanks (the SAS missing value) and you have specified
N for the DBMS column, then blanks are inserted. If you specify Y, null values are
inserted.
The variable-identifier argument can be either the SAS variable name or the
positional equivalent from the LIST statement. The positional equivalent is the number
that represents the variable’s place in the data set. For example, if you want the
column that is associated with the third SAS variable to accept null values, submit the
following statement:
nulls 3=y;
If you omit the NULLS statement, the DBMS default action occurs. You can list as
many variables as you want in one NULLS statement. If you have previously defined a
column as NULLS=N, you can use the NULLS statement to redefine it to accept null
values.
QUIT Statement
Terminates the procedure
Valid: in the DBLOAD procedure (control statement)
QUIT;
Details
The QUIT statement terminates the DBLOAD procedure without further processing.
RENAME Statement
Renames DBMS columns
Interacts with: DELETE, LABEL, RESET
RENAME variable-identifier-1 =<’>column-name-1<’> <…variable-identifier-n =
<’>column-name-n<’>>;
