Date:         Sun, 30 Mar 2008 17:36:18 -0700
Reply-To:     Bestwishes <irain168@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Bestwishes <irain168@GMAIL.COM>
Organization: http://groups.google.com
Subject:      how to get the records meet certain requirements
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

dataset1

name  ID Gender
Jack   18  M
B        20  F
D        10  F
E        20 F
Mike   18  M
F        20  F
H        10  F
L        20 F

Dataset2

State   Label   City
IA        18      M
GA       20      F
LA       10      F
NC      20      F

How to write a program to create a dataset "Search" where hold the
records where the value of label in dataset 2 equal the value of ID in
dataset1. The variables in the new datasets are Name, Label, and City.