Data Set Options for Relational Databases |
Default value: | NO |
Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
DBMS support: | Oracle |
Syntax | |
Syntax Description | |
Details | |
See Also |
Syntax |
BL_PRESERVE_BLANKS=YES | NO |
specifies that blank values are inserted as blank spaces.
When this option is set to YES, any trailing blank spaces are also inserted. For this reason, use this option with caution. It is recommended that you set this option to YES only for CHAR columns. Do not set this option to YES for VARCHAR2 columns because trailing blank spaces are significant in VARCHAR2 columns.
Details |
To specify this option, you must first set BULKLOAD=YES.
Operating Environment Information: This option is not supported on z/OS.
See Also |
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.