SAS/CONNECT User's Guide

Example 2. DTS: Transferring Specific Member Types by Using SELECT or EXCLUDE Statements

If you include the INLIB= and OUTLIB= options in the PROC UPLOAD or PROC DOWNLOAD statements, you can specify which member types to transfer by using the MEMTYPE= option in one of the following statements:

PROC UPLOAD
PROC DOWNLOAD
SELECT
EXCLUDE.

Valid values for the MEMTYPE= option are DATA, CATALOG (or CAT), MDDB view, FDB, DBDB, and ALL. If you use this option in the EXCLUDE statement, you can specify only one value. If you use this option in the PROC UPLOAD or the PROC DOWNLOAD statement, you can specify a list of MEMTYPE values enclosed in parenthesis.

Programs

Example 2.1: Using the MEMTYPE= Option in the PROC UPLOAD Statement

This example uploads all catalogs and data sets that are in the library THIS on the local host and stores them in the library THAT on the remote host.

proc upload inlib=this outlib=that 
   memtype=(data catalog);

Example 2.2: Using the MEMTYPE= Option in the EXCLUDE Statement

This example uploads all catalogs and data sets except the data sets that are named Z4, Z5, Z6, and Z7 that are in the library LOCLIB on the local host and stores them in the library REMLIB on the remote host:

proc upload inlib=loclib outlib=remlib mt=all;
   exclude z4-z7 / memtype=data;
run;

Example 2.3: Using the MEMTYPE= Option in the SELECT Statement

This example downloads the catalogs NAMES and SALARY and the data set MEDIA in the data library REMLIB on the remote host and stores them in the library LOCLIB on the local host:

proc download inlib=remlib outlib=loclib;
   select names salary media(mt=data) / memtype=cat;
run;

Chapter Contents
Previous
Next
Top of Page