Hi.
I have to create a spell file (job spell file) from a person month file.
Anyone has an idea of how to do? In my person month file I have persnr,
month, and a variable indicating the sequence number of the job (and other
variables not interesting in this case).
A small example of what I want
I have person month file which looks like this:
Persnr month n_job(this indicates the order numebr of the spell)
1 1 1
1 2 1
1 3 1
1 4 2
1 5 2
1 6 2
1 7 2
1 8 3
1 9 3
1 10 3
And from this I would like to create a spell file like this
Persnr beg end n_job
1 1 3 1
1 4 7 2
1 8 10 3
Thanks,
Anna
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
