Specify Properties for a Data Query
On the Properties tab,
you can view or specify the following properties:
Name
displays the name for
the data query. The initial value is DataQuery1. You can specify a
different name when you save the data query.
Location
displays the metadata
folder location for the data query object. The initial value is
/My
Folder. You can specify a different location when
you save the data query.
Description
specifies a description
of the data query.
Create an SQL query view
specifies to create
a view for either the work table or the output table. For more information,
see
Create SQL Query Views.
Unique values
specifies whether the
SQL keyword DISTINCT is applied to the SELECT statement that is used
to generate the result set for the data query.
Append data
specifies whether the
result set for the data 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.
On the Outputs tab,
you can view or specify the following properties:
Table
specifies the table
name for either the staging output or the final output. For more
information, see
Specify an Output Table.
Compress data
specifies to compress
the output table. For more
information, see
Output and Staging Table Interactions.
Location
specifies the metadata
folder location to use for registering the staging table metadata
or output table metadata. Click 
to select a different location.
to select a different location.
Library
specifies the library
to use for the staging table or output table. Click 
to select a different library.
to select a different library.
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
Partition Tables.
Copyright © SAS Institute Inc. All rights reserved.