Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    Constructing a new unemployment rate (lun) based on: unemployment rate (un) at the age of 23 in the region of residence (lad) at age 18.

    Dear Stata team,

    I would like to construct a new unemployment rate (lun) variable using the age 23 unemployment rate (un) in the region of residence (lad) at age 18.
    I am working with a individual level panel dataset with an example shown below:
    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input long id float year byte(jbstat hiqual_dv) float(un age lad)
728983 2001 7 3  3.6 18  97
760267 1995 7 3    . 17  64
760267 1996 7 3  4.9 18 200
760267 1999 7 1  4.3 21 200
760267 2001 2 1  4.6 23  62
761724 2004 7 3    . 19  18
761724 2004 7 3    . 19  18
763659 1997 2 3    5 19 292
763659 1998 7 3    7 20  53
763659 1999 7 3  7.1 21  53
763659 2000 7 3  5.7 22  53
763659 2001 7 3  5.5 23  53
763659 2003 2 3  3.9 25 292
763659 2004 2 3  3.6 26 292
779299 1995 7 3    . 18  53
779299 1996 7 3 10.8 19  53
779299 1997 7 3  9.3 20  53
779299 1998 7 3    7 21  53
779299 1999 2 1  3.5 22 140
779299 2000 2 1    3 23 140
779299 2001 2 1  3.2 24 140
779299 2002 2 1  3.5 25 140
802415 1993 7 3    . 18  64
802415 1994 7 3    . 19 432
802415 1995 7 3    . 20 432
802415 1996 2 1  3.4 21  64
802415 1997 2 1  5.1 22  65
802415 1998 2 1  2.5 23  64
802415 1999 2 1  2.2 24  64
802415 2000 2 1  2.1 25  64
802415 2001 2 1  2.1 26  64
802415 2002 2 1  2.9 27  64
802415 2003 2 1  2.8 28  64
803099 1996 7 3  3.4 18  64
803099 1998 7 3 10.1 20 326
822819 1997 2 3  2.9 18 243
822819 1998 2 3  2.7 19 243
822819 1999 7 3  2.3 20 243
822819 2000 7 3  2.4 21 243
822819 2001 2 1  2.3 22 243
822819 2002 2 1  7.2 23 322
822819 2003 2 1  7.7 24 322
822819 2005 7 1  6.3 26 322
843282 1997 7 1 14.8 25 352
843282 1998 7 1 12.9 26 352
843282 1999 2 1 11.2 27 352
843282 2000 2 1 12.3 28 352
843282 2001 2 1 10.2 29 352
843282 2002 2 1    6 30  70
843895 1993 7 3    . 19  69
843895 1994 7 3    . 20  69
end
label values jbstat bb_jbstat
label def bb_jbstat 2 "employed", modify
label def bb_jbstat 7 "ft studt, school", modify
label values hiqual_dv hiqual_dv
label def hiqual_dv 1 "Degree", modify
label def hiqual_dv 3 "A level etc", modify
    For example, take individual (760267) who lives in region/lad (200) at age 18. I would want the unemployment rate (un) in that region (200) five years later. Notice, I would not want the unemployment rate (un) of that person in his current region of residence (62).

    I hope this data example is of some use and I am making sense.

    I would highly appreciate your help.

    Best,
    Nico










    Tags: None
  • #2
    Just a brief follow-up for the above #1.
    I would need this newly constructed unemployment rate (lun) entering the dataset time-invariant over individuals (id) over all year time periods.
    Thanks,
    Best,
    Nico

    Comment

    • #3
      Code:
      * Example generated by -dataex-. For more info, type help dataex
