Date: Mon, 23 Mar 2009 11:51:26 -0700
Reply-To: "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Subject: Re: Fo the same vtf_id I would like keep only one observation and
Content-Type: text/plain; charset="us-ascii"
Is the data ordered within Vtf_Id by the hierarchy of varA? If there is
a K, is it guaranteed to precede any V?
If not, sort the observations in this order, possibly using PROC
Once the data is sorted, simply save the first observation for each
Sent: Monday, March 23, 2009 11:25 AM
Subject: Fo the same vtf_id I would like keep only one observation and
there is hierachy for variable varA
Fo the same vtf_id I would like keep only one observation and
1. if any of varA for that vtf_id is "K" i would like to keep that
2. if any of varA for that vtf_id is not "K" but "V" i would like to
keep that observation
3. if no observation fot the same vtf_id is "V" or "K" then i would
like to keep one with varA'"PN"
the new dataset shoul be like this: