Australian Bureau of Statistics
Celebrating the International Year of Statistics 2013

Update on SAS Version 9 available on RADL

A key feature of the October SAS Version 9 RADL upgrade is the introduction of the %PrintCSV macro. The %PrintCSV macro has been developed to provide users with the ability to produce protected aggregate output in Comma Separated Value format. The macro should be invoked by the user directly after creating the aggregate dataset through, for example, PROC FREQ or PROC SUMMARY. The macro outputs these datasets in CSV format to the relevant output file. You are strongly encouraged to use this macro to facilitate production of your CSV output.

Sample code:

proc freq data=nhs01ev2.nhs01 noprint;
tables age*sex /out=out_table;
run;
%PrintCSV;

There is also an option to suppress printing of column headings:

proc freq data=nhs01ev2.nhs01 noprint;
tables age*sex /out=out_table;
run;
%PrintCSV(TITLE=NONE);