Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: merge on diff id vars
From
Argyn Kuketayev <[email protected]>
To
[email protected]
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 <[email protected]> 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/