how to group or order a variable if it is used analysis in define statement

vraj1 — Tue, 12 Sep 2017 09:01:39 GMT

how to group or order a variable if it is used analysis in define statement in proc report.

Re: how to group or order a variable if it is used analysis in define statement

Kurt_Bremser — Tue, 12 Sep 2017 09:06:33 GMT

Please post the report code you already have, so we can have an idea where to change it.

Re: how to group or order a variable if it is used analysis in define statement

vraj1 — Tue, 12 Sep 2017 09:08:45 GMT

options missing = "" ls=200;
proc report data = rep nowd split = "¤" headline missing contents = "" out=rep1;
column param actarmn actarm timevar (' ' Ntot) anrind, (count pctc ) a1ind, (count2 pctc2 ) dummy ;
define param / group style(header)={just=left cellwidth=4.5cm} style(column)=IdColIndent2{asis=on} "Parameter" ;
define actarmn / group order=internal noprint;
define actarm / group style(header)={just=left cellwidth=2cm} style(column)=IdColIndent2{asis=on} "Treatment Group";
define timevar /group order=data style={just=right cellwidth=2cm} "Week";
define anrind /across order=data style={just=left} "Normal Range";
define Ntot / analysis "N" style={just=right cellwidth=0.81346153846152cm} ;
define dummy /noprint;
define a1ind /across order=data style={just=left} "PCS";
define count /analysis order=internal group sum style={just=right cellwidth=0.81346153846152cm} "n";
define count2 /analysis order=internal group sum style={just=right cellwidth=0.81346153846152cm} "n";
define pctc /display order=internal group style={just=right cellwidth=1.08461538461536cm} "(%)";
define pctc2 /display order=internal group style={just=right cellwidth=1.08461538461536cm} "(%)";
compute before;
line @1 ' ';
endcomp;

compute after actarmn;
line ' ';
endcomp;

run;

Re: how to group or order a variable if it is used analysis in define statement

Ksharp — Wed, 13 Sep 2017 14:02:40 GMT

option ORDER= ?

proc report data=sashelp.class nowd;
column sex age;
define sex/group;
define age/analysis sum order=data;
run;

topic Re: how to group or order a variable if it is used analysis in define statement in SAS Programming

how to group or order a variable if it is used analysis in define statement

Re: how to group or order a variable if it is used analysis in define statement

Re: how to group or order a variable if it is used analysis in define statement

Re: how to group or order a variable if it is used analysis in define statement