------------------------------------------------------------------------------- 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 pover > ty, 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

. sort race

. by race: tabulate poverty [fweight=wgt2]

_______________________________________________________________________________ -> race = White

_______________________________________________________________________________ -> race = Black

_______________________________________________________________________________ -> race = Amer Indian

_______________________________________________________________________________ -> race = Asian

. sort sex

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

_______________________________________________________________________________ -> sex = male

_______________________________________________________________________________ -> sex = female

. 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)

*Remember that if you were going to follow through with recoding the poverty variable in this way as a numeric variable, you'd have to enter codes for every category. Note that what I'm doing here is attributing the middle value of each range to that entire range . describe

Contains data from :AComp HD (2001-02):Save Stuff Here (Temporary):cps_y2k_nume > ric.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