Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Spells creation


From   "Svend Juul" <SJ@SOCI.AU.DK>
To   <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Spells creation
Date   Thu, 23 Mar 2006 13:11:26 +0100

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:       sj@soci.au.dk
_________________________________________________________

*
*   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/



© Copyright 1996–2020 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index