Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

# Re: st:transition from unemployment

 From Nick Cox To statalist@hsphsun2.harvard.edu Subject Re: st:transition from unemployment Date Sun, 22 Apr 2012 11:42:28 +0100

```Your previous question was finding the time of the first transition
from employment. This question seems to centre on the state reached by
the first transition.

As already explained in my earlier posting, but translated here to

bysort id_res : egen firsttime = min(month / inlist(steoold, 1, 2, 3))

gives the time of the first transition from unemployment -- and so

by id_res : egen newstatus = total(steoold * (month == firsttime))

records what the status becomes.

2012/4/22 Мещеряков Антон <anton.mesh777@yandex.ru>:
> Thanks for your help Katya and Nick.
>
> gen month=(p2-600)*(year==2006)+(p2-700)*(year==2007)
> bysort id_res: egen emp1=min(month/(steoold==1)) if year==2007
> bysort id_res: egen unemp2=min(month/(steoold==2)) if year==2007
> bysort id_res: egen olf3=min(month/(steoold==3)) if year==2007
> gen emp=1 if emp1==month
> replace emp=0 if emp==.
> gen unemp=1 if unemp2==month
> replace unemp=0 if unemp==.
> gen olf=1 if olf3==month
> replace olf=0 if olf==.
>
> A this moment I have three generate variables, which show the exit of unemployment at the first questioning in 2007:
> - emp (1-emp, 0 -othres )
> - unemp (1- unemp, 0 -others)
> - olf (1-olf, 0 -others)
>
> Now I would like to do next:
>
> 1. identify the structure of each group, for example (in per cent):
>
> 1a. how many people who become empl, olf or unempl are females and males
> It was easy to do
> tab emp stat,r
> tab unemp stat,r
>
> BUT i do not know how to show this:
> 1.b. i need per cent of respondents who change status in emp, olf and unemp amid females
> and males.
>
> It may look like this
>
> tab emp stat if year==2007,col
>
> BUT i think it is wrong cause in this way it covers the whole respondents in each category during 2007
> for example, employed:
>
>           |         Sex
>       emp |     female    male |     Total
> -----------+----------------------+----------
>         0 | 314.57674   341.4202 | 655.99694
>           |     87.13      84.63 |     85.81
> -----------+----------------------+----------
>         1 | 46.453121  61.995632 | 108.44875
>           |     12.87      15.37 |     14.19
> -----------+----------------------+----------
>     Total | 361.02986  403.41584 |  764.4457
>           |    100.00     100.00 |    100.00
>
>
> Do you have any suggestions?

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