What you're asking for isn't unusual, but I think you data is incomplete. I think visit is missing, and you need more data to support what you need. Though I could take some guesses I'm reluctant to do so without more information.

On 4/3/07, Sridhar, Nagakumar <nagakumar.sridhar@spcorp.com> wrote: > > Hi All: > I am trying to do the following: > > I need to get data from a dataset that fulfills certain conditions. I > need to make sure that if the a patient has low values in one visit and > high(er than the upper limit) values in the next, they (all values for > that patient, regardless of whether they're lower or higher than the > lower/higher ranges) get grouped into one dataset. The problem is > that certain patients could have low values at one visit but very high > values in the next visit. But, they also should meet certain criteria: > These are: > > Lowest value < = lower limit of range (exclude those subjects > that then fit into the categories below) > Highest value > upper limit of range but less than 10 > Highest value > 10 > > Data have; /* JUST AN EXAMPLE OF WHAT THE DATA LOOKS LIKE. THERE ARE > ABOUT 3000 MORE PATIENTS*/ > input patno $5. visit 1. lo 6. 2 hi 6.2 rslt 6.2; > cards; > 000011 .32 5.0000 0.20 > 000012 .32 5.0000 8.76 > 000013 .32 5.0000 95.50 > 000021 .32 5.0000 .24 > 000022 .32 5.0000 .31 > 000023 .32 5.0000 .33 > ; > > What I need is: > > 000021 .32 5.0000 .24 > 000022 .32 5.0000 .31 > 000023 .32 5.0000 .33 > > > I hope I haven't confused you more than I usually do. > > TIA > > Kumar > > ********************************************************************* > This message and any attachments are solely for the > intended recipient. If you are not the intended recipient, > disclosure, copying, use or distribution of the information > included in this message is prohibited -- Please > immediately and permanently delete. >