-------------
       log:  :acomp hd (2001-02):save stuff here (temporary):section2 log.smcl
  log type:  smcl
 opened on:  22 May 2003, 11:26:23

. use ":AComp HD (2001-02):Save Stuff Here (Temporary):cps_y2k_numeric.dta"

. tabulate  povll

   ratio of |
 fam income |
 to poverty |
  level f38 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |       6579        4.92        4.92
          2 |       4534        3.39        8.31
          3 |       5560        4.16       12.47
          4 |       6259        4.68       17.15
          5 |       6727        5.03       22.18
          6 |       6592        4.93       27.11
          7 |       6452        4.83       31.94
          8 |      12507        9.35       41.29
          9 |      11601        8.68       49.97
         10 |       9858        7.37       57.34
         11 |       8967        6.71       64.05
         12 |       7910        5.92       69.96
         13 |       6517        4.87       74.84
         14 |      33647       25.16      100.00
------------+-----------------------------------
      Total |     133710      100.00

.  *there are two things we can do with this poverty variable to make it useful.
. *Easiest thing to do is re-categorize to something like 3 levels: below poverty, 1-2x poverty, and >2x poverty line
. generate poverty=0 if povll<4
(117037 missing values generated)

. replace poverty=1 if povll>3 & povll<8
(26030 real changes made)

. replace poverty=2 if povll>7
(91007 real changes made)

. label define poverty_lbl 0 "poor" 1 "1-2x poverty" 2 ">2x pov level"

. label values poverty poverty_lbl

. tabulate poverty

      poverty |      Freq.     Percent        Cum.
--------------+-----------------------------------
         poor |      16673       12.47       12.47
 1-2x poverty |      26030       19.47       31.94
>2x pov level |      91007       68.06      100.00
--------------+-----------------------------------
        Total |     133710      100.00

. sort race

. by race: tabulate poverty [fweight=wgt2]

_______________________________________________________________________________
-> race = White

      poverty |      Freq.     Percent        Cum.
--------------+-----------------------------------
         poor |   22249869        9.92        9.92
 1-2x poverty |   38570707       17.20       27.12
>2x pov level |  163435693       72.88      100.00
--------------+-----------------------------------
        Total |  224256269      100.00

_______________________________________________________________________________
-> race = Black

      poverty |      Freq.     Percent        Cum.
--------------+-----------------------------------
         poor |    8455601       23.91       23.91
 1-2x poverty |    8505601       24.05       47.95
>2x pov level |   18409355       52.05      100.00
--------------+-----------------------------------
        Total |   35370557      100.00

_______________________________________________________________________________
-> race = Amer Indian

      poverty |      Freq.     Percent        Cum.
--------------+-----------------------------------
         poor |     794060       27.98       27.98
 1-2x poverty |     734447       25.88       53.86
>2x pov level |    1309324       46.14      100.00
--------------+-----------------------------------
        Total |    2837831      100.00

_______________________________________________________________________________
-> race = Asian

      poverty |      Freq.     Percent        Cum.
--------------+-----------------------------------
         poor |    1142061       10.60       10.60
 1-2x poverty |    1804583       16.76       27.36
>2x pov level |    7822520       72.64      100.00
--------------+-----------------------------------
        Total |   10769164      100.00


. sort sex

. by sex: tabulate poverty if age>20 [fweight=wgt2]

_______________________________________________________________________________
-> sex = male

      poverty |      Freq.     Percent        Cum.
--------------+-----------------------------------
         poor |    6735504        7.47        7.47
 1-2x poverty |   13373051       14.83       22.30
>2x pov level |   70080957       77.70      100.00
--------------+-----------------------------------
        Total |   90189512      100.00

_______________________________________________________________________________
-> sex = female

      poverty |      Freq.     Percent        Cum.
--------------+-----------------------------------
         poor |   11116160       11.25       11.25
 1-2x poverty |   18294673       18.51       29.76
>2x pov level |   69404862       70.24      100.00
--------------+-----------------------------------
        Total |   98815695      100.00


. gen poverty_numeric=.25 if povll==1
(127131 missing values generated)

