Usage Note 23652: How can I create a CSV file with ODS?
In Release 8.1,
you can create a CSV file by using the ODS XML statement
with the TYPE=CSV or TYPE=CSVALL option. TYPE=CSVALL
keeps the titles. This is experimental in Release 8.1
but works rather well; see example 1 below.
In Release 8.2,
you can use the new ODS CSV destination; see example 2.
/* example 1: Release 8.1 */
ods xml body='c:\test\test.csv' type=csv;
proc print data=sashelp.class;
run;
ods xml close;
/* example 2: Release 8.2 and later */
ods csv body="c:\test.csv";
proc print data=sashelp.class;
run;
ods csv close;
See also the full PROC TEMPLATE FAQ and Concepts.
Operating System and Release Information
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | low |
| Topic: | SAS Reference ==> ODS (Output Delivery System)
|
| Date Modified: | 2004-01-12 15:45:14 |
| Date Created: | 2004-01-09 15:05:35 |