how to generate report header like this?

[yogita_patel]

Hi i would like to generate report header like below

where i want analysis visit and summary statistic in second column which are which are column header for first two columns 

[Kurt_Bremser]

Please post your source data for this report in usable form (as a data step with datalines, do not skip this!).

[yogita_patel]

proc report data=final nowd headskip headline split='*'
style = {outputwidth=100% } spacing=1 wrap;
by order param;
column avisitn avisit newvar _1 _2 _3 _4;
define avisitn/ noprint;
define avisit/ group order=data 'Analysis * Visit' center;
define newvar/ display 'Summary * Statistics' center;
define _1/display "Placebo * (N=&n1)" center;
define _2/display "Tanezumab 5 * mg * (N=&n2)" center;
define _3/display "Tanezumab 10 * mg * (N=&n3)" center;
define _4/display "Naproxen 500 * mg BID * (N=&n4)" center;
compute after avisit;
line '';
endcomp;

run;

[yogita_patel]

cant upload whole data as it is big dataset with more than 22000 obs

[Kurt_Bremser]

We just need a few lines of data step code so we get a clear picture of your dataset structure (variable types, lengths, formats), some representative values, and how the report from this should look.

[PaigeMiller]

Not a direct answer to your question, but you might want to try the %TABLEN macro, which produces reports like yours.

[Cynthia_sas]

Hi:
This is the kind of report you can generate using PROC REPORT. Since you did not post any data or any of your sample code, you might want to look in this paper for some ideas: https://support.sas.com/resources/papers/proceedings/pdfs/sgf2008/173-2008.pdf -- there are 3 different types of demographic report in this paper. They don't look exactly like what you want, but they should provide some ideas.
Cynthia

[tarheel13]

it looks like you would need to use split character. also the header N were most likely created with macro variables.