For each measure that you define for a cube, you can select the SAS
format that is used to display the value of the measure. The following formats
are available from the Format drop-down list on
the Measure Details page of the Cube Designer wizard in SAS OLAP Cube Studio:
SAS Formats Available for Measures
SAS Format |
Description |
15.0 |
Designates the width of the resulting string will be a maximum of 15
characters after the value has been formatted. |
BEST |
Enables SAS to choose the best numeric notation. |
BEST15 |
Enables SAS to choose the best numeric notation. The width of the resulting
string will be a maximum of 15 characters. |
COMMA |
Writes numeric values with commas and decimal points. |
COMMA15 |
Writes numeric values with commas and decimal points. The width of the
resulting string will be a maximum of 15 characters. |
COMMAX |
Writes numeric values with periods and commas. |
COMMAX15 |
Writes numeric values with periods and commas. The width of the resulting
string will be a maximum of 15 characters. |
DOLLAR |
Writes numeric values with dollar signs, commas, and decimal points. |
DOLLAR15 |
Writes numeric values with dollar signs, commas, and decimal points.
The width of the resulting string will be a maximum of 15 characters. |
DOLLARX |
Writes numeric values with dollar signs, periods, and commas. |
DOLLARX15 |
Writes numeric values with dollar signs, periods, and commas. The width
of the resulting string will be a maximum of 15 characters. |
EURO |
Writes numeric values with a leading euro symbol, a comma that separates
every three digits, and a period that separates the decimal fraction. |
EURO15 |
Writes numeric values with a leading euro symbol, a comma that separates
every three digits, and a period that separates the decimal fraction. The
width of the resulting string will be a maximum of 15 characters. |
EUROX |
Writes numeric values with a leading euro symbol, a period that separates
every three digits, and a comma that separates the decimal fraction. |
EUROX15 |
Writes numeric values with a leading euro symbol, a period that separates
every three digits, and a comma that separates the decimal fraction. The width
of the resulting string will be a maximum of 15 characters. |
NEGPAREN |
Writes negative numeric values in parentheses. |
NEGPAREN15 |
Writes negative numeric values in parentheses. The width of the resulting
string will be a maximum of 15 characters. |
PERCENT |
Writes numeric values as percentages. |
PERCENT15 |
Writes numeric values as percentages. The width of the resulting string
will be a maximum of 15 characters. W.D writes standard numeric data
one digit per byte. |
WORDF |
Writes numeric values as words with fractions that are shown numerically. |
WORDF10 |
Writes numeric values as words with fractions that are shown numerically.
The width of the resulting string will be a maximum of 10 characters. |
WORDS |
Writes numeric values as words. |
WORDS10 |
Writes numeric values as words. The width of the resulting string will
be a maximum of 10 characters. |
YEN |
Writes numeric values with yen signs, commas, and decimal points.
|
YEN15 |
Writes numeric values with yen signs, commas, and decimal points. The
width of the resulting string will be a maximum of 15 characters. |