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]

st: Re: st: Re: st: Σχετ: st: diving values of a column with other values of the same column


From   Nick Cox <njcoxstata@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Re: st: Re: st: Σχετ: st: diving values of a column with other values of the same column
Date   Wed, 6 Feb 2013 00:28:00 +0000

This might help. I can't say whether it fits data you don't show us.
Also, a variable that is zz in some cases and 0 in other might be
numeric and might be string, depending on what "zz" means, so its sort
order is unpredictable.

bysort country date (specific) : gen values2 = values[1]/values[2]

Nick

On Wed, Feb 6, 2013 at 12:17 AM, Nick Cox <njcoxstata@gmail.com> wrote:
> I think you have to tell us the rule your data follow. Otherwise the
> reply to "my data are more complicated than that" is just "so your
> code needs to be more complicated than that".
>
> For a general discussion, see the Speaking Stata column in Stata
> Journal 11(2) from 2011:
>
> http://www.stata-journal.com/article.html?article=dm0055
>
> Nick
>
> On Wed, Feb 6, 2013 at 12:07 AM, Tzaloupas Dimitrov
> <tzaloupas1232@yahoo.gr> wrote:
>
>> thank you very much  scott.  The only problem is that my real panel is unbalanced. So it is not always 3 obs/ 3 obs
>>
>> Is there a way to modify your code so as to take into account this unbalanced panel data set?
>
> Scott Merryman <scott.merryman@gmail.com>
>
> On Tue, Feb 5, 2013 at 3:34 PM, Tzaloupas Dimitrov
>
>>> I have the following excel file which I import into Stata
>>>  Country          overall         specific            dates                              values
>>> DD                         gg           0             01/11/2001                               5
>>> DD                         gg           0             01/12/2001                               2
>>> DD                         gg           0             01/01/2001                               3
>>>  DD                        gg           zz           01/11/2001                               15
>>> DD                         gg           zz           01/12/2001                               12
>>> DD                         gg           zz           01/01/2001                              13
>>> EE                          gg           0             01/11/2001                               0.5
>>> EE                          gg           0             01/12/2001                               0.2
>>> EE                          gg           0             01/01/2001                               0.3
>>> EE                          gg           zz           01/11/2001                               25
>>> EE                          gg           zz           01/12/2001                               122
>>> EE                          gg           zz           01/01/2001                              2 3
>>>
>>> For each country  separately(DD and EE) I would like to   divide the values that correspond to specific==zz by the values that correspond to speciffic==0
>>>
>>> For example, for DD I want to divide the vector  of values (15 12 13) that corresponds to specific==zz by the vector (5 2 3) that corresponds to specific==0; so as to construct a new vector of values=(15/5 12/2 13/3)
>>
>>
>> bys country (spec dates) : gen values2 = values/values[_n-3]
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/


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