Specifying Properties for a Data Query

On the Properties tab in the right pane, 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 the folder button

to select a different location.

Library

specifies the library to use for the staging table or output table. Click the library button

to select a different library.

Partition by

specifies the column to use for partitioning the output table. This property only applies when the output table is in a SAS LASR Analytic Server library or SASHDAT library. For more information, see Distributed Server: Partition Tables.

Specifying Properties for a Data Query

See Also