Re: st: transform data from spell format into ordinary panel data

[DTA <altruist81@gmx.de>]

I understood. My followup quetion was rather directed towards other 
stata users who may know more about user-written routines (which I would 
simply like to know about too).

Best,
Darjusch


-------- Original Message --------
Subject: Re: st: transform data from spell format into ordinary panel data
From: Nick Cox <njcoxstata@gmail.com>
To: statalist@hsphsun2.harvard.edu <statalist@hsphsun2.harvard.edu>
Date: Fri Aug 16 2013 00:50:16 GMT+0200
> I don't know what I don't know or have forgotten. I did say "may be".
> Nick
> njcoxstata@gmail.com
>
>
> On 15 August 2013 22:10, DTA <altruist81@gmx.de> wrote:
> > Thanks Nick,
> >
> > thats indeed a very simple work aroundand seems to solve my question. Would
> > be interesting to know more about the user-written or official commands that
> > you mention.
> >
> > Best,
> > Darjusch
> >
> >
> >
> > -------- Original Message --------
> > Subject: Re: st: transform data from spell format into ordinary panel data
> > From: Nick Cox <njcoxstata@gmail.com>
> > To: statalist@hsphsun2.harvard.edu <statalist@hsphsun2.harvard.edu>
> > Date: Thu Aug 15 2013 17:55:12 GMT+0200
> > > Stata is very, very good at these problems. Here is one way, and there
> > > may be user-written programs or official commands that are even
> > > quicker.
> > >
> > > . input panelid spellid t1 t2
> > >
> > >          panelid    spellid         t1         t2
> > >     1. 1 1 502 503
> > >     2. 1 2 504 604
> > >     3. 2 1 502 555
> > >     4. 2 2 556 600
> > >     5. 2 3 601 604
> > >     6. 3 1 550 553
> > >     7. end
> > >
> > > . gen nspell = t2 - t1 + 1
> > >
> > > . expand nspell
> > > (204 observations created)
> > >
> > > . bysort panelid spellid : gen t = t1[1] + _n - 1
> > >
> > > Nick
> > > njcoxstata@gmail.com
> > >
> > > On 15 August 2013 16:36,  Darjusch Tafreschi <altruist81@gmx.de> wrote:
> > >
> > > > the title pretty much describes my problem:
> > > >
> > > > I have a data set that contains persons and their employment episodes in
> > > > the following format which I'm used to call "spell format " (not sure if
> > > > thats a common expression (?). It is structured as follows:
> > > >
> > > >
> > > > Person-ID | Emploment-Episode-ID | start | end | Income | sector? |
> > > > hrsperweek ...
> > > >
> > > > Any person can have multiple emploment spells, each with start, end,
> > > > income, hoursperweek worked and a bunch of more variables. Moreover, the
> > > > durations of the employment states can vary across and within persons.
> > > >
> > > > The date is not in a typical day-month-year format,  but represented by a
> > > > number that represents the time elapsed since 1970/01/01.
> > > >
> > > >
> > > > It looks like this then:
> > > >
> > > > 1 1 502 503 3.500 € public sector 42 hrsperweek
> > > > 1 2 504 604 3.900 € public sector 42 hrsperweek
> > > >
> > > > 2 1 502 555 2.200 € private sector 20 hrsperweek
> > > > 2 2 556 600 4.000 € private sector 42 hrsperweek
> > > > 2 3 601 604 4.500 € private sector 40 hrsperweek
> > > >
> > > > 3 1 550 553 1.500 € self-employed 60 hrspwerweek
> > > >
> > > >
> > > > I hope you can see that not necessarily the whole time period is covered,
> > > > there can be gaps in which persons have been unemployed or studying or
> > > > whatever.
> > > >
> > > > I would like to transform this data into something like a standard
> > > > balanced panel dataset which gives me the state for every person in every
> > > > month over the whole period (in this example the period 502-604). In
> > > > particular it should look like this:
> > > >
> > > > Month | Person-ID | Emploment-Episode-ID | Income | sector? | hrsperweek
> > > > ...
> > > >
> > > > In the end it shold be a HUGE data file looking like this:
> > > >
> > > > 502 1 1 ...
> > > > 502 2 1 ...
> > > > 502 3 -
> > > > 503 1 1 ...
> > > > 503 2 1 ...
> > > > 503 3 -
> > > > 504 1 2 ...
> > > > 504 2 1 ...
> > > > 504 3 -
> > > >
> > > > and so on.
> > > >
> > > >
> > > > I looked into statas survival capabilities, but am not sure if those are
> > > > really helpful here.
> > > >
> > > > Can anyone tell me how to approach my problem??
> > > *
> > >
> > > *   For searches and help try:
> > > *   http://www.stata.com/help.cgi?search
> > > *   http://www.stata.com/support/faqs/resources/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/faqs/resources/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/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/