On the
Properties tab,
you can specify the following properties:
Name
displays the name for
the query.
Location
displays 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 tab
when the check box is selected.
For more information,
see Customizing Code.
Table
specifies the table
name for either the staging output or the final output.
Location
specifies the metadata
folder location to use for registering the staging table or output
table metadata.
Library
specifies the library
to use for the staging table or output table.
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.