Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| 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/