SAS/CONNECT User's Guide

Example 9. DTS: Transferring SAS Utility Files

By using the INLIB= and OUTLIB= options with PROC UPLOAD or PROC DOWNLOAD in SAS/CONNECT, multiple SAS files may be transferred in a single step. This capability enables you to transfer an entire library or selected members of a library. 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.

If you use this option in the SELECT or 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.

Note: The INLIB= option must be used with the OUTLIB= option, but you can use any form (INLIB=, IN=, INDD=) of the INLIB= option with any form (OUTLIB=, OUT=, OUTDD=) of the OUTLIB= option. Also, any form (MEMTYPE=, MT=, MTYPE=) of the MEMTYPE= option may be used. [cautionend]

Purpose

Previously, the only SAS files that were supported for transfer by using the method described above were SAS data sets and catalog files. This new feature also supports transfer of SQL views, MDDB files, FDB files, and DMDB files. Valid values of the MEMTYPE= option now include:

DATA (SAS data sets)
CATALOG or CAT (catalog files)
VIEW (SQL views)
MDDB (MDDB files)
FDB (FDB files)
DMDB (DMDB files)
ALL (all of the above).

Programs

Example 9.1: Using the INLIB= Option in the PROC DOWNLOAD Statement

This example downloads all SAS data sets, catalog files, SQL views, MDDB files, FDB files, and DMDB files in the library WORK on the remote host and stores them in the library WORK on the local host:

proc download inlib=work outlib=work;

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

This example uploads all MDDB and FDB files 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=(mddb fdb);

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

This example downloads the DMDB files TEST1 and TEST2 and the SAS data set TEST3 that are in the library WORK on the remote host and stores them in the library LOCAL on the local host:

proc download inlib=work outlib=local;
   select test1 test2 test3(mt=data)/memtype=dmdb;
run;

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

This example uploads all SAS data sets, catalog files, MDDB files, FDB files, DMDB files, and SQL views except the SQL views A1, A2, A3 that are in the library LOCAL on the local host and stores them in the library REMOTE on the remote host:

proc upload inlib=local outlib=remote memtype=all;
   exclude a1-a3/memtype=view;
run;

Chapter Contents
Previous
Next
Top of Page