Date:         Thu, 20 Jan 2005 05:10:22 -0800
Reply-To:     omugeye <bhuta_zegha@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         omugeye <bhuta_zegha@YAHOO.COM>
Organization: http://groups.google.com
Subject:      Re: Joining tables
Content-Type: text/plain; charset="iso-8859-1"

data a;retain flag 0;input id @@;cards;
1 2 3 4 5 6 7 8   9 10
;proc print data = a;
data b;input id @@;cards;
1 2  4 5  7 8  10
;proc print data = b;run;

proc sql;
update a set flag = 1 where id in (select id from b);
quit;
proc print data = a;
run;