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 at the end of May, 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   Argyn Kuketayev <akuketayev@mail.primaticsfinancial.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: merge on diff id vars
Date   Thu, 5 May 2011 14:05:46 -0400

thank you,
will gen or rename the variable.

I thought it would be possible to simply provide the keys from each dataset.

On Thu, May 5, 2011 at 10:06 AM, Daniel Feenberg <feenberg@nber.org> wrote:
>
> 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/
>



-- 
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/


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