Using the query from
the last example, you can build a new table from the 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
FileCreate 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
ToolsReset to reset your query. Select
OK from the
dialog box that appears. Note that SAMPLE.WAGE is now in the Available
Tables list.
