Re: st: merge on diff id vars

[Daniel Feenberg <feenberg@nber.org>]

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/