topic Re: how to generate report header like this? in New SAS User

how to generate report header like this?

yogita_patel — Tue, 19 Apr 2022 15:21:35 GMT

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

Re: how to generate report header like this?

Kurt_Bremser — Tue, 19 Apr 2022 16:10:51 GMT

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

Re: how to generate report header like this?

PaigeMiller — Tue, 19 Apr 2022 16:23:28 GMT

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

Re: how to generate report header like this?

Cynthia_sas — Tue, 19 Apr 2022 16:24:29 GMT

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

Re: how to generate report header like this?

tarheel13 — Tue, 19 Apr 2022 17:26:22 GMT

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

Re: how to generate report header like this?

yogita_patel — Tue, 19 Apr 2022 17:50:19 GMT

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;

Re: how to generate report header like this?

yogita_patel — Tue, 19 Apr 2022 18:43:58 GMT

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

Re: how to generate report header like this?

Kurt_Bremser — Tue, 19 Apr 2022 19:03:46 GMT

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.