Date:         Thu, 5 Oct 2006 04:17:11 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: merging question
Comments: To: aknas_a@YAHOO.COM
In-Reply-To:  <200610050011.k94Kvcax016358@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed

Data One ;
Infile Cards ;
Input X Y $ ;
Cards ;
33 CC
33 FF
33 GG
44 CC
45 KA
45 DF
46 GH
47 GG
47 JK
47 CC
;
Run ;


Data Two ;
Infile Cards ;
Input Y $ ;
Cards ;
CC
GG
FF
GH
DF
;
Run ;


Proc Sort
  Data = One ;
  By Y ;
Run ;

Proc Sort
  Data = Two ;
  By Y ;
Run ;

Data Need ;
Merge One ( In = One )
      Two ( In = Two ) ;
By Y ;
If One and Two ;
Run ;

Proc Print
  Data = Need ;
Run ;



Toby Dunn

When everything is coming at you all at once, your in the wrong lane.

A truly happy person is someone who can smile and enjoy the scenery on a
detour.





From: Aknas Dii <aknas_a@YAHOO.COM>
Reply-To: Aknas Dii <aknas_a@YAHOO.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: merging question
Date: Wed, 4 Oct 2006 20:11:40 -0400

Thanks Toby..
Is it possible to code without the SQL version?

Thanks.
Dii