The LIBNAME Statement for Relational Databases

CELLPROP= LIBNAME Option

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

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

Syntax
Syntax Description
Details
See Also

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, then 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.