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.