---------------------------------------------------------------------------------
       log:  Z:\Econ 70\datamanagment.smcl
  log type:  smcl
 opened on:   9 Jun 2004, 14:06:15

. infile shcod year no pri pric sec secc high highc tyr pyr syr hyr  using "Z:\Eco
> n 70\SCHOOL1.RAW"
(792 observations read)

. rename shcod shcode

. label data "Barro and Lee's education data"

. label variable pyr "average years of primary schooling in total population"

. describe

Contains data
  obs:           792                          Barro and Lee's education data
 vars:            13                          
 size:        44,352 (95.8% of memory free)
-------------------------------------------------------------------------------
              storage  display     value
variable name   type   format      label      variable label
-------------------------------------------------------------------------------
shcode          float  %9.0g                  
year            float  %9.0g                  
no              float  %9.0g                  
pri             float  %9.0g                  
pric            float  %9.0g                  
sec             float  %9.0g                  
secc            float  %9.0g                  
high            float  %9.0g                  
highc           float  %9.0g                  
tyr             float  %9.0g                  
pyr             float  %9.0g                  average years of primary
                                                schooling in total population
syr             float  %9.0g                  
hyr             float  %9.0g                  
-------------------------------------------------------------------------------
Sorted by:  
     Note:  dataset has changed since last saved

. list shcode year if no >95

     +---------------+
     | shcode   year |
     |---------------|
  8. |      3     60 |
  9. |      3     65 |
 10. |      3     70 |
 36. |     12     60 |
 37. |     12     65 |
     |---------------|
 38. |     12     70 |
 43. |     13     60 |
 44. |     13     65 |
 45. |     13     70 |
 50. |     16     60 |
     |---------------|
 51. |     16     65 |
 52. |     16     70 |
 92. |     26     60 |
 93. |     26     65 |
 94. |     26     70 |
     |---------------|
 95. |     26     75 |
114. |     31     65 |
115. |     31     70 |
120. |     33     60 |
121. |     33     65 |
     |---------------|
407. |     83     60 |
408. |     83     65 |
409. |     83     70 |
442. |     88     60 |
491. |     95     60 |
     |---------------|
492. |     95     65 |
493. |     95     70 |
494. |     95     75 |
744. |    141     60 |
     +---------------+

. list shcode year in 1/15

     +---------------+
     | shcode   year |
     |---------------|
  1. |      1     60 |
  2. |      1     65 |
  3. |      1     70 |
  4. |      1     75 |
  5. |      1     80 |
     |---------------|
  6. |      1     85 |
  7. |      1     90 |
  8. |      3     60 |
  9. |      3     65 |
 10. |      3     70 |
     |---------------|
 11. |      3     75 |
 12. |      3     80 |
 13. |      3     85 |
 14. |      3     90 |
 15. |      4     60 |
     +---------------+

. drop syr

. drop if (no==.)
(17 observations deleted)

. gen fail = pri - pric

. sum fail

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
        fail |       775    24.10155    13.69971         .1       67.3

. gen yeardum = .
(775 missing values generated)

. replace yeardum = 1 if (year==60)
(107 real changes made)

. drop yeardum

. gen yeardum = year

. recode yeardum 60=1 65=2 70=3 75=4 80=5 85=6 90=7
(yeardum: 775 changes made)

. list yeardum in 1/15

     +---------+
     | yeardum |
     |---------|
  1. |       1 |
  2. |       2 |
  3. |       3 |
  4. |       4 |
  5. |       5 |
     |---------|
  6. |       6 |
  7. |       7 |
  8. |       3 |
  9. |       4 |
 10. |       5 |
     |---------|
 11. |       6 |
 12. |       7 |
 13. |       1 |
 14. |       2 |
 15. |       3 |
     +---------+