Chapter Contents

Previous

Next
SAS/ACCESS Interface to SYSTEM 2000 Data Management Software: Reference

Sorting Output

In addition to selecting specific data, you can specify the output order for data. This is done by specifying a SYSTEM 2000 ordering-clause, which consists of sort keys, separated by commas. A sort key can be a schema item or a schema record. You can also specify for each sort key whether the output is to be ordered in ascending order or in descending order. For example, the output produced by the following ordering-clause is first sorted by LAST NAME (C2) in ascending order (the default) and then by YEARS OF EXPERIENCE (C203) in descending order (due to the HIGH specification):

    OB C2, HIGH C203

For the SAS/ACCESS interface to SYSTEM 2000 software, you can specify data order by including a SYSTEM 2000 ordering-clause when you create a view descriptor. In addition, you can specify data order in a SAS program using a SAS BY clause. Note, however, that a SAS BY clause overrides a SYSTEM 2000 ordering-clause stored in a view descriptor. For more information on SYSTEM 2000 ordering-clauses, see SYSTEM 2000 Ordering-clause.


Chapter Contents

Previous

Next

Top of Page

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