Open an existing
data query from the SAS Folders
tree that closely matches the data query that you want to create. Click
, and then enter a new name and select a location.
Perform any customizations.
In many cases, you want to use the same input tables, joins, and so on, but you want
a different
output table. In this case, click
Clear on
the
Outputs tab, and then specify new output table information. This step ensures that you use
a different output table for the copied data query.
Note: If you change only the name
of the output table in the copied data query, then the name of the
original output table in the original data query is also changed.
For example, an analyst
creates a data query that summarizes sales data and includes several
geographic regions. The data query is saved with an output table that
is named Sales
. A regional sales manager
wants to perform a similar summarization, but he wants to filter the
data for a single geographic region. In this case, the regional sales
manager performs the following steps:
-
Opens the analyst's data query, and clicks
to save a copy of the data query with a new name.
-
Filters the data on
the Where or Having tab
for the geographic region.
-
Clicks Clear on
the Outputs tab, and then specifies new output table information. This ensures that the original
output table, Sales
, for the original data query is not overwritten.
-
Saves and runs the copied data query.