The LIBNAME Statement for Relational Databases |
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
|
CELLPROP=VALUE | FORMATTED_VALUE
|
-
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.
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.
For more information about MDX commands,
see Accessing OLE DB for OLAP Data.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.