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

Figure 8.11: SAS Code to Create a CSV Test File Using the currency_as_number Option.
/* convert currency to numbers */
/* No titles or footnotes are assigned */
ODS TAGSETS.CSVALL BODY='c:\temp\csvall\csvall_shoes.csv'
OPTIONS(CURRENCY_AS_NUMBER='Yes');
PROC PRINT DATA=sashelp.shoes
(WHERE=(product = 'Boot' and region in('Asia', 'Canada')));
BY region;
RUN;
ODS TAGSETS.CSVALL CLOSE;
Figure 8.12: ODS Output File Generated with CSVALL and “CURRENCY_AS_NUMBER”
Active.
Compare Figure 8.12 with Figure 8.8 to see the difference in the way the dollar amounts are displayed.