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: AW: match data


From   Anders Alexandersson <andersalex@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: AW: match data
Date   Tue, 27 Jul 2010 12:25:30 -0400

Max, merge the two datasets on the key variable(s) that each dataset
should have:

. help merge

Anders Alexandersson
andersalex@gmail.com

On Tue, Jul 27, 2010 at 12:16 PM, Maximiliano Manuel Silva Correa
<maxsilvacorrea@gmail.com> wrote:
> Thank you Martin,
>
> But if bow datasets dont have all the same variables, only some of them?
>
> 2010/7/27 Martin Weiss <martin.weiss1@gmx.de>:
>>
>> <>
>>
>>
>> First you want to -append-/-merge- the two datasets. Then it will be a piece
>> of cake.
>>
>>
>>
>> HTH
>> Martin
>>
>>
>> -----Ursprüngliche Nachricht-----
>> Von: owner-statalist@hsphsun2.harvard.edu
>> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Maximiliano
>> Manuel Silva Correa
>> Gesendet: Dienstag, 27. Juli 2010 18:03
>> An: statalist@hsphsun2.harvard.edu
>> Betreff: st: match data
>>
>> Dear stata Community
>>
>> Im trying to match data between two datasets but i dont know how? Can
>> someone explain the sintaxis about how to do this?
>>
>> Suppose we have several power transmision lines (indexed by variable
>> LINE), and several substations in between (indexed by SUBS), each of
>> them has a power consumption (POWER)
>>
>> Suppose we have two datasets, each of the corresponding to one year.
>>
>> I want to compare the power consumption between both years.
>>
>> It would be somtehing like
>>
>> By LINE SUBS: generate POWER_PAST
>>
>> So, in the dataset containing the present data, i can calculate de
>> difference in power consumtion between both years.
>>
>> Any suggetsioens? Any help will be well received. Thx in advance.
>>
>> Max

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