clear
input long id float year byte(jbstat hiqual_dv) float(un age lad)
728983 2001 7 3  3.6 18  97
760267 1995 7 3    . 17  64
760267 1996 7 3  4.9 18 200
760267 1999 7 1  4.3 21 200
760267 2001 2 1  4.6 23  62
761724 2004 7 3    . 19  18
761724 2004 7 3    . 19  18
763659 1997 2 3    5 19 292
763659 1998 7 3    7 20  53
763659 1999 7 3  7.1 21  53
763659 2000 7 3  5.7 22  53
763659 2001 7 3  5.5 23  53
763659 2003 2 3  3.9 25 292
763659 2004 2 3  3.6 26 292
779299 1995 7 3    . 18  53
779299 1996 7 3 10.8 19  53
779299 1997 7 3  9.3 20  53
779299 1998 7 3    7 21  53
779299 1999 2 1  3.5 22 140
779299 2000 2 1    3 23 140
779299 2001 2 1  3.2 24 140
779299 2002 2 1  3.5 25 140
802415 1993 7 3    . 18  64
802415 1994 7 3    . 19 432
802415 1995 7 3    . 20 432
802415 1996 2 1  3.4 21  64
802415 1997 2 1  5.1 22  65
802415 1998 2 1  2.5 23  64
802415 1999 2 1  2.2 24  64
802415 2000 2 1  2.1 25  64
802415 2001 2 1  2.1 26  64
802415 2002 2 1  2.9 27  64
802415 2003 2 1  2.8 28  64
803099 1996 7 3  3.4 18  64
803099 1998 7 3 10.1 20 326
822819 1997 2 3  2.9 18 243
822819 1998 2 3  2.7 19 243
822819 1999 7 3  2.3 20 243
822819 2000 7 3  2.4 21 243
822819 2001 2 1  2.3 22 243
822819 2002 2 1  7.2 23 322
822819 2003 2 1  7.7 24 322
822819 2005 7 1  6.3 26 322
843282 1997 7 1 14.8 25 352
843282 1998 7 1 12.9 26 352
843282 1999 2 1 11.2 27 352
843282 2000 2 1 12.3 28 352
843282 2001 2 1 10.2 29 352
843282 2002 2 1    6 30  70
843895 1993 7 3    . 19  69
843895 1994 7 3    . 20  69
end
label values jbstat bb_jbstat
label def bb_jbstat 2 "employed", modify
label def bb_jbstat 7 "ft studt, school", modify
label values hiqual_dv hiqual_dv
label def hiqual_dv 1 "Degree", modify
label def hiqual_dv 3 "A level etc", modify

