Date:         Mon, 24 May 2004 15:54:12 -0700
Reply-To:     cassell.david@EPAMAIL.EPA.GOV
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "David L. Cassell" <cassell.david@EPAMAIL.EPA.GOV>
Subject:      Re: Need Help with SAS Merge
Content-type: text/plain; charset=US-ASCII

Brian Vuong <brianvuong@YAHOO.COM> wrote [in part]:
> Hello, I am new to SAS.  I need help with SAS merge below.  Any help
> is greatly appreciated.
>
> . . . .
>
> EXPECTED OUTPUT THAT THE FIRST DATA SET IS MERGED WITH THE DATA SET
> TWO, AND THE NUMBER RECORDS SHOULD BE EQUAL TO THE NUMBER OF RECORDS
> IN DATA SET TWO;
>
>
> AA      001
> AB      002
> AC      003
> AD      004
> BA      005
> BB      001
> BC      002
> BD      003
> CA      004
> CB      005
> CC      001
> CD      002

This seems like a very bad idea.  Your 'merge' is very fragile.
Without any sort of key to merge on, you have to hope that you never
have a duplicate value occur in either data set, and you never have
a missing record either.  Are you sure that this is really what you want
to do?

HTH,
David
--
David Cassell, CSC
Cassell.David@epa.gov
Senior computing specialist
mathematical statistician