|Date: ||Wed, 20 Jun 2007 19:04:16 -0700|
|Reply-To: ||David L Cassell <davidlcassell@MSN.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||David L Cassell <davidlcassell@MSN.COM>|
|Subject: ||Re: Merging|
|Content-Type: ||text/plain; format=flowed|
sharadoffline@GMAIL.COM wrote back:
>On Jun 19, 9:52 am, RolandRB <rolandbe...@hotmail.com> wrote:
> > 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 formerging. 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 ofmerging, i mean...... how SAS
> > > compile and execute MERGE Statement.
> > > Please help me at the earliest.
> > > Sharad
> > 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.
>i dont think no of records are going to make any difference when um
>merging the files.
I'll disagree for the block, Peter. :-) :-)
The number of records total can make a difference when it comes to
efficiency issues, especially if one or both of the data sets is not sorted.
The number of records in any given by-group can make a difference in
whether a MERGE statement is going to work right, and whether certain
approaches can give you the results that you want.
The number of records within a given distance of a fuzzy merge solution
can make a big difference in terms of things like the number of matches
and the size of the resulting data set.
David L. Cassell
3115 NW Norwood Pl.
Corvallis OR 97330
Make every IM count. Download Messenger and join the iím Initiative now.
Itís free. http://im.live.com/messenger/im/home/?source=TAGHM_June07