CELLPROP= LIBNAME Option

Modifies the metadata and content of a result data set that the MDX command defines.

Valid in:	SAS/ACCESS LIBNAME statement
Default:	VALUE
Data source:	OLE DB
See:	Accessing OLE DB for OLAP Data

Syntax

Details

Syntax

CELLPROP=VALUE | FORMATTED_VALUE

Syntax Description

VALUE: specifies that the SAS/ACCESS engine tries to return actual data values. If all values in a column are numeric, that column is defined as NUMERIC.

FORMATTED_VALUE: specifies that the SAS/ACCESS engine returns formatted data values. All columns are defined as CHARACTER.

Details

When an MDX command is issued, the resulting data set might have columns that contain one or more types of data values: the actual value of the cell or the formatted value of the cell.

For example, if you issue an MDX command and the resulting data set contains a column named SALARY, the column could contain data values of two types. It could contain numeric values, such as 50000, or it could contain formatted values, such as $50,000. Setting the CELLPROP= option determines how the values are defined and the value of the column.

It is possible for a column in a result set to contain both NUMERIC and CHARACTER data values. For example, a data set might return the data values of 50000, 60000, and UNKNOWN. SAS data sets cannot contain both types of data. In this situation, even if you specify CELLPROP=VALUE, the SAS/ACCESS engine defines the column as CHARACTER and returns formatted values for that column.