gen year5=year+5
frame put id year un lad, into(join)
frame join: contract *
frlink m:1 id year5, frame(join id year)
frget wanted=un, from(join)
frame drop join
      Res.:

      Code:
      . l, sepby(id)

     +-------------------------------------------------------------------------------------------+
     |     id   year             jbstat     hiqual_dv     un   age   lad   year5   join   wanted |
     |-------------------------------------------------------------------------------------------|
  1. | 728983   2001   ft studt, school   A level etc    3.6    18    97    2006      .        . |
     |-------------------------------------------------------------------------------------------|
  2. | 760267   1995   ft studt, school   A level etc      .    17    64    2000      .        . |
  3. | 760267   1996   ft studt, school   A level etc    4.9    18   200    2001      5      4.6 |
  4. | 760267   1999   ft studt, school        Degree    4.3    21   200    2004      .        . |
  5. | 760267   2001           employed        Degree    4.6    23    62    2006      .        . |
     |-------------------------------------------------------------------------------------------|
  6. | 761724   2004   ft studt, school   A level etc      .    19    18    2009      .        . |
  7. | 761724   2004   ft studt, school   A level etc      .    19    18    2009      .        . |
     |-------------------------------------------------------------------------------------------|
  8. | 763659   1997           employed   A level etc      5    19   292    2002      .        . |
  9. | 763659   1998   ft studt, school   A level etc      7    20    53    2003     12      3.9 |
 10. | 763659   1999   ft studt, school   A level etc    7.1    21    53    2004     13      3.6 |
 11. | 763659   2000   ft studt, school   A level etc    5.7    22    53    2005      .        . |
 12. | 763659   2001   ft studt, school   A level etc    5.5    23    53    2006      .        . |
 13. | 763659   2003           employed   A level etc    3.9    25   292    2008      .        . |
 14. | 763659   2004           employed   A level etc    3.6    26   292    2009      .        . |
     |-------------------------------------------------------------------------------------------|
 15. | 779299   1995   ft studt, school   A level etc      .    18    53    2000     19        3 |
 16. | 779299   1996   ft studt, school   A level etc   10.8    19    53    2001     20      3.2 |
 17. | 779299   1997   ft studt, school   A level etc    9.3    20    53    2002     21      3.5 |
 18. | 779299   1998   ft studt, school   A level etc      7    21    53    2003      .        . |
 19. | 779299   1999           employed        Degree    3.5    22   140    2004      .        . |
 20. | 779299   2000           employed        Degree      3    23   140    2005      .        . |
 21. | 779299   2001           employed        Degree    3.2    24   140    2006      .        . |
 22. | 779299   2002           employed        Degree    3.5    25   140    2007      .        . |
     |-------------------------------------------------------------------------------------------|
 23. | 802415   1993   ft studt, school   A level etc      .    18    64    1998     27      2.5 |
 24. | 802415   1994   ft studt, school   A level etc      .    19   432    1999     28      2.2 |
 25. | 802415   1995   ft studt, school   A level etc      .    20   432    2000     29      2.1 |
 26. | 802415   1996           employed        Degree    3.4    21    64    2001     30      2.1 |
 27. | 802415   1997           employed        Degree    5.1    22    65    2002     31      2.9 |
 28. | 802415   1998           employed        Degree    2.5    23    64    2003     32      2.8 |
 29. | 802415   1999           employed        Degree    2.2    24    64    2004      .        . |
 30. | 802415   2000           employed        Degree    2.1    25    64    2005      .        . |
 31. | 802415   2001           employed        Degree    2.1    26    64    2006      .        . |
 32. | 802415   2002           employed        Degree    2.9    27    64    2007      .        . |
 33. | 802415   2003           employed        Degree    2.8    28    64    2008      .        . |
     |-------------------------------------------------------------------------------------------|
 34. | 803099   1996   ft studt, school   A level etc    3.4    18    64    2001      .        . |
 35. | 803099   1998   ft studt, school   A level etc   10.1    20   326    2003      .        . |
     |-------------------------------------------------------------------------------------------|
 36. | 822819   1997           employed   A level etc    2.9    18   243    2002     40      7.2 |
 37. | 822819   1998           employed   A level etc    2.7    19   243    2003     41      7.7 |
 38. | 822819   1999   ft studt, school   A level etc    2.3    20   243    2004      .        . |
 39. | 822819   2000   ft studt, school   A level etc    2.4    21   243    2005     42      6.3 |
 40. | 822819   2001           employed        Degree    2.3    22   243    2006      .        . |
 41. | 822819   2002           employed        Degree    7.2    23   322    2007      .        . |
 42. | 822819   2003           employed        Degree    7.7    24   322    2008      .        . |
 43. | 822819   2005   ft studt, school        Degree    6.3    26   322    2010      .        . |
     |-------------------------------------------------------------------------------------------|
 44. | 843282   1997   ft studt, school        Degree   14.8    25   352    2002     48        6 |
 45. | 843282   1998   ft studt, school        Degree   12.9    26   352    2003      .        . |
 46. | 843282   1999           employed        Degree   11.2    27   352    2004      .        . |
 47. | 843282   2000           employed        Degree   12.3    28   352    2005      .        . |
 48. | 843282   2001           employed        Degree   10.2    29   352    2006      .        . |
 49. | 843282   2002           employed        Degree      6    30    70    2007      .        . |
     |-------------------------------------------------------------------------------------------|
 50. | 843895   1993   ft studt, school   A level etc      .    19    69    1998      .        . |
 51. | 843895   1994   ft studt, school   A level etc      .    20    69    1999      .        . |
     +-------------------------------------------------------------------------------------------+

      Comment

      • #4
        Oops. Only the region and year should matter for the unemployment rate.

        Code:
        * Example generated by -dataex-. For more info, type help dataex
