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?
What happens if you remove this?
compute before order;
line '';
endcomp;
or change it to
compute after order;
line '';
endcomp;
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-...
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;
What happens if you remove this?
compute before order;
line '';
endcomp;
or change it to
compute after order;
line '';
endcomp;
thank you so much
it worked
compute after worked
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.