Planning for SAS OLAP Cubes

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. [cautionend]

Top of Page