Modifies the metadata and content of a result data set that the MDX command specifies.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | VALUE |
| Data source: | OLE DB |
| See: | Accessing OLE DB for OLAP Data |
Table of Contents
specifies that the SAS/ACCESS engine returns formatted data values. All columns are specified as CHARACTER.
specifies that the SAS/ACCESS engine tries to return actual data values. If all values in a column are numeric, that column is specified as NUMERIC.
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.
Specifying the CELLPROP= option determines how the values are specified
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 specifies the column as CHARACTER and returns
formatted values for that column.