topic Re: proc report - how to add counts to column header in ODS and Base Reporting

proc report - how to add counts to column header

SASPrime — Thu, 22 Feb 2018 15:58:43 GMT

I would like to produce a report table with column headings in two rows - the first row is regular column title, the second row is a count in the format of (n=xxx);

Also, have to include min-max range in first column. Is there a way to do it using ods rtf proc report? Thanks for your help!

Demographics

Treatment
(n= xx)

Placebo
(n= xx)

Total

(n=xx)

Mean age
[min-max range]

Mean Calculated Body Weight (kg)
[min-max range]

Re: proc report - how to add counts to column header

Cynthia_sas — Thu, 22 Feb 2018 16:31:41 GMT

Hi:
This is very similar to the Demographic report shown in this Global Forum paper: http://www2.sas.com/proceedings/forum2008/173-2008.pdf starting on page 9.

But conceptually, you can do something like this with macro variables.

Example:

** could create these macro variables in a program;
** instead of hardcoding the values;
%let agestr = (N=19);
%let htstr = (N=19);
%let wtstr = (N=19);

ods rtf file='c:\temp\showheader.rtf';

proc report data=sashelp.class split='*'  
   style(header)={background=white}
   style(column)={width=1in};
  column sex age height weight;
  define sex / group ' *Sex';
  define age / "Age*&agestr";
  define height / mean "Avg Height*&htstr" f=8.2;
  define weight / mean "Avg Weight*&wtstr" f=8.2;
run;
ods rtf close;

produces this using ODS RTF:

cynthia

Re: proc report - how to add counts to column header

SASPrime — Thu, 22 Feb 2018 18:18:30 GMT

As suggested, used macro variables, and it worked! Thank you!