**Date:** Thu, 15 Nov 2001 17:26:43 -0500
**Reply-To:** "Huang, Ya" <ya.huang@PFIZER.COM>
**Sender:** "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
**From:** "Huang, Ya" <ya.huang@PFIZER.COM>
**Subject:** Q on proc report, compute block?
**Content-Type:** text/plain; charset="iso-8859-1"
Hi there,

This might be too long, please bear with me.

Basically I want to use proc report because I have to present
both detailed rows and some summary result. Unfortunately,
I need "median" which can only be calculated by proc univariate
(yes, this is for SAS 6.12), steps 2-6 is to manipulate data,
so that it has necessary vars for proc report compute block.

I would like to summarize by study and also for all studies
at the end of the list.

data xx;
input study $ sex $ age ncrs desc $;
cards;
B F 67 8 stst
B F 34 10 sdfsaf
B M 55 7 sdryts
B M 73 7 werwer
B M 46 9 sdgsf
A M 45 3 abcd
A M 65 4 bdrf
A F 46 3 lsdfsd
A F 67 5 sdfas
;

proc sort;
by study;

proc univariate noprint data=xx;
by study;
var age ncrs;
output out=temp n=n1 median=m1 m2;

proc univariate noprint data=xx;
var age ncrs;
output out=temp1 n=on1 median=om1 om2;

data xx;
merge xx temp;
by study;

proc sql;
create table xx as
select xx.*, temp1.*
from xx, temp1
order by study
;

options nocenter;
proc report nowd headline;
column on1 om1 om2 n1 m1 m2 study sex age ncrs desc;
define study / width=5 order;
define sex / width=3 order;
define age / width=3;
define ncrs / width=5;
define n1/noprint order;
define m1/noprint order;
define m2/noprint order;
define on1/noprint order;
define om1/noprint order;
define om2/noprint order;
compute after study;
line ' ';
line 'N=' n1 3.;
line 'Median age=' m1 5.1;
line 'Median CRS=' m2 5.1;
line ' ';
endcomp;
compute after;
line ' ';
line 'Total N=' on1 3.;
line 'Overall Median age=' om1 5.1;
line 'Overall Median CRS=' om2 5.1;
line ' ';
endcomp;
run;

-----------------------------
study sex age ncrs desc
-------------------------------------
A F 46 3 lsdfsd
67 5 sdfas
M 65 4 bdrf
45 3 abcd

N= 4
Median age= 55.5
Median CRS= 3.5

B F 34 10 sdfsaf
67 8 stst
M 55 7 sdryts
46 9 sdgsf
73 7 werwer

N= 5
Median age= 55.0
Median CRS= 8.0

Total N= .
Overall Median age= .
Overall Median CRS= .

Now my question is why the second compute block
dose not work?

Thanks.

Ya Huang