SAS/CONNECT User's Guide

Non-English Keyboards

If SAS/CONNECT is used frequently, you should use an alternate EBCDIC/ASCII translation table (TRANTAB=) on the remote host. The SAS Software Representative for the remote host should create the alternate table.
If SAS/CONNECT is not used frequently, you can manage problematic characters by assigning the correct hex values in DATA step programming statements after the file is copied.
For example, suppose you have a German keyboard and a CMS host. You want a file to contain umlaut-A characters after an upload. By default, the ASCII representation of umlaut-A, which is X'84', is translated to EBCDIC X'24'. However, the EBCDIC representation of umlaut-A is X'C0', so you need to translate EBCDIC X'24' to EBCDIC X'C0'. The following DATA step, in which NAME is a variable that contains umlaut-A characters, performs this translation:
```
data new;
   set old;
   retain to 'C0'x from '24'x;
   drop to from;
   name=translate(name,to,from);
run;
```