O'Reilly logo

The Little SAS® Book for Enterprise Guide® 4.1 by Lora D. Delwiche, Susan J. Slaughter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

4.2. Sorting Data in a Query

If all you want to do is create a sorted version of a data table, then you might want to use the Sort task (discussed in section 2.9). But, if you also want to select columns, filter the data, or create new columns, then you can do all of these in the Query Builder.

Here is a sample of the data table created in the previous section. This table contains the Volcano, Country, Region, and Height columns from the Volcanoes data table, and is currently sorted by the name of the volcano. To sort these data using the Query Builder, re-open the query by right-clicking the Query for Volcanoes icon in the Project Explorer or Project Designer and selecting Open. The Query Builder opens with the Select Data tab on top. Click ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required