Re: st: Replacing the values of time indicator in Panel data

[Nick Cox <njcoxstata@gmail.com>]

I can't repeat your results as you don't show the original data, but
-egen, seq()- produces a variable with the values 1, 2, 3, ...

In your case, it goes in blocks 1,1,1,2,2,2,3,3,3, ...

But your -collapse- takes each block and replaces it by a single observation.

So the code segment below should create a time variable 1,2,3,...

That's what you said you wanted in your first post.

My point: if you want to go from Islamabad to Lahore, you need not go
via Karachi.

Alternatively, in terms of your original code -dum- is the variable
you ask for.

Nick
njcoxstata@gmail.com


On 14 January 2014 09:58, Muhammad Ramzan <ramzan243@gmail.com> wrote:
> bysort country: egen year2 = seq(), block(3)
> collapse gdp , by(country year2)
>
> xtset country year2
> after this i want to drop year2 variable
>
> and want to have 1 2 3 4 5 6 7 8 and so on..
>
> does not matter that the same three-year periods are used for each country.
>
> On 14 January 2014 14:53, Nick Cox <njcoxstata@gmail.com> wrote:
>> Although I answered the question, this method of analysis
>>
>> 1. Does not ensure that the same three-year periods are used for each country.
>>
>> 2. Hides when those periods were.
>>
>> Nick
>> njcoxstata@gmail.com
>>
>>
>> On 14 January 2014 09:38, Nick Cox <njcoxstata@gmail.com> wrote:
>>> You can get there directly by
>>>
>>> bysort country: egen year2 = seq(), block(3)
>>> collapse gdp , by(country year2)
>>> xtset country year2
>>>
>>> Look at the documentation for -egen- to see what -seq()- does.
>>>
>>> Nick
>>> njcoxstata@gmail.com
>>>
>>> On 14 January 2014 08:21, Muhammad Ramzan <ramzan243@gmail.com> wrote:
>>>
>>>> I am working on Panel data
>>>>
>>>>
>>>> I have collapsed the panel data with the following command
>>>>
>>>> bysort country: egen dum = seq(), block(3)
>>>> bysort country dum: gen year2 = year[1]
>>>>
>>>> collapse gdp , by(country year2)
>>>> xtset country year2
>>>>
>>>> I got the following results
>>>> country year2 gdp
>>>> 1 1970 23.5729
>>>> 1 1973 23.53363
>>>> 1 1976 23.63178
>>>> 1 1979 23.75091
>>>> 1 1982 23.84508
>>>> 1 1985 23.96356
>>>> 1 1988 24.05965
>>>> 1 1991 24.18725
>>>> 1 1994 24.32061
>>>> 1 1997 24.46905
>>>> 1 2000 24.62414
>>>> 1 2003 24.78113
>>>> 1 2006 24.96571
>>>> 2 1970
>>>> 2 1973
>>>> 2 1976
>>>> 2 1979 18.56156
>>>> 2 1982 18.71199
>>>> 2 1985 18.93953
>>>> 2 1988 19.2974
>>>> 2 1991 19.4475
>>>> 2 1994 19.56893
>>>> 2 1997 19.73937
>>>> 2 2000 19.94768
>>>> 2 2003 20.17978
>>>> 2 2006 20.43815
>>>> 4 1970 25.49603
>>>> 4 1973 25.56743
>>>> 4 1976 25.71135
>>>> 4 1979 25.78085
>>>> 4 1982 25.93498
>>>> 4 1985 26.07849
>>>> 4 1988 26.26837
>>>> 4 1991 26.38519
>>>> 4 1994 26.57137
>>>> 4 1997 26.74783
>>>> 4 2000 26.90112
>>>> 4 2003 27.10593
>>>> 4 2006 27.36182
>>>>
>>>> I want to change the values of year2 variable into 1 2 3 4 5 6 7 8 so on
>>>>
>>>>
>>>> like
>>>>
>>>> country year2 gdp year
>>>> 1 1970 23.57 1
>>>> 1 1973 23.53 2
>>>> 1 1976 23.63 3
>>>> 1 1979 23.75 4
>>>> 1 1982 23.85 5
>>>> 1 1985 23.96 6
>>>> 1 1988 24.06 7
>>>> 1 1991 24.19 8
>>>> 1 1994 24.32 9
>>>> 1 1997 24.47 10
>>>> 1 2000 24.62 11
>>>> 1 2003 24.78 12
>>>> 1 2006 24.97 13
>>>> 2 1970 1
>>>> 2 1973 2
>>>> 2 1976 3
>>>> 2 1979 18.56 4
>>>> 2 1982 18.71 5
>>>> 2 1985 18.94 6
>>>> 2 1988 19.30 7
>>>> 2 1991 19.45 8
>>>> 2 1994 19.57 9
>>>> 2 1997 19.74 10
>>>> 2 2000 19.95 11
>>>> 2 2003 20.18 12
>>>> 2 2006 20.44 13
>>>> 4 1970 25.50 1
>>>> 4 1973 25.57 2
>>>> 4 1976 25.71 3
>>>> 4 1979 25.78 4
>>>> 4 1982 25.93 5
>>>> 4 1985 26.08 6
>>>> 4 1988 26.27 7
>>>> 4 1991 26.39 8
>>>> 4 1994 26.57 9
>>>> 4 1997 26.75 10
>>>> 4 2000 26.90 11
>>>> 4 2003 27.11 12
>>>> 4 2006 27.36 13
>> *
>> *   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/
>
>
>
> --
> Assalam-o-Alaikum
>
>
>
>
>
>
>
> Muhammad Ramzan
> Lecturer (Economics)
> Pakistan Institute of Development Economics
> Islamabad
> *
> *   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/