Examples

Building and Adding Tables

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

Creating a Table from Query Results

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

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

[Creating a table from query results]

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

[Selecting a library]

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. [cautionend]

Select OK.

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 Reset to reset your query. Select OK from the dialog box that appears. Note that SAMPLE.WAGE is now in the Available Tables list.

[SAMPLE.WAGE in Available Tables list]

Top of Page