Date:         Fri, 13 Feb 2009 06:17:29 -0800
Reply-To:     hd <heenagd@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         hd <heenagd@GMAIL.COM>
Organization: http://groups.google.com
Subject:      some join
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Joining of datasets

I have a dataset

ZipCode     Telephone    Scode
123            4356            Acd
234            5367            dge
456            3424            adasd


and another main dataset

Name  Age  Contact    Telephone






I want the final main dataset to include ZipCode and Scode where the
telephones is the key identifier and where it should match, if there
is no match it should be blank. I think I should use some kind of join
but Im not sure of the syntax.

so in other words

Name Age Contact Telphone ZipCode Scode


Thank you so much for the help.