| Date: | Fri, 10 Aug 2007 13:16:32 -0400 |
|---|
| Reply-To: | Jack Clark <JClark@CHPDM.UMBC.EDU> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Jack Clark <JClark@CHPDM.UMBC.EDU> |
|---|
| Subject: | Re: rate calculation |
|---|
|
| In-Reply-To: | A<46BC9B37.8090603@vdh.virginia.gov> |
|---|
| Content-Type: | text/plain; charset="us-ascii" |
|---|
Carolyn,
You do not have any input data for your last data step. Are you missing
a SET statement?
Jack Clark
Research Analyst
Center for Health Program Development and Management
University of Maryland, Baltimore County
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Carolyn Halbert
Sent: Friday, August 10, 2007 1:07 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: rate calculation
I get down to the very last step and can't get the final calculation
done. I automate the results of the final 2 tables and make a new
variable x/y*100000...does not quite work
Any suggestions?
Thanks
proc sort data=death;
by x_uniqueid;
run;
proc sort data=datamart.birth;
by uniqueid;
run;
data match;
merge death (in=a) birth (in=b);
if a and b;
run;
proc freq data=match;
where infant=1 and deathyr=2003;
tables deathyr/out=infdeaths;
run;
proc freq data=match;
where birthyr=2003;
tables birthyr/out=births;
run;
data match;
rate=infdeaths/births*1000;
run;
| 
