How to: |
Countries differ in how they punctuate numbers, and you can reflect these differences in your reports using Continental Decimal Notation (CDN) which is specified with the CDN SET parameter. The CDN SET allows you to choose to punctuate numbers with a combination of commas, decimals, spaces, and single quotation marks.
The CDN SET parameter can be used in a report request but is not supported in DEFINE or COMPUTE commands.
Note: The punctuation specified by the CDN parameter also determines the punctuation used in numbers affected by the CENT-ZERO SET parameter.
SET CDN = option
where:
Determines the punctuation used in numerical notation. The options are:
ON uses CDN. For example, the number 3,045,000.76 is represented as 3.045.000,76.
OFF turns CDN off. For example, the number 3,045,000.76 is represented as 3,045,000.76. This value is the default.
SPACE separates groups of three significant digits with a space instead of a comma, and marks a decimal position with a comma instead of a period. For example, the number 3,045,000.76 is represented as 3 045 000,76.
QUOTE separates groups of three significant digits with a single quotation mark instead of a comma, and marks a decimal position with a comma instead of a period. For example, the number 3,045,000.76 is represented as 3'045'000,76.
QUOTEP separates groups of three significant digits with a single quotation mark instead of a comma, and marks a decimal position with period. For example, the number 3,045,000.76 is represented as 3'045'000.76.
The following table shows how 1234.56 is displayed depending on the setting of CDN.
CDN Setting |
Result |
---|---|
OFF |
1,234.56 |
ON |
1.234,56 |
SPACE |
1 234,56 |
QUOTE |
1'234,56 |
QUOTEP |
1'234.56 |
In the following request, CDN is set to ON which punctuates numbers using a period to separate thousands, and a comma to separate decimals.
SET CDN = ON
TABLE FILE EMPLOYEE
PRINT LAST_NAME FIRST_NAME SALARYEND
The output is:
LAST_NAME FIRST_NAME SALARY
STEVENS ALFRED $11.000,00 SMITH MARY $13.200,00 JONES DIANE $18.480,00 JONES DIANE $17.750,00 BANNING JOHN $29.700,00 IRVING JOAN $26.862,00 IRVING JOAN $24.420,00 ROMANS ANTHONY $21.120,00 MCCOY JOHN $18.480,00 BLACKWOOD ROSEMARIE $21.780,00 MCKNIGHT ROGER $16.100,00 MCKNIGHT ROGER $15.000,00 CROSS BARBARA $27.062,00 CROSS BARBARA $25.775,00
WebFOCUS |