| Date: | Tue, 20 Dec 2011 14:33:39 -0500 |
|---|
| Reply-To: | Rick Moreton <rkmoreton@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Rick Moreton <rkmoreton@GMAIL.COM> |
|---|
| Subject: | Re: Need help in SAS code |
|---|
Another solution to add to the list.
data TEST;
input primary_ID $ secondary_ID $ var $;
cards;
A1 B1 A
A1 B2 A
A1 B3 A
A2 B1 B
A2 B2 C
A3 B1 D
A3 B1 A
A3 B1 B
A4 B1 C
A4 B2 C
A5 B1 D
A5 B2 A
A5 B3 B
A6 B1 A
A6 B2 C
A6 B3 A
A7 B1 D
A7 B2 D
A7 B3 D
A8 B1 A
A8 B2 B
A8 B3 C
;
run;
proc sql;
select * from test
where primary_ID in
(select distinct primary_ID from test
where var not in ("A","C"));
quit;
| 
