My first inclination would be to generate a dataset with those patnos that meet your criteria, dedupe that list, then do a merge using the in= option to pull all records for those patnos, and no others.

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Sridhar, Nagakumar Sent: Tuesday, April 03, 2007 10:20 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Data Step question

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.

The information contained in this e-mail is confidential and/or proprietary

to Capital One and/or its affiliates. The information transmitted herewith

is intended only for use by the individual or entity to which it is

addressed. If the reader of this message is not the intended recipient,

you are hereby notified that any review, retransmission, dissemination,

distribution, copying or other use of, or taking of any action in reliance

upon this information is strictly prohibited. If you have received this

communication in error, please contact the sender and delete the material

from your computer.