Proc Report By Variable

Leo9 — Wed, 23 Oct 2024 23:41:43 GMT

Hi All,

I am using following proc report code to generate an output. The "by" statement in proc report is causing some issue for me. I want the output split by the "by" group but in the actual output when I use the code below, I see the values for by variable appearing twice in the output. First one is from the blue highlighted syntax below which appears on the left hand side and the second is from the green highlighted syntax. The one from green highlighted syntax appear little strange where it show value like this in the output as a title. I want to get rid of it . How can I achieve it ?

proc report data=final_&i nowd missing headskip split='~' style(report)=[width=100%];

by byvarn byvar ;

title7 j=l "#byval(byvar)";

columns page avisitn order1 order2 linelab statistic var1-var5 ;

define page / order noprint;

define avisitn / order noprint;

define order1 / order noprint;

define order2 / order noprint;

define linelab / style(column)={just=l cellwidth=16% /*cellspacing=1.0cm*/

asis=on}

style(header)={just=l} group;

define statistic / style(column)={just=l cellwidth=16% asis=on}

style(header)={just=l} group;

define var1 / style(column)={just=c cellwidth=11% asis=on}

style(header)={just=c} flow group "(40 mg)~(N=&n1.)";

define var2 / style(column)={just=c cellwidth=11% asis=on}

style(header)={just=c} "(80 mg)~(N=&n2.)";

define var3 / style(column)={just=c cellwidth=11% asis=on}

style(header)={just=c} order "(160 mg)~(N=&n3.)";

define var4 / style(column)={just=c cellwidth=11% asis=on}

style(header)={just=c} order "(320 mg)~(N=&n4.)";

define var5 / style(column)={just=c cellwidth=11% asis=on}

style(header)={just=c} "Placebo~(N=&n5.)";

compute before page;

line ' ';

endcomp;

compute after order1;

line ' ';

endcomp;

break after page / page;

run;

Re: Proc Report By Variable

Tom — Thu, 24 Oct 2024 00:03:10 GMT

Are you asking how to not have the BY LINE produced? Change the system option that controls that before running the PROC.

options nobyline;

Re: Proc Report By Variable

Leo9 — Thu, 24 Oct 2024 22:28:24 GMT

Thank you!

topic Re: Proc Report By Variable in SAS Programming

Proc Report By Variable

Re: Proc Report By Variable

Re: Proc Report By Variable