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

The two output screens shown in Figure 8.5 show the differences between using the ODS CSV and the
ODS CSVALL tagset or destination options. All three pairs of code listed in Figures 8.3 and 8.4 produce
the same output files. The output file names are the same in Figure 8.5, but the top left image was written
using the “TAGSETS.CSV” code and the bottom right image was created using the “TAGSETS.CSVALL”
code.
Figure 8.5: Output Differences Between CSV and CSVALL ODS Output Files.
Example 8.8.2 CSV and CSVALL Title and Footnote Output Differences
In this example, the tagset templates CSV and CSVALL will both be used to show the differences between
the default settings of the CSV and CSVALL tagset templates. This example highlights the differences in
the output *.csv files. By default, options “BYLINES”, “TITLES”, “PROC_TITLES”, and “NOTES” are
set to “yes” in the CSVALL tagset processing. The code in Figure 8.6 processes both the CSV and
CSVALL output files. The WHERE= clause in the PROC PRINT code in Figure 8.6 restricts the output,
and the “BY” clause groups the data when the output files are created.
Figure 8.6: SAS Code to Process Both CSV and CSVALL Output.
TITLE1
"Testing Title options BYLINES - PROC_TITLES - TITLES and FOOTNOTES";
FOOTNOTE1
"Testing footnote options BYLINES - PROC_TITLES - TITLES and FOOTNOTES";
ODS TAGSETS.CSV BODY='c:\temp\csv\csv_shoes.csv';
ODS TAGSETS.CSVALL BODY='c:\temp\csvall\csvall_shoes.csv';
PROC PRINT DATA=sashelp.shoes
(WHERE=(product = 'Boot' and region in('Asia' , 'Canada')));
BY region;
RUN;
PROC FREQ DATA=sashelp.shoes;
TABLE product / LIST;
RUN;
ODS TAGSETS.CSV CLOSE;
ODS TAGSETS.CSVALL CLOSE;