Date:         Tue, 19 Jun 2007 08:52:16 -0400
Reply-To:     roger.s.clark@CENSUS.GOV
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "NOMAIL Roger S. Clark" <roger.s.clark@CENSUS.GOV>
Subject:      Re: Merging
Content-type: text/plain; charset=US-ASCII

Hi, Shared;

There are several ways that SAS can combine data sets.  In order to help
you, I think we might need more information.  A description of the data
sets would help.  Also, why do you want to merge them?  The reason why
might suggest the best way.  Which variables are you considering using as a
key?  How many variables?  Are they character or numeric?  What makes them
a good key for match merging?  Are there any variables that are common to
both data sets that you would not use as a merge key?  (This can be
important because of the way SAS overwrites variables in a match merge)

Please write back with more information.



>
> Date:    Mon, 18 Jun 2007 20:35:45 -0700
> From:    sharad <sharadoffline@GMAIL.COM>
> Subject: Merging
>
> Hi All,
>
> I am trying to match merge two data files but there is no single
> primary key(Unique Variable) on the basis of which i can merge the
> files. I don't know whether i can use 2 or more variables for creating
> a pimary key and then using that primary key for merging. If this  can
> be done, then please help me out with the pocess. I will be vey happy
> if someone can explain me the concept of merging, i mean...... how SAS
> compile and execute MERGE Statement.
> Please help me at the earliest.
> Sharad
>
Thanx,
Roger S. Clark
Address Coverage Assurance Programs Branch