Specifies the translation tables that are used by various parts
of the SAS System.
|
TRANTAB=(translation-tables)
|
- translation-tables
- specifies the translation tables that are used by various
parts of the SAS System.
Details
The TRANTAB= system option specifies a translation table for your SAS session
or job and includes all file transfers. The process in which data is translated
between a local SAS session and a remote SAS session has changed in Version
7 and later versions. However for compatibility, the translation process that
was used in Version 6 has been retained.
- In Version 6, translation occurs twice for every
transmission. The data is translated from local to transport format, and
then the receiving side translates from transport format to local format.
Two translations occur for all data that is transferred.
- In Version 7 and later versions, when both the
local and remote sides run Version 7 or later, the translation rules have
changed. First, no translation occurs if both the remote and local sides
have the same machine representations. This prevents any unnecessary translation
from occurring. If translation is needed, the receiving side translates the
data directly into its native representation. So when both the local and
remote sides run Version 7 or later, the data is only translated once when
translation is necessary, and is not translated at all when both hosts have
the same machine architecture.
Due to this change in the translation process, the functionality
of TRANTAB has also been changed. In Version 7 and later of SAS/CONNECT, you
have the ability to provide a translation table for three possible translation
points.
- On the input file's host when translating from
the format of the file into the native format of the input host. You can specify
a translation table on the first translation point by either specifying TRANTAB=
as a data set option on the input file or by specifying the TRANIN option
in the PROC UPLOAD or the PROC DOWNLOAD statement.
- On the output file's host when translating from
the format of the received observations into the native format of the output
host. The only way to specify the translation table for the second translation
point is by specifying TRANNET= in the PROC UPLOAD or the PROC DOWNLOAD statement.
- On the output file's host when translating the
observations from native format to some other specified format. This third
point of translation only occurs when writing to a format other than the native
host, that is, OUTREP must be specified. You can specify a translation table
on the third translation point by either specifying TRANTAB= as a data set
option in the output file or by specifying the TRANOUT= option in the PROC
UPLOAD or the PROC DOWNLOAD statement.
For Version 6 style of translation, translation tables
are specified in a parenthetical list that has eight positions. The position
in which a table appears in the list determines the type of translation table
that is being specified. Individual entries in the following list are separated
by commas. See the following list of positions and types:
| Position |
Type of Translation Table |
| first |
local-to-transport-format |
| second |
transport-to-local-format |
| third |
lowercase-to-uppercase |
| fourth |
uppercase-to-lowercase |
| fifth |
character classification |
| sixth |
scanner translation |
| seventh |
delta characters |
| eighth |
scanner character
classification |
Note: The Version 6 style applies only
when translating from Version 7 or Version 8 to an earlier version, or when
the V6TRANSPORT option is used between a local and a remote session that uses
a Version 7 or later version. ![[cautionend]](../common/images/cautend.gif)
The SAS System tries to locate the catalog entries that
contain the translation tables first in SASUSER.PROFILE and then in SASUSER.HOST.
- CAUTION:
- Changing Translation Tables.
Do
not change translation tables unless you are familiar with their purpose.
Translation tables are used internally by the SAS supervisor to implement
National Language Support (NLS). If you are unfamiliar with the purpose of
translation tables, do not change the specifications without technical advice.
To change one table, specify null entries for the other
tables. For example, to change the lowercase-to-uppercase table, which is
third in the list, specify the following:
options trantab = ( , , new-uppercase-table);
The other tables remain unchanged. The output from PROC
OPTIONS reflects the last specification for the TRANTAB option and not the
composite specification. For example:
options trantab = ( , , new-uppercase-table);
options trantab = ( , , , new-lowercase-table);
PROC OPTIONS shows that the value for TRANTAB is ( ,
, , new-lowercase-table), but both the new-uppercase
and new-lowercase tables are in effect.
For more information about the TRANTAB procedure, see
the SAS Procedures Guide.
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
