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

ODS TAGSETS.CSVALL BODY='c:\temp\csv\csvall_shoes.tab'
OPTIONS(DELIMITER='09'x);
PROC PRINT DATA=sashelp.shoes
(where=(product = 'Boot' and region in('Asia', 'Canada')));
BY region;
RUN;
ODS TAGSETS.CSVALL CLOSE;
The output CSV file 'c:\temp\csv\csvall_shoes.csv' shown in Figure 8.15 has a tab character as a delimiter.
This may not seem very useful, but some older systems I have used have reacted in funny ways when
commas appear in the numeric fields, even when they are enclosed in quotes. So, sometimes I use a tab as
my delimiter.
Figure 8.15: The CSVALL_Shoes.csv File Opened with Notepad.
Figure 8.16: The CSVALL_Shoes.tab File Opened with Notepad.