On the
Properties panel,
you can specify the following properties:
Name
specifies the name
for the query.
Location
specifies the metadata
folder location for the query object.
Description
specifies a description
of the query.
Unique values
specifies whether the
SQL keyword DISTINCT is applied to the select statement that is used
to generate the result set for the query.
Append data
specifies whether the
result set for the query is appended to the output table. If a staging
table is used, then the staging table is replaced with the result
set before appending to the output table.
Manual code
specifies that the
query uses the SQL that is written by the user on the
Code
view when the check box is selected.
For more information,
see Editing Code.
Input library
specifies the library
that is used for selecting source tables. A query can use tables from
a single input library only.
For
more information, see Best Practices for Input Libraries.
Table
specifies the table
name for either the staging output or the final output.
Library
specifies the library
to use for the staging table or the output table.
Location
specifies the metadata
folder location to use for registering the staging or output table
metadata.
Partition by
specifies
the column to use for partitioning the output table. This property
applies when the output table is in a SAS LASR Analytic Server
library or SAS Data in HDFS library only.
For more information,
see Partitioning Tables.