The LIBNAME Statement for Relational Databases

QUALIFY_ROWS= LIBNAME Option

Uniquely qualifies all member values in a result set.

Default value:	NO
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	OLE DB

Syntax
Syntax Description
Details
See Also

Syntax

QUALIFY_ROWS=YES | NO

Syntax Description

YES: specifies that when the OLE DB interface flattens the result set of an MDX command, the values in each column are uniquely identified using a hierarchical naming scheme.
NO: specifies that when the OLE DB interface flattens the result set of an MDX command, the values in each column are not qualified, which means they might not be unique.

Details

For example, when this option is set to NO, a GEOGRAPHY column might have a value of PORTLAND for Portland, Oregon, and the same value of PORTLAND for Portland, Maine. When you set this option to YES, the two values might become [USA].[Oregon].[Portland] and [USA].[Maine].[Portland], respectively.

Note: Depending on the size of the result set, QUALIFY_ROWS=YES can have a significant, negative impact on performance, because it forces the OLE DB interface to search through various schemas to gather the information needed to created unique qualified names. [cautionend]