topic how to add row with value under the column header in proc report? in ODS and Base Reporting

how to add row with value under the column header in proc report?

yogita_patel — Fri, 15 Apr 2022 13:15:59 GMT

Hi, i want to merge or add row under column header with some constant value for all my 5 column

i got his

but i want like this

can someone help?

Re: how to add row with value under the column header in proc report?

PaigeMiller — Fri, 15 Apr 2022 13:20:19 GMT

We'd need to see your code in order to answer your question.

You might also want to look at the %TABLEN macro. https://communities.sas.com/t5/SAS-Communities-Library/Demographic-Table-and-Subgroup-Summary-Macro-TABLEN/ta-p/634030

Re: how to add row with value under the column header in proc report?

yogita_patel — Fri, 15 Apr 2022 13:32:00 GMT

i have created seperate dataset with value 'n (%)' and stack them

proc report data=final nowd headskip headline split='*'
style = {outputwidth=100% } spacing=1 wrap;
column order newvar trt_1 trt_2 trt_3 trt_4 trt_9;
define order/ order noprint ;
define newvar/display '' style(column)={asis=on};
define trt_1/ display "Placebo * (N=&trt1)" center;
define trt_2/ display "Tanezumab 5 * mg *(N=&trt2)" center;
define trt_3/ display "Tanezumab 10 * mg *(N=&trt3)" center;
define trt_4/ display "Naproxen 500 * mg BID * (N=&trt4)" center;
define trt_9/ display "Total * (N=&trt9)" center;
compute before order;
line '';
endcomp;
compute after _page_;
line'';
endcomp;

run;

Re: how to add row with value under the column header in proc report?

PaigeMiller — Fri, 15 Apr 2022 13:35:20 GMT

What happens if you remove this?

compute before order;
line '';
endcomp;

or change it to

compute after order;
line '';
endcomp;

Re: how to add row with value under the column header in proc report?

yogita_patel — Fri, 15 Apr 2022 13:53:52 GMT

thank you so much

it worked

compute after worked