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" <statalist@hsphsun2.harvard.edu> |
| Subject | Re: st: Replacing the values of time indicator in Panel data |
| Date | Tue, 14 Jan 2014 10:20:27 +0000 |
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/