Specifies a path for creating a flat file for bulk loading.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | none |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Data source: | Aster |
| Note: | Support for this data set option was added for SAS 9.4. |
| See: | BULKLOAD= data set option |
Table of Contents
specifies that SAS creates one or more temporary tables.
When you use this option to specify the path, it uses the automatically generated file name where the temporary flat file is created for bulk loading. If you do not specify this option, a file is created in the temporary file directory that is specified by the UTILLOC= system option.
libname dblib aster dsn=ncluster uid=user pwd=password dimension=yes;
data dblib.class (BULKLOAD=YES BL_DATAFILE_PATH=’C:\temp\’);
set sashelp.class;
run;