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

See the SAS Help files on your system for information about using PROC TEMPLATE.
8.4 Difference Between an ODS Tagset and an ODS Destination
An ODS tagset template is code that is used by PROC TEMPLATE to perform a task, like write a *.csv
file. Base SAS ships with many templates that are available to use. These tagsets can be edited and
modified and then stored in a place where you can have access to them. This is discussed later. An ODS
destination like the new EXCEL destination can be provided with options at the time you execute the ODS
command, but you cannot change the actual code that is used to process the data. Many SAS web pages
provide references to and downloadable copies of tagsets.
8.5 Syntax of the ODS CSV and CSVALL Output Processes
This section will describe CSV tagset templates, including options, along with the default values. Many of
the options will be further explained by an example. Section 8.3 describes how to locate a specific tagset.
You can then view the actual code, but it is often better left alone.
The tagset templates “CSV” and “CSVALL” are effectively the same tagset template; the difference is that
the “CSVALL” tagset template sets the “BYLINES”, “TITLES”, “PROC_TITLES”, “NOTES” options to
“yes”. Example 8.8.1 parts “a” and “b” show the actual differences. The “CSV” tagset template is the
“Parent” tagset of “CSVALL”. Therefore, everything not defined in tagset template CSVALL is defined in
the CSV tagset template. I refer to both the CSV and the CSVALL tagset template as the “CSV tagset
template” unless an option is specific to only one of them. The CSV tagset templates convert a SAS file to
an output text file of values separated by a delimiter. Text files of data separated by a delimiter have long
been used to transfer data between software packages.
The options for CSV tagset templates are described below, and in general fall in to several categories based
upon what part of the output the option modifies.
● Modify or display SAS outputs for titles, footnotes, bylines, and table headers
● Display of SAS log messages and tagset template “Help” messages
● Numeric variable formatting features
• Character variable formatting features
8.6 CSV and CSVALL Tagset Options
Table 8.2 highlights some of the CSV and the CSVALL tagset options, the option names default values and
a description. When you are using either the CSV or CSVALL tagset, current information about what is
installed on your computer can be printed to your log by adding either “OPTIONS(DOC='Quick') or
OPTIONS(DOC='help') to the ODS statement. The tagset options for the CSV and CSVALL tagset
templates fall into the following general categories. The asterisk “*” indicates that an option will be shown
in an example below.