SORTSEQ= Data Set Option

Syntax Description

collation-sequence

specifies the collating sequence that the SORT procedure uses for the specified SAS data set. Valid values can be user-supplied, or they can be one of the following:

• ASCII

• DANISH (alias NORWEGIAN)

• EBCDIC

• FINNISH

• ITALIAN

• NATIONAL

• POLISH

• REVERSE

• SPANISH

• SWEDISH

If you want to create or change a collating sequence, use the TRANTAB procedure to create or modify translation tables. When you create your own translation tables, they are stored in your PROFILE catalog, and they override any translation tables with the same name that are stored in the HOST catalog.

Note:   System managers can modify the HOST catalog by copying newly created tables from the PROFILE catalog to the HOST catalog. All users can access the new or modified translation tables.  

If you are in a windowing environment, use the Explorer window to display the SASHELP.HOST catalog. In the HOST catalog, entries of type TRANTAB contain collating sequences that are identified by the entry name.

If you are not in a windowing environment, issue the following statements to generate a list of the contents of the HOST catalog. Collating sequences are entries of the type TRANTAB.

proc catalog catalog=sashelp.host; 
   contents; 
run;

To see the contents of a particular translation table, use these statements:

proc trantab table=translation-table-name;
   list;
run;

The contents of collating sequences are displayed in the SAS log.

Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.