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>
Organization: http://groups.google.com
Subject:      Re: Data Step Manipulation question
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Jun 10, 8:39 pm, suthakari...@YAHOO.COM (Suthakar Iyer) wrote:
> Hi,
> 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.
> Suthakar

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)
or
  patno, variable (sbp_low|sbp_high|...), value (1 record per
variable)

Do you have a table of standard values ?
  gender, age, weight, sbp_low, sbp_high, dbp_low, dbp_high (1 record
per gender/age/weight)


For output...
  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
http://www.devenezia.com