Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: merge on diff id vars


From   Daniel Feenberg <feenberg@nber.org>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: merge on diff id vars
Date   Thu, 5 May 2011 10:06:25 -0400 (EDT)


On Thu, 5 May 2011, Argyn Kuketayev wrote:

Hello

I have two data sets with keys PK and FK correspondingly. i want to
merge them 1:1, except the key names are different in the dataset. i
cant figure out if it's possible by reading the manual. any tips?

. generate pk=fk

and then do the merge? I know SAS has a way to avoid the assignment, but that is because the assignment would cost an expensive pass through the data. Since the single generate statement isn't costly, Stata doesn't need a special "rename as you load" option. (But even in Stata you could just rename the variable in the primary dataset, avoiding even the small cost of the gen statement).

Daniel Feenberg


--
Argyn Kuketayev
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index