topic Making proc freq pretty with ods in SAS Procedures

Making proc freq pretty with ods

willy0625 — Thu, 15 Sep 2011 04:43:18 GMT

Hello SAS users. Below of an extract of what I am working at the moment.

data test;

input score;

cards;

9125

9455

;

run;

ODS RTF style=Journal BODYTITLE;

ODS NOPROCTITLE;

PROC freq DATA=test;

TABLES score / nocol norow nopercent;

RUN;

ODS RTF CLOSE;

While I want to keep the Journal style, I would like to;

- be able to manipulate column width so that I get more spaced out table hence easier to read

- put a comma after every 3 digits for the score

- put a total row at the bottom

Anyone has an idea?

Many thanks

Making proc freq pretty with ods

Ksharp — Thu, 15 Sep 2011 07:50:03 GMT

I think Cynthia@sas can use proc template to tailor it .

But you can always use proc report to customize the output .

data test;
      input score;
      cards;
      9125
      9455
      ;
run;

ods output OneWayFreqs=x;
      PROC freq DATA=test ;
            TABLES score / nocol norow nopercent;
      RUN; 

ODS RTF style=Journal BODYTITLE;
ODS NOPROCTITLE;
title ' ';
proc report data=x(drop= f_:) out=p nowd;
 column table score frequency cumfrequency;
 define table/display  style={cellwidth=2cm} ' ';
 define score /analysis format=comma10. style={cellwidth=2cm};
 compute score;
 if _break_='_RBREAK_' then table='Total:';
  else call missing(table);
 endcomp;
 rbreak after /summarize ;
run;
ODS RTF CLOSE;

Ksharp

Making proc freq pretty with ods

art297 — Thu, 15 Sep 2011 12:55:52 GMT

Take a look at: http://support.sas.com/resources/papers/freq92.pdf

It has a number of examples regarding how to change the appearance of proc freq output.