SAS Formats Available for Measures

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.
Note: For more information about SAS formats, see "Formats" in the SAS Language Reference: Dictionary.