clear
input long id float year byte(jbstat hiqual_dv) float(un age lad)
728983 2001 7 3  3.6 18  97
760267 1995 7 3    . 17  64
760267 1996 7 3  4.9 18 200
760267 1999 7 1  4.3 21 200
760267 2001 2 1  4.6 23  62
761724 2004 7 3    . 19  18
761724 2004 7 3    . 19  18
763659 1997 2 3    5 19 292
763659 1998 7 3    7 20  53
763659 1999 7 3  7.1 21  53
763659 2000 7 3  5.7 22  53
763659 2001 7 3  5.5 23  53
763659 2003 2 3  3.9 25 292
763659 2004 2 3  3.6 26 292
779299 1995 7 3    . 18  53
779299 1996 7 3 10.8 19  53
779299 1997 7 3  9.3 20  53
779299 1998 7 3    7 21  53
779299 1999 2 1  3.5 22 140
779299 2000 2 1    3 23 140
779299 2001 2 1  3.2 24 140
779299 2002 2 1  3.5 25 140
802415 1993 7 3    . 18  64
802415 1994 7 3    . 19 432
802415 1995 7 3    . 20 432
802415 1996 2 1  3.4 21  64
802415 1997 2 1  5.1 22  65
802415 1998 2 1  2.5 23  64
802415 1999 2 1  2.2 24  64
802415 2000 2 1  2.1 25  64
802415 2001 2 1  2.1 26  64
802415 2002 2 1  2.9 27  64
802415 2003 2 1  2.8 28  64
803099 1996 7 3  3.4 18  64
803099 1998 7 3 10.1 20 326
822819 1997 2 3  2.9 18 243
822819 1998 2 3  2.7 19 243
822819 1999 7 3  2.3 20 243
822819 2000 7 3  2.4 21 243
822819 2001 2 1  2.3 22 243
822819 2002 2 1  7.2 23 322
822819 2003 2 1  7.7 24 322
822819 2005 7 1  6.3 26 322
843282 1997 7 1 14.8 25 352
843282 1998 7 1 12.9 26 352
843282 1999 2 1 11.2 27 352
843282 2000 2 1 12.3 28 352
843282 2001 2 1 10.2 29 352
843282 2002 2 1    6 30  70
843895 1993 7 3    . 19  69
843895 1994 7 3    . 20  69
end
label values jbstat bb_jbstat
label def bb_jbstat 2 "employed", modify
label def bb_jbstat 7 "ft studt, school", modify
label values hiqual_dv hiqual_dv
label def hiqual_dv 1 "Degree", modify
label def hiqual_dv 3 "A level etc", modify

