Re: st: Panel Data 5 Year Average

[Nick Cox <njcoxstata@gmail.com>]

<>

You had an answer to the same question about repeating for several
variables on 8th January.

http://www.stata.com/statalist/archive/2014-01/msg00218.html

See (for example) -help foreach-, the manual entry, and

SJ-2-2  pr0005  . . . . . .  Speaking Stata:  How to face lists with fortitude
        . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  N. J. Cox
        Q2/02   SJ 2(2):202--222                                 (no commands)
        demonstrates the usefulness of for, foreach, forvalues, and
        local macros for interactive (non programming) tasks

http://www.stata-journal.com/sjpdf.html?articlenum=pr0005

Nick
njcoxstata@gmail.com


On 11 January 2014 07:54, Muhammad Ramzan <ramzan243@gmail.com> wrote:

> Yes this is what i want .
>
> can you please also guide me how can i apply this command on all the
> variables in my data-set.


On 8 January 2014 17:27, Roberto Ferrer <refp16@gmail.com> wrote:

>>> Do you want something like:
>>>
>>>
>>>
>>> . bysort country: egen dum = seq(), block(5)
>>>
>>> . bysort country dum: gen year2 = year[1]
>>>
>>> . collapse y5=y l5=l, by(country year2)
>>>
>>> . list, sepby(country)
>>>
>>>      +---------------------------------+
>>>      | country   year2      y5      l5 |
>>>      |---------------------------------|
>>>   1. |       1    1981    22.6    8.92 |
>>>   2. |       1    1986    24.2    9.46 |
>>>   3. |       1    1991    26.6    9.98 |
>>>   4. |       1    1996    28.4   10.48 |
>>>   5. |       1    2001    30.6   10.98 |
>>>      |---------------------------------|
>>>   6. |       2    1980   .2348   .0906 |
>>>   7. |       2    1985   .2408   .0938 |
>>>   8. |       2    1990   .2462   .1076 |
>>>   9. |       2    1995   .2496   .1196 |
>>>  10. |       2    2000   .2536    .129 |
>>>  11. |       2    2005   .1285    .067 |
>>>      +---------------------------------+
*
*   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/