Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Data management, years of schooling


From   Svend Juul <SJ@SOCI.AU.DK>
To   <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Data management, years of schooling
Date   Wed, 4 Feb 2009 08:58:39 +0100

Ronnie Babigumira wrote:
 
I have an interesting data management problem. My data look like this
hhid hi_educ
1 11
2 21
3 17
4 16
5 24
6 31
7 32
8 13
9 22

Where hi_educ is the highest level of education for household. From this I would like to extract the number of years of schooling. 
 
Now, for values below 17, the years of schooling is the last digit
for values between 21 and 24, it is 7 + the last digit
for values between 31 and 35 it is 11 + the last digit
 
What I would like to end up with is something like this
 
hhid hi_educ years
1 11 1
2 21 8
3 17 7
4 16 6
5 24 11
6 31 12
7 32 13
8 13 3
9 22 9
 
==============================================================
 
Joseph Coveney gave a couple of suggestions. Here is a third
suggestion:
 
    . generate years = mod(hi_educ,10)
    . replace years = years+7 if hi_educ>20 & hi_educ<25
    . replace years = years+11 if hi_educ>30 & hi_educ<36
     
    . list, clean
           hhid   hi_educ   years  
      1.      1        11       1  
      2.      2        21       8  
      3.      3        17       7  
      4.      4        16       6  
      5.      5        24      11  
      6.      6        31      12  
      7.      7        32      13  
      8.      8        13       3  
      9.      9        22       9  
 
It may look clumsier, but I believe it has the advantage to
be more transparent, especially to the less experienced user.
 
Svend
 
________________________________________________________ 
 
Svend Juul
Institut for Folkesundhed, Afdeling for Epidemiologi
(Institute of Public Health, Department of Epidemiology)
Bartholins Allé 2
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/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



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