Indicates whether to use a map file to load or export tables.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | NO |
| Requirement: | To specify this option, you must first set BULKLOAD=YES or BULKUNLOAD=YES. |
| Data source: | Aster |
| Note: | Support for this data set option was added for SAS 9.4. |
| See: | BULKLOAD= LIBNAME option, BULKLOAD= data set option, BULKUNLOAD= LIBNAME option, BULKUNLOAD= data set option |
Table of Contents
specifies that a map file is used.
specifies that a map file is not used.
You can use this option to pass connection and table information in a text (map) file to the loader or export application during bulk loading or unloading. The SAS/ACCESS engine automatically creates and deletes the map file for each bulk loading or unloading.
SAS uses the sasflt.flt98 map file in this example to provide the needed connection and table information for bulk loading.
LIBNAME sasflt 'SAS-data-library';
LIBNAME net_air ASTER user=myusr1 pwd=mypwd1
server=air2 database=flights dimension=yes;
data net_air.flights98
(bulkload=YES bl_mapfile=yes);
set sasflt.flt98;
run;