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]
st: Σχετ: st: diving values of a column with other values of the same column
From
Tzaloupas Dimitrov <[email protected]>
To
"[email protected]" <[email protected]>
Subject
st: Σχετ: st: diving values of a column with other values of the same column
Date
Wed, 6 Feb 2013 00:07:34 +0000 (GMT)
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?
Cheers
----- Αρχικό μήνυμα -----
Απο: Scott Merryman <[email protected]>
Προς: [email protected]
Κοιν.:
Στάλθηκε: 11:58 μ.μ. Τρίτη, 5 Φεβρουαρίου 2013
Θέμα: Re: st: diving values of a column with other values of the same column
On Tue, Feb 5, 2013 at 3:34 PM, Tzaloupas Dimitrov
<[email protected]> wrote:
> Dear all,
>
> 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]
Scott
*
* 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/
*
* 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/