|Date: ||Mon, 18 Jun 2007 21:52:31 -0700|
|Reply-To: ||RolandRB <rolandberry@HOTMAIL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||RolandRB <rolandberry@HOTMAIL.COM>|
|Subject: ||Re: Merging|
|Content-Type: ||text/plain; charset="us-ascii"|
On 19 Jun, 05:35, sharad <sharadoffl...@gmail.com> wrote:
> 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.
Are there the same number of observations in each dataset you are
trying to merge and you want to merge them one on one? If so, then
just don't use a "by" statement.