Hi Rijo,
This should do it:
bys id p_t (year): gen change=_n-1
However your question is not clear. The two examples are different. You also
said that change is the number of years passed since the last change in P_t,
but Change as you wrote is not this one.
Mike.
----- Original Message -----
From: "Rijo John" <[email protected]>
To: "stata" <[email protected]>
Sent: Wednesday, April 15, 2009 11:07 AM
Subject: st: Data Management
Hi,
I have a time series data set as follows.
ID year P_t-1 P_t
1 1990 16 16
1 1991 16 16
1 1996 16 16
1 2005 42 42
1 2006 42 42
1 2007 42 42
2 1990 29 29
2 1991 29 29
2 1992 29 29
Where P_t and P_t-1 represents price in year t and t-1 respectively.
What I wish to achieve is to create a new variable "Change". This
variable should show the number of years passed since the last change
in P_t. In the above example the data should finally look like below.
ID year P_t-1 P_t Change
1 1990 . 16 0
1 1991 16 16 1
1 1996 16 16 2
1 1997 16 16 3
1 2005 16 42 0
1 2006 42 42 1
1 2007 42 42 2
2 1990 . 29 0
2 1991 29 29 1
2 1992 29 29 2
2 1993 29 35 0
If I do
bysort ID P_t : gen Change=_n-1 I get the varible numbered but it
doesnt sort the year. If I sort ID and year then I cant use the _n to
generate these numbers.
Can someone help me with this?
Thanks in advance,
Rijo.
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/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/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
