The Little SAS® Book for Enterprise Guide® 4.1

2.9. Sorting Data Tables

There is little need for you to sort data in SAS Enterprise Guide. If a task requires data to be sorted, it will usually sort the data automatically. However, there may be times when you want to sort the data yourself. If you have a large data table, for example, you may want to store the data in sorted order. With the data presorted, SAS Enterprise Guide will not have to sort the data and your tasks will run more quickly. At other times, you may want to sort data to make it easier to find values in a Data Grid, or to eliminate duplicate rows.

There are two ways to sort data in SAS Enterprise Guide: the Sort task or a query. The Sort task gives you more control over how the data are sorted, whereas a query has other ...