st: =?iso-8859-7?B?0/fl9Dogc3Q6INP35fQ6IHN0OiBSZTogc3Q6INP35fQ6IHN0OiBkaXZp?=


From: Tzaloupas Dimitrov <tzaloupas1232@yahoo.gr>
Subject: st: =?iso-8859-7?B?0/fl9Dogc3Q6INP35fQ6IHN0OiBSZTogc3Q6INP35fQ6IHN0OiBkaXZp?=
Date: Wed, 6 Feb 2013 00:34:52 +0000 (GMT)

Next Article (by Author): st: =?iso-8859-7?B?0/fl9Dogc3Q6IFJlOiBzdDog0/fl9Dogc3Q6INP35fQ6IHN0OiBSZTog?= Tzaloupas Dimitrov
Previous Article (by Author): st: =?iso-8859-7?B?0/fl9Dogc3Q6IFJlOiBzdDog0/fl9Dogc3Q6IGRpdmluZyB2YWx1ZXMg?= Tzaloupas Dimitrov
Articles sorted by: [Date] [Author] [Subject]


Nick, I just saw your new reply


Here is the information on the variables
country :  str2 
overall  str13 
specific  str3   




-----   -----
: Tzaloupas Dimitrov <tzaloupas1232@yahoo.gr>
: "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
.: 
: 12:30 .. , 6  2013
: st: : st: Re: st: : st: diving values of a column with other values of the same column

thanks Nick. 

The data set is unbalanced. I rewrite the example

 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     zz     01/11/2001               25
 EE             gg     zz     01/12/2001               122
 

So we have 6 obs for DD and 4 for EE

I have created identifiers. So, I have 

identif Country     overall    specific      dates               values
1 DD            gg     0      01/11/2001               5
1  DD            gg     0      01/12/2001               2
1  DD            gg     0      01/01/2001               3
2  DD            gg     zz     01/11/2001               15
2   DD            gg     zz     01/12/2001               12
2  DD            gg     zz     01/01/2001               13
3 EE             gg     0      01/11/2001               0.5
3 EE             gg     0      01/12/2001               0.2
 4 EE             gg     zz     01/11/2001               25
 4 EE             gg     zz     01/12/2001               122
 

I do not thing that there a specific pattern in the data. Across countries the time series obs vary

Does this help?

Thanks



-----   -----
: Nick Cox <njcoxstata@gmail.com>
: statalist@hsphsun2.harvard.edu
.: 
: 12:17 .. , 6  2013
: st: Re: st: : st: diving values of a column with other values of the same column

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/


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

Next Article (by Author): st: =?iso-8859-7?B?0/fl9Dogc3Q6IFJlOiBzdDog0/fl9Dogc3Q6INP35fQ6IHN0OiBSZTog?= Tzaloupas Dimitrov
Previous Article (by Author): st: =?iso-8859-7?B?0/fl9Dogc3Q6IFJlOiBzdDog0/fl9Dogc3Q6IGRpdmluZyB2YWx1ZXMg?= Tzaloupas Dimitrov
Articles sorted by: [Date] [Author] [Subject]


Go to Harvard School of Public Health LWGate Home Page.