gen year5=year+5
frame put year un lad, into(join)
frame join: contract *
frlink m:1 year5 lad, frame(join year lad)
frget wanted=un, from(join)
frame drop join
        Res.:

        Code:
        . l, sepby(id)

     +-------------------------------------------------------------------------------------------+
     |     id   year             jbstat     hiqual_dv     un   age   lad   year5   join   wanted |
     |-------------------------------------------------------------------------------------------|
  1. | 728983   2001   ft studt, school   A level etc    3.6    18    97    2006      .        . |
     |-------------------------------------------------------------------------------------------|
  2. | 760267   1995   ft studt, school   A level etc      .    17    64    2000     28      2.1 |
  3. | 760267   1996   ft studt, school   A level etc    4.9    18   200    2001      .        . |
  4. | 760267   1999   ft studt, school        Degree    4.3    21   200    2004      .        . |
  5. | 760267   2001           employed        Degree    4.6    23    62    2006      .        . |
     |-------------------------------------------------------------------------------------------|
  6. | 761724   2004   ft studt, school   A level etc      .    19    18    2009      .        . |
  7. | 761724   2004   ft studt, school   A level etc      .    19    18    2009      .        . |
     |-------------------------------------------------------------------------------------------|
  8. | 763659   1997           employed   A level etc      5    19   292    2002      .        . |
  9. | 763659   1998   ft studt, school   A level etc      7    20    53    2003      .        . |
 10. | 763659   1999   ft studt, school   A level etc    7.1    21    53    2004      .        . |
 11. | 763659   2000   ft studt, school   A level etc    5.7    22    53    2005      .        . |
 12. | 763659   2001   ft studt, school   A level etc    5.5    23    53    2006      .        . |
 13. | 763659   2003           employed   A level etc    3.9    25   292    2008      .        . |
 14. | 763659   2004           employed   A level etc    3.6    26   292    2009      .        . |
     |-------------------------------------------------------------------------------------------|
 15. | 779299   1995   ft studt, school   A level etc      .    18    53    2000     27      5.7 |
 16. | 779299   1996   ft studt, school   A level etc   10.8    19    53    2001     32      5.5 |
 17. | 779299   1997   ft studt, school   A level etc    9.3    20    53    2002      .        . |
 18. | 779299   1998   ft studt, school   A level etc      7    21    53    2003      .        . |
 19. | 779299   1999           employed        Degree    3.5    22   140    2004      .        . |
 20. | 779299   2000           employed        Degree      3    23   140    2005      .        . |
 21. | 779299   2001           employed        Degree    3.2    24   140    2006      .        . |
 22. | 779299   2002           employed        Degree    3.5    25   140    2007      .        . |
     |-------------------------------------------------------------------------------------------|
 23. | 802415   1993   ft studt, school   A level etc      .    18    64    1998     17      2.5 |
 24. | 802415   1994   ft studt, school   A level etc      .    19   432    1999      .        . |
 25. | 802415   1995   ft studt, school   A level etc      .    20   432    2000      .        . |
 26. | 802415   1996           employed        Degree    3.4    21    64    2001     34      2.1 |
 27. | 802415   1997           employed        Degree    5.1    22    65    2002      .        . |
 28. | 802415   1998           employed        Degree    2.5    23    64    2003     43      2.8 |
 29. | 802415   1999           employed        Degree    2.2    24    64    2004      .        . |
 30. | 802415   2000           employed        Degree    2.1    25    64    2005      .        . |
 31. | 802415   2001           employed        Degree    2.1    26    64    2006      .        . |
 32. | 802415   2002           employed        Degree    2.9    27    64    2007      .        . |
 33. | 802415   2003           employed        Degree    2.8    28    64    2008      .        . |
     |-------------------------------------------------------------------------------------------|
 34. | 803099   1996   ft studt, school   A level etc    3.4    18    64    2001     34      2.1 |
 35. | 803099   1998   ft studt, school   A level etc   10.1    20   326    2003      .        . |
     |-------------------------------------------------------------------------------------------|
 36. | 822819   1997           employed   A level etc    2.9    18   243    2002      .        . |
 37. | 822819   1998           employed   A level etc    2.7    19   243    2003      .        . |
 38. | 822819   1999   ft studt, school   A level etc    2.3    20   243    2004      .        . |
 39. | 822819   2000   ft studt, school   A level etc    2.4    21   243    2005      .        . |
 40. | 822819   2001           employed        Degree    2.3    22   243    2006      .        . |
 41. | 822819   2002           employed        Degree    7.2    23   322    2007      .        . |
 42. | 822819   2003           employed        Degree    7.7    24   322    2008      .        . |
 43. | 822819   2005   ft studt, school        Degree    6.3    26   322    2010      .        . |
     |-------------------------------------------------------------------------------------------|
 44. | 843282   1997   ft studt, school        Degree   14.8    25   352    2002      .        . |
 45. | 843282   1998   ft studt, school        Degree   12.9    26   352    2003      .        . |
 46. | 843282   1999           employed        Degree   11.2    27   352    2004      .        . |
 47. | 843282   2000           employed        Degree   12.3    28   352    2005      .        . |
 48. | 843282   2001           employed        Degree   10.2    29   352    2006      .        . |
 49. | 843282   2002           employed        Degree      6    30    70    2007      .        . |
     |-------------------------------------------------------------------------------------------|
 50. | 843895   1993   ft studt, school   A level etc      .    19    69    1998      .        . |
 51. | 843895   1994   ft studt, school   A level etc      .    20    69    1999      .        . |
     +-------------------------------------------------------------------------------------------+

