Creating Output Files with ODS for Use by Excel - Exchanging Data Between SAS and Microsoft Excel - page 112

Table 8.2: ODS Options for the CSV and CSVALL Tagset Templates.

ODS Option Description

Options related to titles and footnotes

BYLINES Select if byline records will be put into the output file.

PROC_TITLES Select if procedure title records will be put into the output file.

Select if title and footnote records will be put into the output
file.

TITLES

Select if header sections of output tables will be put into the
output file.

TABLE_HEADERS

Options related to data and columns

If selected, currency symbols and punctuation are removed from
output values,

CURRENCY_AS_NUMBER

CURRENCY_SYMBOL Select currency symbol to use,

DECIMAL_SEPARATOR Select decimal separator to use,

DELIMITER Select field delimiter to use,

QUOTE_BY_TYPE Select field types to enclose in quotes,

QUOTED_COLUMNS Select columns to enclose in quotes.

Select if percent signs and punctuation are removed from output
values.

PERCENTAGE_AS_NUMBER

Use with QUOTE_BY_TYPE to prepend an equal sign in front
of numeric values.

PREPEND_EQUALS

Select thousands separator to use in numeric fields, usually for
use in Europe or countries with different numeric formatting.

THOUSANDS_SEPARATOR

Options related to error messages

NOTES Select whether or not to suppress SAS system error messages.

Options related to Tagset template documentation

Write user Help information about the tagset template options to
the system log.

DOC