Kit's approach will give the same results as mine if precisely the same
periods are represented in all panels, but not otherwise.
Both approaches will fail to handle any gaps correctly.
Nick
[email protected]
Kit Baum
Why not just
bysort unit (fourwk_ending): gen t = _n
Nick Cox
If I guess your intention correctly, -egen, group()- will do it.
Diana Eastman
I have a panel data set that has several repeating four-week ending
periods:
Example:
fourwk_ending
17 Aug 96
14 Sep 96
12 Oct 96
09 Nov 96
07 Dec 96
04 Jan 97
01 Feb 97
01 Mar 97
29 Mar 97
26 Apr 97
24 May 97
21 Jun 97
I want to create a variable "trend" that will assign a numeric value to
each four-week ending period. So 17 Aug 96 might be 1, etc.
*
* 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/
