Building and Adding Tables

Using the query from the last example, you can build a new table from the results.

In the SQL QUERY COLUMNS window, select View  Tablesto return to the SQL QUERY TABLES window.

From the SQL QUERY TABLES window, select File  Create Table from Query Results

Select the right arrow next to the Library field to display a list of available libraries.

You can also type the library name in the Library field.

Select SAMPLE to include your new table in the SAMPLE library.

Note:   If you do not have write access to the SAMPLE library, then select SASUSER instead.  

Type WAGE in the Table field.

Type Hourly Wages in the Label field.

Select OK to return to the SQL QUERY TABLES window.

Select Tools  Resetto reset your query. Select OK from the dialog box that appears. Note that SAMPLE.WAGE is now in the Available Tables list.

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