SAS/CONNECT User's Guide

Example 3. DTS: Transferring Specific Catalog Entry Types

Purpose

When you include the INCAT= and OUTCAT= options in the PROC UPLOAD or PROC DOWNLOAD statement, you can specify which entry types to transfer by using the ENTRYTYPE= option in one of the following statements:

PROC UPLOAD
PROC DOWNLOAD
SELECT
EXCLUDE.

If you omit the ENTRYTYPE= option and also omit the SELECT and EXCLUDE statements, all catalog entries are transferred.

Programs

Example 3.1: Using the ENTRYTYPE= Option in the PROC UPLOAD Statement

This example uploads all SLIST catalog entries from the CAT catalog in the library LOCLIB on the local host and stores them in the catalog UPCAT in the library REMLIB on the remote host:

proc upload incat=loclib.cat 
   outcat=remlib.upcat entrytype=slist;
run;

Example 3.2: Using the ENTRYTYPE= Option in the EXCLUDE Statement in PROC DOWNLOAD

This example downloads all catalog entries except the format entries XYZ and GRADES, which are in the catalog REMOTE.MAIN_FORMATS on the remote host and stores them in the catalog LOCAL.SECONDARY_FORMATS on the local host:

proc download incat=remote.main_formats
   outcat=local.secondary_fomats;
   exclude xyz grades / entrytype=format;
run;

Example 3.3: Using the ENTRYTYPE= Option in the SELECT Statement in PROC UPLOAD

If the default library is WORK, this example uploads the FORMAT catalog entries XYZ and ABC, the INFMT catalog entry GRADES, and the SCL entries A and B, which are in the WORK.LOCFMT catalog on the local host and stores them in the WORK.REMFMT catalog on the remote host:

proc upload incat=locfmt outcat=remfmt;
   select xyz.format grades 
      abc (et=format) / et=infmt;
   select a b / et=scl;
run;

Example 3.4: Using the ENTRYTYPE= Option in Two SELECT Statements

This example maintains the original ordering and grouping when transferring catalog entries that contain graphics output. Assume that you have a catalog named FINANCE that has two entries that contain graphics output, INCOME and EXPENSE. You want to download the two catalog entries that contain graphics output in the order in which they are stored on the remote host; that is, you want INCOME to appear before EXPENSE, not alphabetically as the DOWNLOAD procedure would normally transfer them.

In addition, you have some catalog entries that are grouped by the name GROUP1, and you want to preserve the grouping when the entries are downloaded. Remote submit the following program to transfer these entries in the order that you specify in the first SELECT statement and in the group that you specify in the second SELECT statement:

proc download incat=rhost.finance 
   outcat=lhost.finance;
   select income expense et=grseg;
   select group1;
run;

Example 3.5: Using Long Member Names in Catalog Transfers

This example uses PROC UPLOAD to transfer catalogs by using the INCAT= and/or OUTCAT= options:

rsubmit;
   proc upload 
      incat=loclib.monthlysalary 
      outcat=monthlyupdate;
   run;
   proc upload 
      incat=loclib.employeedata 
      outcat=remlib.cat;
   run;

   proc upload incat=sasuser.base
      outcat = remlib.basecatalog;
   run;

endrsubmit;

Chapter Contents
Previous
Next
Top of Page