Anna wrote:
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).
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
------------------------------------------------------------
use -collapse-:
collapse (min) beg=month (max) end=month , by(Persnr n_job)
BTW, this was a nice and precise question; you show hat you have and what
you want, and that makes it easy to understand.
Svend
________________________________________________________
Svend Juul
Institut for Folkesundhed, Afdeling for Epidemiologi
(Institute of Public Health, Department of Epidemiology)
Vennelyst Boulevard 6
DK-8000 Aarhus C, Denmark
Phone, work: +45 8942 6090
Phone, home: +45 8693 7796
Fax: +45 8613 1580
E-mail: [email protected]
_________________________________________________________
*
* 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/
