Date: Thu, 11 Jun 2009 03:18:50 -0700
Reply-To: "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET>
Subject: Re: Data Step Manipulation question
Content-Type: text/plain; charset=ISO-8859-1
On Jun 10, 8:39 pm, suthakari...@YAHOO.COM (Suthakar Iyer) wrote:
> I have dataset which contains like the below:
> patno SBP DBP
> 101 120 85
> 101 121 84
> 101 125 63
> 102 109 85
> 102 106 90
> 102 105 61
> Each patient has got different high and low ranges.
> For example patno 101 SBP range is 109-126, DBP range is 64-82
> Patno 102 SBP range is 109-127, DBP range is 64-83
> I have to compare for each patient the SBP and DBP whether they are in the range, if either one of the ranges of SBP or DBP out of range , I should output them .
> Thanks for your help.
Where are the ranges coming from or stored ?
Do you have a raw patient history table to be compared to ?
patno, date, sbp, dbp (1 record per reading)
Do you have a summarized patient history table ?
patno, sbp_low, sbp_high, dbp_low, dbp_high (1 record per patient)
patno, variable (sbp_low|sbp_high|...), value (1 record per
Do you have a table of standard values ?
gender, age, weight, sbp_low, sbp_high, dbp_low, dbp_high (1 record
If a patient has a single reading out of range, do you want all
their readings, or just the reading that is out of bounds ?
Richard A. DeVenezia