.

        Comment

        • #5
          Dear Andrew,

          I really appreciate your second reply (#4). You are almost there, but not quite because I stated my question imprecisely. In row 23 of your output (#4), wanted is equal to 2.5. This is exactly the unemployment rate I want. However, I do not want to have it vary over id and year. In essence, I want 2.5 entering row 23 through 33 for this particular individual (802415). Essentially, the unemployment rate I am after is only for the first five year period in the sense that (18+5=age=23). It should enter without variation over time for each individual.
          The unemployment you find in row 34 of 2.1 (wanted) is also what I want except that it should enter rows 34 through 43.
          Thanks so much, I think you are vey close.

          Comment

          • #6
            Just one additional step, then (highlighted).

            Code:
            * Example generated by -dataex-. For more info, type help dataex
clear
input long id float year byte(jbstat hiqual_dv) float(un age lad)
728983 2001 7 3  3.6 18  97
760267 1995 7 3    . 17  64
760267 1996 7 3  4.9 18 200
760267 1999 7 1  4.3 21 200
760267 2001 2 1  4.6 23  62
761724 2004 7 3    . 19  18
761724 2004 7 3    . 19  18
763659 1997 2 3    5 19 292
763659 1998 7 3    7 20  53
763659 1999 7 3  7.1 21  53
763659 2000 7 3  5.7 22  53
763659 2001 7 3  5.5 23  53
763659 2003 2 3  3.9 25 292
763659 2004 2 3  3.6 26 292
779299 1995 7 3    . 18  53
779299 1996 7 3 10.8 19  53
779299 1997 7 3  9.3 20  53
779299 1998 7 3    7 21  53
779299 1999 2 1  3.5 22 140
779299 2000 2 1    3 23 140
779299 2001 2 1  3.2 24 140
779299 2002 2 1  3.5 25 140
802415 1993 7 3    . 18  64
802415 1994 7 3    . 19 432
802415 1995 7 3    . 20 432
802415 1996 2 1  3.4 21  64
802415 1997 2 1  5.1 22  65
802415 1998 2 1  2.5 23  64
802415 1999 2 1  2.2 24  64
802415 2000 2 1  2.1 25  64
802415 2001 2 1  2.1 26  64
802415 2002 2 1  2.9 27  64
802415 2003 2 1  2.8 28  64
803099 1996 7 3  3.4 18  64
803099 1998 7 3 10.1 20 326
822819 1997 2 3  2.9 18 243
822819 1998 2 3  2.7 19 243
822819 1999 7 3  2.3 20 243
822819 2000 7 3  2.4 21 243
822819 2001 2 1  2.3 22 243
822819 2002 2 1  7.2 23 322
822819 2003 2 1  7.7 24 322
822819 2005 7 1  6.3 26 322
843282 1997 7 1 14.8 25 352
843282 1998 7 1 12.9 26 352
843282 1999 2 1 11.2 27 352
843282 2000 2 1 12.3 28 352
843282 2001 2 1 10.2 29 352
843282 2002 2 1    6 30  70
843895 1993 7 3    . 19  69
843895 1994 7 3    . 20  69
end
label values jbstat bb_jbstat
label def bb_jbstat 2 "employed", modify
label def bb_jbstat 7 "ft studt, school", modify
label values hiqual_dv hiqual_dv
label def hiqual_dv 1 "Degree", modify
label def hiqual_dv 3 "A level etc", modify

gen year5=year+5
frame put year un lad, into(join)
frame join: contract *
frlink m:1 year5 lad, frame(join year lad)
frget val=un, from(join)
bys id: egen wanted= max(cond(age==18, val, .))
frame drop join
            Res.:

            Code:
            . l, sepby(id)

     +-------------------------------------------------------------------------------------------------+
     |     id   year             jbstat     hiqual_dv     un   age   lad   year5   join   val   wanted |
     |-------------------------------------------------------------------------------------------------|
  1. | 728983   2001   ft studt, school   A level etc    3.6    18    97    2006      .     .        . |
     |-------------------------------------------------------------------------------------------------|
  2. | 760267   1995   ft studt, school   A level etc      .    17    64    2000     28   2.1        . |
  3. | 760267   1996   ft studt, school   A level etc    4.9    18   200    2001      .     .        . |
  4. | 760267   1999   ft studt, school        Degree    4.3    21   200    2004      .     .        . |
  5. | 760267   2001           employed        Degree    4.6    23    62    2006      .     .        . |
     |-------------------------------------------------------------------------------------------------|
  6. | 761724   2004   ft studt, school   A level etc      .    19    18    2009      .     .        . |
  7. | 761724   2004   ft studt, school   A level etc      .    19    18    2009      .     .        . |
     |-------------------------------------------------------------------------------------------------|
  8. | 763659   1997           employed   A level etc      5    19   292    2002      .     .        . |
  9. | 763659   1998   ft studt, school   A level etc      7    20    53    2003      .     .        . |
 10. | 763659   1999   ft studt, school   A level etc    7.1    21    53    2004      .     .        . |
 11. | 763659   2000   ft studt, school   A level etc    5.7    22    53    2005      .     .        . |
 12. | 763659   2001   ft studt, school   A level etc    5.5    23    53    2006      .     .        . |
 13. | 763659   2003           employed   A level etc    3.9    25   292    2008      .     .        . |
 14. | 763659   2004           employed   A level etc    3.6    26   292    2009      .     .        . |
     |-------------------------------------------------------------------------------------------------|
 15. | 779299   1995   ft studt, school   A level etc      .    18    53    2000     27   5.7      5.7 |
 16. | 779299   1996   ft studt, school   A level etc   10.8    19    53    2001     32   5.5      5.7 |
 17. | 779299   1997   ft studt, school   A level etc    9.3    20    53    2002      .     .      5.7 |
 18. | 779299   1998   ft studt, school   A level etc      7    21    53    2003      .     .      5.7 |
 19. | 779299   1999           employed        Degree    3.5    22   140    2004      .     .      5.7 |
 20. | 779299   2000           employed        Degree      3    23   140    2005      .     .      5.7 |
 21. | 779299   2001           employed        Degree    3.2    24   140    2006      .     .      5.7 |
 22. | 779299   2002           employed        Degree    3.5    25   140    2007      .     .      5.7 |
     |-------------------------------------------------------------------------------------------------|
 23. | 802415   1993   ft studt, school   A level etc      .    18    64    1998     17   2.5      2.5 |
 24. | 802415   1994   ft studt, school   A level etc      .    19   432    1999      .     .      2.5 |
 25. | 802415   1995   ft studt, school   A level etc      .    20   432    2000      .     .      2.5 |
 26. | 802415   1996           employed        Degree    3.4    21    64    2001     34   2.1      2.5 |
 27. | 802415   1997           employed        Degree    5.1    22    65    2002      .     .      2.5 |
 28. | 802415   1998           employed        Degree    2.5    23    64    2003     43   2.8      2.5 |
 29. | 802415   1999           employed        Degree    2.2    24    64    2004      .     .      2.5 |
 30. | 802415   2000           employed        Degree    2.1    25    64    2005      .     .      2.5 |
 31. | 802415   2001           employed        Degree    2.1    26    64    2006      .     .      2.5 |
 32. | 802415   2002           employed        Degree    2.9    27    64    2007      .     .      2.5 |
 33. | 802415   2003           employed        Degree    2.8    28    64    2008      .     .      2.5 |
     |-------------------------------------------------------------------------------------------------|
 34. | 803099   1996   ft studt, school   A level etc    3.4    18    64    2001     34   2.1      2.1 |
 35. | 803099   1998   ft studt, school   A level etc   10.1    20   326    2003      .     .      2.1 |
     |-------------------------------------------------------------------------------------------------|
 36. | 822819   1997           employed   A level etc    2.9    18   243    2002      .     .        . |
 37. | 822819   1998           employed   A level etc    2.7    19   243    2003      .     .        . |
 38. | 822819   1999   ft studt, school   A level etc    2.3    20   243    2004      .     .        . |
 39. | 822819   2000   ft studt, school   A level etc    2.4    21   243    2005      .     .        . |
 40. | 822819   2001           employed        Degree    2.3    22   243    2006      .     .        . |
 41. | 822819   2002           employed        Degree    7.2    23   322    2007      .     .        . |
 42. | 822819   2003           employed        Degree    7.7    24   322    2008      .     .        . |
 43. | 822819   2005   ft studt, school        Degree    6.3    26   322    2010      .     .        . |
     |-------------------------------------------------------------------------------------------------|
 44. | 843282   1997   ft studt, school        Degree   14.8    25   352    2002      .     .        . |
 45. | 843282   1998   ft studt, school        Degree   12.9    26   352    2003      .     .        . |
 46. | 843282   1999           employed        Degree   11.2    27   352    2004      .     .        . |
 47. | 843282   2000           employed        Degree   12.3    28   352    2005      .     .        . |
 48. | 843282   2001           employed        Degree   10.2    29   352    2006      .     .        . |
 49. | 843282   2002           employed        Degree      6    30    70    2007      .     .        . |
     |-------------------------------------------------------------------------------------------------|
 50. | 843895   1993   ft studt, school   A level etc      .    19    69    1998      .     .        . |
 51. | 843895   1994   ft studt, school   A level etc      .    20    69    1999      .     .        . |
     +-------------------------------------------------------------------------------------------------+

.

            Comment

            • #7
              Hi Andrew,

              I hope you are well, you helped me before, and I am very grateful for your help now and in the past.
              I am not familiar with the code you used, but I will take it over one to one.
              I will not get around applying it to my data today, but I will do so tomorrow.
              In the meantime, thanks again for your support.
              Best,
              Nico

              Comment

              • #8
                Hi Andrew,
                As I wrote, I will apply the code to my dataset tomorrow.
                However, I think there is a minor mistake in the outcome.
                If you look at row 15 of your output #6.
                The person lives in region (lad) 53 at age 18.
                Five years later, the unemployment in lad 53 is 5.5 (row 12).
                However, your code gives the unemployment of 5.7 instead of 5.5.
                It's a minor thing in this example, but it might be a bigger thing in my actual data.
                Would you be able to have a look again?

                I would appreciate that.
                Best,
                Nico










                Comment

                • #9
                  Originally posted by Nico Ochmann View Post
                  The person lives in region (lad) 53 at age 18.
                  Five years later, the unemployment in lad 53 is 5.5 (row 12).
                  However, your code gives the unemployment of 5.7 instead of 5.5.
                  The individual was 18 in the year 1995. 5 years later is 2000, so the relevant observation is row 11 with unemployment= 5.7.

                  11. | 763659 2000 ft studt, school A level etc 5.7 22 53 2005 . . . |
                  Last edited by Andrew Musau; 04 Feb 2026, 04:30.

                  Comment

                  • #10
                    Hi Andrew,
                    You are absolutely correct, sorry about that.
                    I really appreciate it.
                    I will have a look at my data now, it should work fine, I just hope the final results hold up given your code.
                    I had coded it incorrectly before.

                    Best,
                    Nico

                    Comment

                    Previous Next
                    Working...
                    X