SAS/CONNECT User's Guide

Syntax for the TRANTAB Statement

TRANTAB NAME=translation-table-name

<TYPE=(etype-list)>

<OPT=DISP SRC (DISP SRC)>;

The TRANTAB statement enables you to specify translation tables to use for translating characters in catalog entries that you want to upload. The TRANTAB statement also enables you to specify the particular types of SAS/AF or SCL catalog entries to which you want to apply a translation. You can specify one translation table per statement, but there is no limit to the number of TRANTAB statements you can use in one invocation of the UPLOAD procedure. If you specify the TRANTAB statement, you must also specify the INCAT= and OUTCAT= options in the PROC UPLOAD statement.

Requirements for the TRANTAB Statement

A TRANTAB statement must include the following argument:

NAME=translation-table-name

specifies the name of the translation table to apply to the SAS catalog that you want to upload. The translation-table-name that you specify is the name of a catalog entry in either your SASUSER.PROFILE catalog or the SASHELP.HOST catalog. The UPLOAD procedure searches the SASUSER.PROFILE catalog first, and the SASHELP.HOST catalog second.

See TRANTAB= for more information about translation tables.

By default, whenever you invoke PROC UPLOAD, the procedure uses the table that translates host-to-transport format. In most cases, the default translation table is the correct one to use, but you may need to apply additional translation tables if, for example, your application requires different national language characters.

You can specify a translation table other than the default in two ways:

To specify a translation table for an invocation of PROC UPLOAD, use the TRANTAB statement in the UPLOAD procedure.
To specify a translation table for your entire SAS session or job (including all file transfers that you do), use the TRANTAB= system option. You use this system option to define which default translation tables to use in place of those that are supplied by SAS Institute.

See the SAS Procedures Guide for information about creating translation tables by using PROC TRANTAB.

Options for the TRANTAB Statement

You can use the following options in the TRANTAB statement:

TYPE=(etype-list)

specifies that the UPLOAD procedure apply the translation table only to the entries with the type or types that you specify. Note that etype-list can be one or more entry types. If etype-list is a simple entry type, omit the parenthesis.

By default, the UPLOAD procedure applies the translation table to all of the entries in the catalog that you specify.

OPT=DISP SRC (DISP SRC)

specifies one of the following:

When OPT=DISP, the UPLOAD procedure applies the translation table only to those entries of the catalog that you specified, which produce window displays.
When OPT=SRC, the UPLOAD procedure applies the translation table only to those entries of the catalog you specified that are of the type SOURCE.
When OPT=(DISP SRC), the UPLOAD procedure applies the translation table only to those entries of the catalog that you specified that either produce window displays or have a type of SOURCE.

When you do not specify the OPT= option, the UPLOAD procedure applies the translation table to all of the entries in the catalog that you specify.

Chapter Contents
Previous
Next
Top of Page