. replace poverty_numeric=.62 if povll==2
(4534 real changes made)

. replace poverty_numeric=.87 if povll==3
(5560 real changes made)

. describe

Contains data from :AComp HD (2001-02):Save Stuff Here (Temporary):cps_y2k_numeric.dta
  obs:       133,710
 vars:            41                          30 May 2001 12:57
 size:    10,563,090 (54.5% of memory free)
-------------------------------------------------------------------------------
              storage  display     value
variable name   type   format      label      variable label
-------------------------------------------------------------------------------
phseq           str5   %9s                    household sequence number p2
pernum          byte   %8.0g
age             byte   %8.0g                  p15
maritl          byte   %26.0g      marlbl     Marital Status p17
sex             byte   %8.0g       sexnm      p20
vet             byte   %22.0g      vetnm      veteran status p21
hga             byte   %8.0g                  Educational Attainment p22
race            byte   %11.0g      racenm     p25
reorigin        byte   %8.0g                  Hispanic Origin p27
hrs1            byte   %8.0g                  hours worked last week p76
clswkr          byte   %32.0g      cwrknm     sector of worker p109
grswk           int    %9.0g                  gross weekly wages p135
unmem           byte   %13.0g      unnm       labor union member p139
lfsr            byte   %28.0g      lfsrnm     labor force status p145
ernval          float  %9.0g                  main job last year earnings p228
ssval           long   %12.0g                 last year soc security payments
                                                p291
pawval          int    %12.0g                 last year welfare payments p305
wgt2            int    %9.0g                  rounded weight based on p50
ernval2         float  %9.0g                  main job earnings, losses
                                                recoded to zero
htype           byte   %37.0g      htpnm      household type h25
state           byte   %8.0g                  HG-ST60, or simply state of
                                                residence h40
hpmsasz         byte   %8.0g                  metropolitan area size h56
hcccr           byte   %8.0g                  residence in central city h58
frelu18         byte   %8.0g                  number of kids in fam under 18
                                                f29
povll           byte   %8.0g                  ratio of fam income to poverty
                                                level f38
fwsval          float  %9.0g                  family income f48
famwgt2         int    %8.0g                  adjusted family weight f233
yrsed           float  %9.0g                  years of education, from hga
citizen         byte   %33.0g      citnm      citizenship p733
health          byte   %11.0g      hlthnm     self reported health status p800
occ             int    %8.0g                  occupation P 106
ptotr           byte   %8.0g                  total person income categories
                                                P466
penatvty        int    %8.0g                  country of birth P 722,
                                                Appendix H
pemntvty        int    %8.0g                  Mother's country of birth,
                                                P725, appendix H
pefntvty        int    %8.0g                  Father's country of birth,
                                                P728, appendix H
peinusyr        byte   %8.0g                  time of immigration, P 731
pxnatvty        byte   %8.0g                  allocation flag for country of
                                                birth P 734
hgmsac          int    %8.0g                  metropolitan area code, h44,
                                                appendix E
pppos2          byte   %8.0g                  family sequence number within
                                                each household p46
poverty         float  %13.0g      poverty_lbl

poverty_numeric float  %9.0g
-------------------------------------------------------------------------------
Sorted by:  sex
     Note:  dataset has changed since last saved

. tabulate  peinusyr

    time of |
immigration |
    , P 731 |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |     116219       86.92       86.92
          1 |        523        0.39       87.31
          2 |        904        0.68       87.99
          3 |        774        0.58       88.56
          4 |        951        0.71       89.28
          5 |       1264        0.95       90.22
          6 |       1543        1.15       91.38
          7 |        996        0.74       92.12
          8 |        667        0.50       92.62
          9 |        954        0.71       93.33
         10 |        885        0.66       93.99
         11 |       1300        0.97       94.97
         12 |       1212        0.91       95.87
         13 |       1210        0.90       96.78
         14 |       1340        1.00       97.78
         15 |       1313        0.98       98.76
         16 |       1655        1.24      100.00
------------+-----------------------------------
      Total |     133710      100.00

. exit, clear