Output Tables
About Output Tables
When you create a data query, you specify an output table on the Outputs tab in the right pane. When you save the data query, the output table is registered
(or updated) in the metadata. Registering the table in metadata enables you to use it as a source table for another data query or another SAS application. When you run the data query, the physical output table is created, and the table
is updated in metadata.
Subqueries do not require an output table. If you do not need to view the results
of a data query that you intend to use as a subquery, then you can click Clear on
the Outputs tab and still save the subquery. You can then drag and drop the subquery into a data query.
When you create a data query, the default output table name is OutputTable.
Specify an Output Table
Every data query must have an output table in order to save the results in a table.
How you specify the output table affects
whether metadata is updated or created.
You can specify an output table name, location, and library on the Outputs tab
in the right pane.
The following table
shows alternative ways to specify an output table.
|
Action
|
How To
|
|---|---|
|
Change the name of the output table. 1
|
Enter the new name in
the Table field, and save the data query. All data queries, reports, explorations, and so on,
still reference the same table
object.
|
|
Create a new output table. 1
|
Click Clear, and then specify a table name, location, and library. This action disassociates
the previously used output table.
|
|
Reuse an existing table.
|
Click
 , and then browse for the table to use. This action disassociates the previously used output table.
|
| 1If you replace the default table name, OutputTable, with another name before you save the data query, the data builder registers a new output table and uses it with the data query. | |
You can enter a name that is up to 32 characters as the output table name. If a third-party vendor database product is used for the output table, then the number of characters might be less.
If
you select a SAS LASR Analytic Server
or SASHDAT library, the Partition by menu becomes available.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: January 8, 2019