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

[yogita_patel]

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?

[PaigeMiller]

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-...

[yogita_patel]

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;

[PaigeMiller · Accepted solution]

What happens if you remove this?

compute before order;
line '';
endcomp;

or change it to

compute after order;
line '';
endcomp;

[yogita_patel]

thank you so much 

it worked 

compute after worked