Download PDF file - Ben Pfaff

Chapter 6: The pspp language
38
The following syntax shows how custom currency formats could be used to reproduce
basic numeric formats:
SET CCA="-,,,". /* Same as COMMA.
SET CCB="-...". /* Same as DOT.
SET CCC="-,$,,". /* Same as DOLLAR.
SET CCD="-,,%,". /* Like PCT, but groups with commas.
Here are some more examples of custom currency formats. The final example shows how
to use a single quote to escape a delimiter:
SET CCA=",EUR,,-".
/* Euro.
SET CCB="(,USD ,,)". /* US dollar.
SET CCC="-.R$..".
/* Brazilian real.
SET CCD="-,, NIS,". /* Israel shekel.
SET CCE="-.Rp’. ..". /* Indonesia Rupiah.
These formats would yield the following output:
Format
3145.59
-3145.59
CCA12.2
EUR3,145.59
EUR3,145.59CCB14.2
USD 3,145.59 (USD 3,145.59)
CCC11.2
R$3.145,59
-R$3.145,59
CCD13.2
3,145.59 NIS
-3,145.59 NIS
CCE10.0
Rp. 3.146
-Rp. 3.146
The default for all the custom currency formats is ‘-,,,’, equivalent to COMMA format.
6.7.4.3 Legacy Numeric Formats
The N and Z numeric formats provide compatibility with legacy file formats. They have
much in common:
• Output is rounded to the nearest representable value, with ties rounded away from
zero.
• Numbers too large to display are output as a field filled with asterisks (‘*’).
• The decimal point is always implicitly the specified number of digits from the right
edge of the field, except that Z format input allows an explicit decimal point.
• Scientific notation may not be used.
• The system-missing value is output as a period in a field of spaces. The period is
placed just to the right of the implied decimal point in Z format, or at the right end
in N format or in Z format if no decimal places are requested. A period is used even if
the decimal point character is a comma.
• Field width may range from 1 to 40. Decimal places may range from 0 up to the field
width, to a maximum of 16.
• When a legacy numeric format used for input is converted to an output format, it is
changed into the equivalent F format. The field width is increased by 1 if any decimal
places are specified, to make room for a decimal point. For Z format, the field width is
increased by 1 more column, to make room for a negative sign. The output field width
is capped at 40 columns.