SAS/CONNECT User's Guide

The UPLOAD and the DOWNLOAD Procedures

The following sections describe several enhancements that have been made to the UPLOAD and DOWNLOAD procedures. For more information about PROC UPLOAD and PROC DOWNLOAD, see The UPLOAD Procedure and The DOWNLOAD Procedure.

Translation Technique

When both the local host and the remote host are running Version 7 or a later release of SAS/CONNECT software, the translation rules have changed. First, no translation occurs if both the remote and local hosts have the same machine representations. This prevents any unnecessary translation from occurring. If translation is needed, the receiving host translates the data directly into its native representation. So, when both the local and remote hosts are Version 7 or later, the data is translated only once when translation is necessary and is not translated when both hosts have the same machine architecture.

Using Wildcard Characters When Transferring Files

SAS/CONNECT supports the use of an asterisk (*) as a wildcard character for transferring external text files or external binary files. The wildcard character may be used with the INFILE= option to send

all files in a specific library (*).
all files with a specific extension (*.extension).
all files with the same name, but different extensions (name.*).

Transferring SAS Files

The list of member types that can be transferred by using the MEMTYPE= option has been expanded to include:

DATA (SAS data files)
CATALOG|CAT (SAS catalogs)
VIEWS (SQL views)
MDDB (multi-dimensional database)
FDB (financial database)
DMDB (data mining database)
_ALL_ (all files in the library).

New Options

For PROC UPLOAD and PROC DOWNLOAD, you can use the following new options to help identify the files that will be transferred, the translation tables to use, and the transfer technique.

AFTER=: specifies that files are to be transferred only if they were modified on or after a specific date.
EXTENDSN=: specifies whether or not to promote the length of short numerics.
TRANIN=: specifies a translation table to be used when transferring a data set that is stored in a different data representation than that of the local host.
TRANNET=: specifies a translation table to be used when transferring a data set between local and remote hosts that have different machine architectures.
TRANOUT=: specifies a translation table to be used when you are transferring a data set, and the OUTREP= data set option indicates a data representation different from the native data representation of the target host.
V6TRANSPORT: specifies that data should be translated from a local format to a transport format. (The receiving host then translates the data from the transport format to a local format.)

Chapter Contents
Previous
Next
Top of Page