-------------
       log:  /disk/nber10/SCCS/mare_winship/cpsmw92.smcl
  log type:  smcl
 opened on:   6 Jun 2005, 16:50:11

. set mem 500m
(512000k)

. *by Jean Roth Wed Mar 28 10:38:40 EST 2001
. *Please report errors to jroth@nber.org
. *Change output file name/location as desired
.
. *run by opening stata, set mem 50m,
.
. clear

. quietly infile using cpsmw89_92

.
.
. *All the rest are labels
.
. #delimit ;
delimiter now ;
. ;
. label values hhidnum  P1L;

.     label define P1L
>         9           "invalid code"
> ;

. label values randomc  P2L;

.     label define P2L
>         99999       "bad code"
> ;

. label values keyfitz  P3L;

.     label define P3L
>         999         "bad code"
> ;

. label values nonint   P4L;

.     label define P4L
>         99          "bad code"
> ;

. label values famdesc  P5L;

.     label define P5L
>         1           "primary fam containing no subfams"
>         2           "primary fam with 1 or more subfams"
>         3           "secondary family"
>         4           "subfamily"
>         5           "primary individual"
>         6           "sec. indiv., 14+, in a hh"
>         7           "sec. indiv., 14+, in group quarters"
>         8           "sec. indiv., under 14, in a hh"
>         9           "sec. indiv., under 14, in group quart"
> ;

. label values famposi  P6L;

.     label define P6L
>         0           "NIU"
> ;

. label values famtypc  P7L;

.     label define P7L
>         1           "yes"
>         2           "no"
> ;

. label values kindfam  P8L;

.     label define P8L
>         1           "primary family"
>         2           "primary individual"
>         3           "subfamily"
>         4           "secondary family"
>         5           "secondary individuals"
> ;

. label values numpfam  P9L;

.     label define P9L
>         7           "7+ [1964-67 only]"
> ;

. label values totfami  P10L;

.    label define P10L
>         50000       "$50000 or more [1968-75]"
> ;

. label values censusg  P11L;

.    label define P11L
>         1           "New England"
>         2           "Middle Atlantic"
>         3           "East North Central"
>         4           "West North Central"
>         5           "South Atlantic"
>         6           "East South Central"
>         7           "West South Central"
>         8           "Mountain"
>         9           "Pacific"
>         99          "missing data"
> ;

. label values central  P12L;

.    label define P12L
>         1           "central city"
>         2           "balance of SMSA"
>         3           "not in SMSA"
>         4           "not identifiable [1977+ only]"
> ;

. label values hhtype   P13L;

.    label define P13L
>         0           "group quarter"
>         1           "primary family"
>         2           "primary individual living alone"
>         3           "primary individual living with norelatives"
> ;

. label values hhstatu  P14L;

.    label define P14L
>         0           "not in universe (group quarter)"
>         1           "primary family"
>         2           "primary individual (alone)"
>         3           "primary indiv. (living with nonrelatives"
> ;

. label values numphh   P15L;

.    label define P15L
>         99          "secondary individuals"
> ;

. label values region   P16L;

.    label define P16L
>         1           "Northeast"
>         2           "North Central"
>         3           "South"
>         4           "West"
>         9           "missing [1964]"
> ;

. label values smsa1    P17L;

.    label define P17L
>         0           "not listed below"
>         1           "New York City"
>         2           "Los Angeles"
>         3           "Chicago"
>         4           "Philadelphia"
>         5           "Detroit"
>         6           "San Francisco"
>         7           "Boston"
>         8           "Pittsburgh"
>         9           "St. Louis"
>         10          "Washington, D. C."
>         11          "Cleveland"
>         12          "Baltimore"
>         13          "Newark [1968+ only]"
>         14          "Minneapolis - St. Paul"
>         15          "Buffalo"
>         16          "Houston"
>         17          "Milwaukee [1968+]"
>         18          "Patterson - Clifton - Passaic [1968+"
>         19          "Dallas [1968+]"
> ;

. label values smsasta  P18L;

.    label define P18L
>         1           "SMSA"
>         2           "NONSMSA"
>         3           "not identifiable [1977+ only]"
> ;

. label values state1   P19L;

.    label define P19L
>         0           "invalid code [1964-67, 1972]"
>         16          "Connecticut"
>         19          "ME, MA, NH, RI, VT"
>         21          "New York"
>         22          "New Jersey"
>         23          "Pennsylvania"
>         31          "Ohio"
>         32          "Indiana"
>         33          "Illinois"
>         39          "Michigan, Wisconsin"
>         49          "IA, KS, MN, MO, NE, ND, SD"
>         53          "Washington, D. C."
>         57          "DE, MD, WV, VA"
>         58          "Georgia, NC, SC"
>         59          "Florida"
>         67          "Kentucky, Tennessee"
>         69          "Alabama, Mississippi"
>         72          "Texas"
>         79          "Arkansas, Louisiana, Oklahoma"
>         89          "AZ, CO, ID, MT, NV, NM, UT, WY"
>         92          "California"
>         99          "Alaska, Hawaii, Oregon, Washington"
> ;

. label values tothhin  P20L;

.    label define P20L
>         50000       "$50000 or more [1968-75]"
> ;

. label values adc      P21L;

.    label define P21L
>         0           "not in universe"
>         1           "AFDC (ADC)"
>         2           "Other"
>         9           "AFDC & Other"
> ;

. label values age      P22L;

.    label define P22L
>         999         "invalid code [1968-69 only]"
> ;

. label values alimony  P23L;

.    label define P23L
>         0           "not in universe"
>         1           "yes"
>         2           "no"
> ;

. label values anyreas  P24L;

.    label define P24L
>         0           "not in universe"
>         1           "yes"
>         2           "no"
> ;

. label values cowcurj  P25L;

.    label define P25L
>         0           "NIU, NC"
>         1           "private"
>         2           "federal government"
>         3           "state government"
>         4           "local government"
>         5           "self-employed, inc."
>         6           "self-employed, not inc."
>         7           "without pay"
>         8           "never worked or never worked full"
> ;

. label values complet  P26L;

.    label define P26L
>         0           "not in universe"
>         1           "yes"
>         2           "no"
>         9           "invalid code"
> ;

. label values curindu  P27L;

.    label define P27L
>         998         "invalid code"
>         999         "NIU [1968-70]"
>         0           "NIU [1971+]"
> ;

. label values curoccu  P28L;

.    label define P28L
>         0           "NIU"
> ;

. label values didntwo  P29L;

.    label define P29L
>         0           "NIU/did work"
>         1           "did not work"
> ;

. label values employm  P30L;

.    label define P30L
>         0           "NIU"
>         1           "working                employed"
>         2           "with job, not at work  employed"
>         3           "looking                unemployed"
>         4           "layoff, unemployed"
>         5           "working w/out pay <= 15 hours; temp abs; NILF"
>         6           "unavailable NILF"
>         7           "other (retired)        NILF"
> ;

. label values famseco  P31L;

.    label define P31L
>         1           "member secondary family no. 1"
>         2           "member secondary family no. 2"
>         3           "member secondary family no. 3"
>         4           "member secondary family no. 4"
>         5           "member secondary family no. 5"
>         6           "member secondary family no. 6"
>         7           "member of primary family or"
>         8           "primary or secondary individual"
> ;

. label values famnum   P32L;

.    label define P32L
>         0           "not in sub/secondary family"
> ;

. label values famreln  P33L;

.    label define P33L
>         0           "not in sub/secondary family"
>         1           "head (sub/secondary family)"
>         2           "wife (sub/secondary family)"
>         3           "child (sub/secondary family)"
>         4           "other relative (secondary family)"
> ;

. label values famtyp   P34L;

.    label define P34L
>         1           "primary family"
>         2           "primary individual"
>         3           "subfamily member"
>         4           "secondary family member"
>         5           "secondary individual"
> ;

. label values farmsel  P35L;

.    label define P35L
>         50000       "$50000 or more [1968-75]"
> ;

. label values fptfpar  P36L;

.    label define P36L
>         0           "NIU"
>         1           "full-time (full year worker)"
>         2           "part-time (full year worker)"
>         3           "full-time (part year worker)"
>         4           "part-time (part year worker)"
>         5           "nonworker"
>         9           "invalid data"
> ;

. label values fptwork  P37L;

.    label define P37L
>         0           "children or armed forces"
>         1           "NIU, not in labor force"
>         2           "employed full time"
>         3           "part-time for economic reasons (usu. ft)"
>         4           "part-time for noneconomic reasons (usu. pt)"
>         5           "part-time for economic reasons (usu. pt)"
>         6           "unemployed full-time"
>         7           "unemployed part-time [1968+ only]"
> ;

. label values hourswo  P39L;

.    label define P39L
>         0           "NIU"
> ;

. label values hhr1     P40L;

.    label define P40L
>         1           "head of primary family"
>         2           "wife of primary family head"
>         3           "child, under 18, head of subfamily"
>         4           "child, under 18, not in a subfamily"
>         5           "child, under 18, ever-married,"
>         6           "child, under 18, ever-married,"
>         7           "child, under 18, ever-married,"
>         8           "18+, never-married, head of subfamil"
>         9           "18+, never-married, not in a subfami"
>         10          "18+, ever-married, head of a subfami"
>         11          "18+, ever-married, wife of a subfami"
>         12          "18+, ever-married, not in a subfamil"
>         13          "grandchild, under 18, never-married"
>         14          "other relative, under 18, head of"
>         15          "other relative, under 18, NM, child"
>         16          "other relative, under 18, not in"
>         17          "other relative, under 18, ever-marri"
>         18          "other relative, under 18, ever-marri"
>         19          "other relative, under 18, ever-marri"
>         20          "other relative, 18+, never-married,"
>         21          "other relative, 18+, never-married,"
>         22          "other relative, 18+, ever-married,"
>         23          "other relative, 18+, ever-married,"
>         24          "other relative, 18+, ever-married,"
>         25          "in secondary family, head of"
>         26          "in secondary family, wife of"
>         27          "head, child under 18, never-married,"
>         28          "under 18, never-married, other"
>         29          "under 18, ever-married, other"
>         30          "18+, never-married, secondary family"
>         31          "18+, ever-married, other relative"
>         32          "primary individual"
>         33          "secondary individual"
>         34          "group quarters, secondary individual"
> ;

. label values hhr2     P41L;

.    label define P41L
>         1           "head of household"
>         2           "wife of head of household"
>         3           "child of head, under 18,"
>         4           "child of head, under 18,"
>         5           "child of head, 18+"
>         6           "other relative of head"
>         7           "nonrelative of head"
>         8           "secondary individuals/group quarters"
> ;

. label values hhr3     P42L;

.    label define P42L
>         1           "head of family"
>         2           "wife of head"
>         3           "under 18, single, never married,"
>         4           "under 18, ever-married, child"
>         5           "18+, child of family head"
>         6           "grandchild of head [1968+ only]"
>         7           "under 18, single, never-married,"
>         8           "under 18, ever-married, other relati"
>         9           "18+, other relative"
>         10          "primary individual"
>         11          "secondary individual"
> ;

. label values lwft2pc  P43L;

.    label define P43L
>         0           "NIU"
>         1           "within past 12 months"
>         2           "more than 5 years ago"
>         3           "1-5 years"
>         4           "never worked full time 2+ weeks"
>         5           "never worked at all"
> ;

. label values lwftpay  P44L;

.    label define P44L
>         0           "NIU"
>         1           "within past 12 months"
>         2           "1-2 years ago"
>         3           "2-3 years ago"
>         4           "3-4 years ago"
>         5           "4-5 years ago"
>         6           "5+ years ago"
>         7           "never worked"
>         9           "invalid code"
> ;

. label values lfworkl  P45L;

.    label define P45L
>         0           "NIU"
>         1           "yes"
>         2           "no"
>         9           "invalid code [1968 only]"
> ;

. label values lffptwo  P46L;

.    label define P46L
>         0           "NIU"
>         1           "full time"
>         2           "part time"
> ;

. label values lolayed  P47L;

.    label define P47L
>         0           "NIU/looking or layed off last year"
>         1           "not looking or layed off"
>         9           "invalid code [1968 only]"
> ;

. label values majacti  P48L;

.    label define P48L
>         0           "NIU"
>         1           "working"
>         2           "with a job but not at work"
>         3           "looking for work"
>         4           "keeping house"
>         5           "at school"
>         6           "unable to work"
>         7           "other/retired"
> ;

. label values marital  P49L;

.    label define P49L
>         1           "married, spouse present"
>         2           "married, AF spouse absent"
>         3           "married, spouse absent"
>         4           "widowed"
>         5           "divorced"
>         6           "separated"
>         7           "never married (includes under 14)"
> ;

. label values nonfarm  P50L;

.    label define P50L
>         50000       "$50000 or more [1968-75]"
> ;

. label values nftjob   P51L;

.    label define P51L
>         0           "NIU"
>         1           "yes"
>         2           "no"
> ;

. label values nftwork  P52L;

.    label define P52L
>         0           "NIU"
>         1           "yes"
>         2           "no"
> ;

. label values paidtim  P53L;

.    label define P53L
>         0           "NIU"
>         1           "yes"
>         2           "no"
>         3           "self-employed"
> ;

. label values parents  P54L;

.    label define P54L
>         0           "NIU"
>         1           "both"
>         2           "mother only"
>         3           "father only"
>         4           "neither"
> ;

. label values persequ  P55L;

.    label define P55L
>         99          "invalid code"
> ;

. label values ptincom  P56L;

.    label define P56L
>         50000       "50000+ [1968-75 only]"
> ;

. label values populat  P57L;

.    label define P57L
>         1           "civilians 14+ [15+ in 1981]"
>         2           "armed forces"
>         3           "children [1968+ only]"
> ;

. label values paamoun  P58L;

.    label define P58L
>         0           "NIU/none [1976+]"
>         50000       "50000+ [1968-75 only]"
> ;

. label values parecip  P59L;

.    label define P59L
>         0           "NIU"
>         1           "yes"
>         2           "no"
>         9           "bad data"
> ;

. label values race     P60L;

.    label define P60L
>         1           "white"
>         2           "black"
>         3           "Amer Indian, Aleut Eskimo"
>         4           "Asian/Pacific Islander"
>         5           "other"
> ;

. label values rnawlwk  P61L;

.    label define P61L
>         0           "NIU"
>         1           "temporary illness -- U1"
>         2           "vacation"
>         3           "bad weather"
>         4           "labor dispute"
>         5           "new job within 30 days, NILF"
>         6           "temp layoff (<30 days), NILF"
>         7           "perm layoff (30+ days), NILF"
>         8           "other             -- U2"
>         9           "invalid"
> ;

. label values rnawlyr  P62L;

.    label define P62L
>         0           "armed forces or NIU"
>         1           "ill"
>         2           "retired [1968+ only]"
>         3           "home [females only]"
>         4           "school"
>         5           "unable to find work"
>         6           "other"
> ;

. label values relnhhh  P63L;

.    label define P63L
>         1           "head with other relatives"
>         2           "primary individual"
>         3           "husband"
>         4           "wife"
>         5           "child natural/adopted"
>         6           "stepchild of head"
>         7           "grandchild of head"
>         8           "parent of head"
>         9           "brotheer/sister of head"
> ;

. label values sex      P64L;

.    label define P64L
>         1           "male"
>         2           "female"
> ;

. label values subfam   P65L;

.    label define P65L
>         0           "NIU"
>         1           "member subfamily no. 1"
>         2           "member subfamily no. 2"
>         3           "member subfamily no. 3"
>         4           "member subfamily no. 4"
>         5           "member subfamily no. 5"
>         6           "member subfamily no. 6"
>         9           "invalid code"
> ;

. label values unemplo  P66L;

.    label define P66L
>         0           "NIU"
>         1           "yes"
>         2           "no"
> ;

. label values veteran  P67L;

.    label define P67L
>         1           "Vietnam Era"
>         2           "Korean War"
>         3           "World War II"
>         4           "World War I"
>         5           "other service"
>         6           "nonveteran"
>         0           "NIU"
> ;

. label values perswag  P68L;

.    label define P68L
>         0           "NIU/none [1976+]"
>         50000       "50000 or more [1968-75]"
> ;

. label values wkunemp  P69L;

.    label define P69L
>         0           "NIU"
> ;

. label values wlly1    P70L;

.    label define P70L
>         0           "NIU"
>         1           "none (not looking)"
>         2           "1-4 weeks looking"
>         3           "5-14 weeks looking"
>         4           "15-26 weeks looking"
>         5           "27-39 weeks looking"
>         6           "40+ weeks looking"
>         7           "workers"
> ;

. label values wlly2    P71L;

.    label define P71L
>         1           "none (not looking)"
>         2           "1-4 weeks looking"
>         3           "5-14 weeks looking"
>         4           "15-26 weeks looking"
>         5           "27-39 weeks looking"
>         6           "40+ weeks looking"
>         7           "workers"
>         0           "NIU"
> ;

. label values wllyr1   P72L;

.    label define P72L
>         0           "NIU"
> ;

. label values wllyr2   P73L;

.    label define P73L
>         0           "NIU"
>         1           "none"
>         2           "1-4 weeks"
>         3           "5-10 weeks"
>         4           "11-14 weeks"
>         5           "15-26 weeks"
>         6           "27-39 weeks [1964-67 = 27+ weeks]"
>         7           "40+ weeks [1968+ only]"
>         8           "full year worker [1976-1992 only]"
>         9           "nonworker [1976-1992 only]"
> ;

. label values wwly1    P74L;

.    label define P74L
>         0           "NIU"
> ;

. label values wwly2    P75L;

.    label define P75L
>         0           "NIU"
>         1           "0"
> ;

. label values whyless  P76L;

.    label define P76L
>         0           "NIU"
>         1           "slack"
>         2           "material shortage"
>         3           "plant or machine repair"
>         4           "new job started during week"
>         5           "job terminated during week"
>         6           "could find only part time work"
>         7           "holiday"
>         8           "labor dispute"
>         9           "bad weather"
>         10          "own illness"
>         11          "on vacation"
>         12          "too busy with house, school, etc."
>         13          "did not want full time work"
>         14          "full time work week less than 35 hrs"
>         15          "other"
> ;

. label values whylfwo  P77L;

.    label define P77L
>         0           "NIU"
>         1           "lost job"
>         2           "quit job"
>         3           "left school"
>         4           "wanted temporary work"
>         5           "change in home/family"
>         6           "left military service"
>         7           "other"
> ;

. label values whynota  P78L;

.    label define P78L
>         0           "NIU"
>         1           "own illness"
>         2           "on vacation               ESR=2"
>         3           "bad weather               ESR=2"
>         4           "labor dispute             ESR=2"
>         5           "new job begin 30 days     ESR=3"
>         6           "temporary layoff          ESR=3"
>         7           "indefinite layoff         ESR=3"
>         8           "other                     ESR=2"
>         9           "invalid code"
> ;

. label values povcuto  P79L;

.    label define P79L
>         0           "NIU [1976+]"
>         1           "below poverty cutoff amount"
>         2           "100-124% of the low-income level"
>         3           "125-149% of the low-income level"
>         4           "150% and above the low-income level"
> ;

. label values povlev   P80L;

.    label define P80L
>         0           "NIU [1968-75 only]"
>         1           "below poverty cutoff amount"
>         2           "100-124% of the low-income level"
>         3           "125-149% of the low-income level"
>         4           "150% and above the low-income level"
> ;

. label values cowlast  P81L;

.    label define P81L
>         0           "NIU"
>         1           "private wage or salary"
>         2           "government"
>         3           "self-employed"
>         4           "w/o pay in family farm or business"
> ;

. label values spanish  P82L;

.    label define P82L
>         1           "Mexican American"
>         2           "Chicano"
>         3           "Mexicano"
>         4           "Puerto Rican"
>         5           "Cuban"
>         6           "Central or South American"
>         7           "other Spanish"
>         8           "other"
>         9           "don't know"
>         0           "not available"
> ;

. label values mainrea  P83L;

.    label define P83L
>         0           "NIU"
>         1           "ill"
>         2           "home/family"
>         3           "school"
>         4           "armed forces [1968-1983]"
>         5           "retired"
>         6           "other [1968-1983]"
>         7           "other [1984]"
> ;

. label values stretch  P84L;

.    label define P84L
>         0           "NIU"
>         1           "1 stretch last year"
>         2           "2 stretches last year"
>         3           "3+ stretches last year"
> ;

. label values wkslabo  P85L;

.    label define P85L
>         0           "NIU"
>         1           "1-13 weeks"
>         2           "14-26 weeks"
>         3           "27-39 weeks"
>         4           "40-47 weeks"
>         5           "48-49 weeks"
>         6           "50-52 weeks"
>         9           "invalid code [1968 only]"
> ;

. label values famawgt  P86L;

.    label define P86L
>         99999       "invalid code"
> ;

. label values perawgt  P87L;

.    label define P87L
>         99999       "invalid code"
> ;

. label values typeain  P88L;

.    label define P88L
>         0           "NIU/none [1976+]"
>         50000       "$50000+ [1968-1975]"
> ;

. label values dividen  P89L;

.    label define P89L
>         0           "NIU/none [1976+]"
> ;

. label values presenc  P90L;

.    label define P90L
>         0           "none"
>         1           "under 3 only"
>         2           "3-5"
>         3           "under 3 and 3-5 only"
>         4           "6-11 only"
>         5           "under 3, 6-11 only"
>         6           "3-5 and 6-11 only"
>         7           "under 3, 3-5 and 6-11 only"
>         8           "12-17 only"
>         9           "under 3 and 12-17 only"
>         10          "3-15 and 12-17 only"
>         11          "under 3, 3-5 and 12-17 only"
>         12          "6-11 and 12-17 only"
>         13          "under 3, 6-11 and 12-17 only"
>         14          "3-5, 6-11 and 12-17 only"
>         15          "under 3, 3-5, 6-11 and 12-17"
> ;

. label values famo18   P91L;

.    label define P91L
>         0           "0"
>         1           "all 18-24, single"
>         2           "some 18-24, single and other"
>         3           "none 18-24, single and other"
> ;

. label values femalef  P92L;

.    label define P92L
>         0           "none"
>         1           "all in labor force"
>         2           "1+ (not all) in labor force"
> ;

. label values laborfo  P93L;

.    label define P93L
>         0           "1+ employed"
>         1           "1+ unemployed, none employed"
>         2           "none in labor force"
>         3           "no other members 14+"
> ;

. label values hhflag   P94L;

.    label define P94L
>         1           "hh starts with primary family or indi"
>         2           "hh starts with a subfamily family"
>         3           "hh starts with a secondary family"
>         4           "hh starts with a secondary individual"
>         5           "hh starts with a person rec. w/new ID"
>         9           "unusable value of family-type"
> ;

. label values msa  msa;

.    label define msa
>         80          "Akron, OH, PMSA"
>         160         "Albany-Schenectady-Troy, NY MSA"
>         200         "Albuquerque, NM MSA"
>         240         "Allentown-Bethlehem, PA-NJ MSA"
>         280         "Altoona, PA MSA"
>         360         "Anaheim-Santa Ana, CA PMSA"
>         380         "Anchorage, AK MSA"
>         400         "Anderson, IN MSA"
>         405         "Anderson, SC MSA"
>         440         "Ann Arbor, MI PMSA"
>         460         "Appleton-Oshkosh-Neenaht, WI MSA"
>         480         "Asheville, NC MSA"
>         520         "Atlanta, GA MSA"
>         600         "Augusta, GA-SC MSA"
>         620         "Aurora-Elgin, IL PMSA"
>         640         "Austin, TX MSA"
>         680         "Bakersfield, CA MSA"
>         720         "Baltimore, MD MSA"
>         760         "Baton Rouge, LA MSA"
>         780         "Battle Creek, MI MSA"
>         840         "Beaumont-Port Arthur, FL MSA"
>         845         "Beaver County, PA PMSA"
>         860         "Bellingham, WA MSA"
>         870         "Benton Harbor, MI MSA"
>         875         "Bergen-Passaic, NJ PMSA"
>         920         "Biloxi-Gulfport, MS MSA"
>         960         "Binghamton, NY MSA"
>         1000        "Birmingham, AL MSA"
>         1040        "Bloomington-Normal, IL MSA"
>         1080        "Boise City, ID MSA"
>         1120        "Boston, MA PMSR"
>         1125        "Boulder-Longmont, CO PMSA"
>         1140        "Bradenton, FL MSA"
>         1145        "Brazoria, TX PMSA"
>         1160        "Bridgeport-Milford, CT PMSA"
>         1200        "Brockton, MA PMSA"
>         1240        "Brownsville-Harlingen, TX MSA"
>         1280        "Buffalo, NY PMSA"
>         1305        "Burlington, VT MSA"
>         1320        "Canton, OH MSA"
>         1360        "Cedar Rapids, IA MSA"
>         1400        "Champaign-Urbana-Rantoul, IL MSA"
>         1440        "Charleston, SC MSA"
>         1480        "Charleston, WV MSA"
>         1520        "Charlotte-Gastonia-Rock Hill, NC-SC MSA"
>         1560        "Chattanooga, TN-A MSA"
>         1600        "Chicago, IL PMSA"
>         1620        "Chico, CA MSA"
>         1640        "Cincinnati, OH-KY-IN PMSA"
>         1680        "Cleveland, OH PMSA"
>         1720        "Colorado Springs, CO MSA"
>         1740        "Colombia, MO MSA"
>         1760        "Columbia, SC MSA"
>         1800        "Columbus, GA-AL MSA"
>         1840        "Columbus, OH MSA"
>         1880        "Corpus Christi, TX MSA"
>         1920        "Dallas, TX PMSA"
>         1930        "Danbury, CT PMSR"
>         1960        "Davenport-Rock Island-Moline, IA-IL MSA"
>         2000        "Dayton-Springfield, OH MSA"
>         2020        "Daytona Beach, FL MSA"
>         2080        "Denver, CO PMSA"
>         2120        "Des Moines, IA MSA"
>         2160        "Detroit, MI PMSA"
>         2240        "Duluth, MN-WI MSA"
>         2320        "El Paso, TX MSA"
>         2360        "Erie, PA MSA"
>         2400        "Eugene-Springfield, OR MSA"
>         2440        "Evansville, IN-KY MSA"
>         2560        "Fayetteville, NC MSA"
>         2580        "Fayetteville-Springdale, AR MSA"
>         2640        "Flint, MI MSA"
>         2650        "Florence, AL MSA"
>         2655        "Florence, SC MSA"
>         2670        "Fort Collins-Loveland, CO MSA"
>         2680        "Fort Lauderdale-Hollywood-Pompano Beach, FL PMSA"
>         2700        "Fort Myers, FL MSA"
>         2720        "Fort Smith, AR-OK MSA"
>         2750        "Fort Walton Beach, FL MSA"
>         2760        "Fort Wayne, IN MSA"
>         2800        "Fort Worth-Arlington, TX PMSA"
>         2840        "Fresno, CA MSA"
>         2880        "Gadsden, AL MSA"
>         2900        "Gainesville, FL MSA"
>         2920        "Galveston-Texas City, TX PMSA"
>         2960        "Gary-Hammond, IN PMSA"
>         3000        "Grand Rapids, MI MSA"
>         3120        "Greenboro-Winston Salem-High Point, NC MSA"
>         3160        "Greenville-Spartanburg, SC MSA"
>         3200        "Hamilton-Middletown, OH PMSA"
>         3240        "Harrisburg-Lebanon-Carlisle, PA MSA"
>         3280        "Hartford, CT PMSA"
>         3290        "Hickory, NC MSA"
>         3320        "Honolulu, HI MSA"
>         3350        "Houma-Thibodaux, LA MSA"
>         3360        "Houston, TX PMSA"
>         3400        "Huntington-Ashland, WV-KY-OH MSA"
>         3440        "Huntsville, AL MSA"
>         3480        "Indianapolis, IN MSA"
>         3520        "Jackson, MI MSA"
>         3560        "Jackson, MS MSA"
>         3600        "Jacksonville, FL MSA"
>         3640        "Jersey City, NJ PMSA"
>         3660        "Johnson City-Kingsport-Bristol, TN-VA MSA"
>         3680        "Johnstown, PA MSA"
>         3690        "Joliet, IL PMSA"
>         3710        "Joplin, MO MSA"
>         3720        "Kalamazoo, MI MSA"
>         3740        "Kankakee, IL MSA"
>         3760        "Kansas City, MO-KS MSA"
>         3810        "Killeen-Temple, TX MSA"
>         3840        "Knoxville, TN MSA"
>         3880        "Lafayette, LA MSA"
>         3960        "Lake Charles, LA MSA"
>         3965        "Lake County, IL PMSA"
>         3980        "Lakeland-Winter Haven, FL MSA"
>         4000        "Lancaster, PA MSA"
>         4040        "Lansing-East Lansing, MI MSA"
>         4120        "Las Vegas, NV MSA"
>         4160        "Lawrence-Haverhill, MA-NH PMSA"
>         4200        "Lawton, OK MSA"
>         4280        "Lexington-Fayette, KY MSA"
>         4320        "Lima, OH MSA"
>         4360        "Lincoln, NE MSA"
>         4400        "Little Rock-North Little Rock, AR MSA"
>         4440        "Lorain-Elyria, OH PMSA"
>         4480        "Los Angeles-Long Beach, CA PMSA"
>         4520        "Louisville, KY-IN MSA"
>         4560        "Lowell, MA-NH PMSA"
>         4600        "Lubbock, TX MSA"
>         4680        "Macon-Warner Robins, GA MSA"
>         4720        "Madison, WI MSA"
>         4760        "Manchester, NH MSA"
>         4800        "Mansfield, OH MSA"
>         4880        "McAllen-Edinburg-Mission, TX MSA"
>         4890        "Medford, OR MSA"
>         4900        "Melbourne-Titusville-Palm Bay, FL MSA"
>         4920        "Memphis, TN-AR-MS MSA"
>         5000        "Miami-Hialeah, FL PMSA"
>         5015        "Middlesex-Somerset-Hunterdon, NJ PMSA"
>         5080        "Milwaukee, WI PMSA"
>         5120        "Minneapolis-St, Paul, MN-WI MSA"
>         5160        "Mobile, AL MSA"
>         5170        "Modesto, CA MSA"
>         5190        "Monmouth-Ocean, NJ PMSA"
>         5200        "Monroe, LA MSA"
>         5240        "Montgomery, AL MSA"
>         5320        "Muskegon, MI MSA"
>         5360        "Nashville, TN MSA"
>         5380        "Nassau-Suffolk, NY PMSA"
>         5400        "New Bedford, MA MSA"
>         5440        "New Britain, CT PMSA"
>         5480        "New Haven-Meriden, CT MSA"
>         5520        "New London-Norwich, CT-RI MSA"
>         5560        "New Orleans, LA MSA"
>         5600        "New York, NY PMSA"
>         5640        "Newark, NJ PMSA"
>         5700        "Niagara Falls, NY PMSA"
>         5720        "Norfolk-Virginia Beach-Newport News, VA MSA"
>         5760        "Norwalk, CT PMSA"
>         5775        "Oakland, CA PMSA"
>         5790        "Ocala, FL MSA"
>         5880        "Oklahoma City, OK MSA"
>         5910        "Olympia, WA MSA"
>         5920        "Omaha, NE-IA MSA"
>         5950        "Orange County, NY PMSA"
>         5960        "Orlando, FL MSA"
>         6000        "Oxnard-Ventura, CA PMSA"
>         6060        "Pawtucket-Woonsocket-Attleboro, RI-MA PMSA"
>         6080        "Pensacola, FL MSA"
>         6120        "Peoria, IL MSA"
>         6160        "Philadelphia, PA-NJ PMSA"
>         6200        "Phoenix, AZ MSA"
>         6280        "Pittsburgh, PA PMSA"
>         6400        "Portland, ME MSA"
>         6440        "Portland, OR PMSA"
>         6450        "Portsmouth-Dover-Rochester, NH-ME MSA"
>         6460        "Poughkeepsie, NY MSA"
>         6480        "Providence, RI PMSA"
>         6520        "Provo-Orem, UT MSA"
>         6560        "Pueblo, CO MSA"
>         6600        "Racine, WI PMSA"
>         6640        "Raleigh-Durham, NC MSA"
>         6680        "Reading, PA MSA"
>         6720        "Reno, NV MSA"
>         6760        "Richmond-Petersburg, VA MSA"
>         6780        "Riverside-San Bernardino, CA PMSA"
>         6800        "Roanoke, VA MSA"
>         6840        "Rochester, NY MSA"
>         6880        "Rockford, IL MSA"
>         6920        "Sacramento, CA MSA"
>         6960        "Saginaw-Bay City-Midland, MI MSA"
>         7040        "St. Louis, MO-IL PMSA"
>         7080        "Salem, OR MSA"
>         7090        "Salem-Gloucester, MA PMSA"
>         7120        "Salinas-Seaside-Monterey, CA MSA"
>         7160        "Salt Lake City-Ogden, UT MSA"
>         7240        "San Antonio, TX MSA"
>         7320        "San Diego, CA MSA"
>         7360        "San Francisco, CA PMSA"
>         7400        "San Jose, CA PMSA"
>         7480        "Santa Barbara-Santa Maria-Lompoc, CA MSA"
>         7485        "Santa Cruz, CA PMSA"
>         7500        "Santa Rosa-Petaluma, CA PMSA"
>         7510        "Sarasota, FL MSA"
>         7520        "Savannah, GA MSA"
>         7560        "Scranton-Wilkes Barre, PA MSA"
>         7600        "Seattle, WA PMSA"
>         7610        "Sharon, PA MSA"
>         7680        "Shreveport, LA MSA"
>         7720        "Sioux City, IA-NE MSA"
>         7760        "Sioux Falls, SD MSA"
>         7800        "South Bend-Mishawaka, IN MSA"
>         7840        "Spokane, WA MSA"
>         7880        "Springfield, IL MSA"
>         7920        "Springfield, MO MSA"
>         8000        "Springfield, MA MSA"
>         8040        "Stamford, CT PMSA"
>         8120        "Stockton, CA MSA"
>         8160        "Syracuse, NY MSA"
>         8200        "Tacoma, WA PMSA"
>         8240        "Tallahassee, FL MSA"
>         8280        "Tampa-St, Petersburg-Clearwater, FL MSA"
>         8320        "Terre Haute, IN MSA"
>         8400        "Toledo, OH MSA"
>         8440        "Topeka, KS MSA"
>         8480        "Trenton, NJ PMSA"
>         8520        "Tucson, AZ MSA"
>         8560        "Tulsa, OK MSA"
>         8600        "Tuscaloosa, AL MSA"
>         8680        "Utica-Rome, NY MSA"
>         8720        "Vallejo-Fairfield-Napa, CA PMSA"
>         8725        "Vancouver, WA PMSA"
>         8780        "Visalia-Tulare-Porterville, CA MSA"
>         8800        "Waco, TX MSA"
>         8840        "Washington, DC-MD-VA MSA"
>         8880        "Waterbury, CT MSA"
>         8920        "Waterloo-Cedar Falls, IA MSA"
>         8960        "West Palm Beach-Boca Raton-Delray Beach, FL MSA"
>         9000        "Wheeling, WV-OH MSA"
>         9040        "Wichita, KS MSA"
>         9140        "Williamsport, PA MSA"
>         9160        "Wilmington, DE-NJ-MD PMSA"
>         9240        "Worcester, MA MSA"
>         9280        "York, PA MSA"
>         9320        "Youngstown-Warren, OH MSA"
>         9340        "Yuba City, CA MSA"
> ;

.
end of do-file

. sum *msa*

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
        smsa |    155980           0           0          0          0
       smsa1 |    155980           0           0          0          0
     smsasta |    155980    1.285004    .4874851          1          3
         msa |    155980    3058.895    2953.951          0       9340
     msarank |    155980     29.6022    49.05975          0        252
-------------+--------------------------------------------------------
    pmsarank |    155980    .5854981    1.197254          0         12

. tab msa

                         MSA 88-on only |      Freq.     Percent        Cum.
----------------------------------------+-----------------------------------
                                      0 |     48,877       31.34       31.34
                        Akron, OH, PMSA |        370        0.24       31.57
        Albany-Schenectady-Troy, NY MSA |        495        0.32       31.89
                    Albuquerque, NM MSA |        789        0.51       32.40
         Allentown-Bethlehem, PA-NJ MSA |        365        0.23       32.63
                        Altoona, PA MSA |         64        0.04       32.67
             Anaheim-Santa Ana, CA PMSA |        941        0.60       33.27
                      Anchorage, AK MSA |      1,140        0.73       34.01
                       Anderson, IN MSA |         93        0.06       34.06
                       Anderson, SC MSA |        116        0.07       34.14
                     Ann Arbor, MI PMSA |        131        0.08       34.22
       Appleton-Oshkosh-Neenaht, WI MSA |        132        0.08       34.31
                      Asheville, NC MSA |        161        0.10       34.41
                        Atlanta, GA MSA |        835        0.54       34.95
                     Augusta, GA-SC MSA |        165        0.11       35.05
                  Aurora-Elgin, IL PMSA |        191        0.12       35.17
                         Austin, TX MSA |        336        0.22       35.39
                    Bakersfield, CA MSA |        226        0.14       35.53
                      Baltimore, MD MSA |      1,026        0.66       36.19
--Break--
r(1);

. list in 1/1

     +----------+---------+---------+-------+----------+----------+-----------+
  1. | hhcount  | famhh1  | perfam  | year  | hhidnum  | hhmonth  |  randomc  |
     |       2  |      1  |      1  |   98  |       1  |       2  |        0  |
     +----------++--------+-+-------+---+---+-------+--+---------++-----------+
     |  keyfitz  |  nonint  |  famsnum  |  famdesc  |  famposi   |  famtypc   |
     |        0  |       0  |        1  |        0  |        1   |        0   |
     +-----------+---------++---------+-+---------+-+---------+--+------------+
     |            kindfam  | numpfam  |  totfami  |  typefam  |      censusg  |
     | primary individual  |       0  |     3052  |        3  |  New England  |
     +---------------------+----------+-----------+--+--------+---------------+
     |                               central         |         hhsnum         |
     |         not identifiable [1977+ only]         |              0         |
     +-----------------------------------------------+------------------------+
     |                                                   hhtype               |
     |               primary individual living with norelatives               |
     +---------------------------------------------+-------------+------------+
     |                                   hhstatu   |   numfami   |   numphh   |
     |  primary indiv. (living with nonrelatives   |         2   |        2   |
     +------------+-------+-------------------+----+-----+-------+-+----------+
     |    region  | smsa  |            smsa1  | smsasta  |  state  |  state1  |
     | Northeast  |    0  | not listed below  |    SMSA  |     11  |      11  |
     +---------+--+----+--+--+---------+------+----------+---------+----------+
     | tothhin |   adc | age | alimony |         anyreas | cowcurj | complet  |
     |    7245 | Other |  63 |      no | not in universe | NIU, NC |     yes  |
     +---------+-----+-+-----+---+-----+-----+-----------+---------+----------+
     |      curindu  |  curoccu  |  didntwo  |                      employm   |
     |  NIU [1971+]  |      NIU  |        2  |  other (retired)        NILF   |
     +----------+----+-----------+-----------+-+------------------------------+
     | famseco  |                      famnum  |                     famreln  |
     |       0  | not in sub/secondary family  | not in sub/secondary family  |
     +----------+----------+----------+--------+---+--------------------------+
     |             famtyp  | farmsel  |   fptfpar  |                 fptwork  |
     | primary individual  |       0  | nonworker  | NIU, not in labor force  |
     +----------+----------+-------+--+------------+----+---------------------+
     | highgra  | hourswo  | hhr1  |              hhr2  |               hhr3  |
     |      12  |     NIU  |   49  | head of household  | primary individual  |
     +----------+------+---+-------+-----+--------------+--+------------------+
     |     lwft2pc     |     lwftpay     |     lfworkl     |     lffptwo      |
     |         NIU     |         NIU     |          no     |         NIU      |
     +-----------------+-----------------+---+-------------+----+-------------+
     |                             lolayed   |        majacti   |   marital   |
     |  NIU/looking or layed off last year   |  keeping house   |  divorced   |
     +---------+--------+---------+----------+----------+-------+--+----------+
     | nonfarm | nftjob | nftwork | paidtim  | parents  | persequ  | ptearni  |
     |       0 |    NIU |     yes |     NIU  |     NIU  |       1  |       0  |
     +---------+--------+---------+---+------+----------+----------+----------+
     |                   ptincom      |                          populat      |
     |      3.05200000000000e+03      |      civilians 14+ [15+ in 1981]      |
     +------------------------+-------+---+---------+------------+------------+
     |               paamoun  |  parecip  |   race  |  rnawlwk   |  rnawlyr   |
     |  5.00000000000000e+02  |      yes  |  white  |      NIU   |    other   |
     +----------------------+-+--------+--+-------+-+---------+--+------------+
     |             relnhhh  |     sex  |  subfam  |  unemplo  |     veteran   |
     |  primary individual  |  female  |     NIU  |       no  |  nonveteran   |
     +-------------------+--+-------+--+-----+----+-----------+----+----------+
     |          perswag  | wkunemp  | wlly1  |              wlly2  |  wllyr1  |
     | NIU/none [1976+]  |     NIU  |   NIU  | none (not looking)  |     NIU  |
     +-------------------+---------++-------++--------+-----------++----------+
     |                     wllyr2  | wwly1  |  wwly2  |  whyless  |  whylfwo  |
     | nonworker [1976-1992 only]  |   NIU  |    NIU  |      NIU  |      NIU  |
     +---------+---------+---------++-------+---------+-----------++----------+
     | whynota | persnum | povcuto  |                      povlev  | cowlast  |
     |     NIU |       0 |    5909  | below poverty cutoff amount  |       5  |
     +---------+---------+---------++--------+----------+----------+----------+
     | spanish | industr | mainrea | occupat | stretch  | wkslabo  | famawgt  |
     |   other |       0 |     NIU |       0 |     NIU  |     NIU  |       0  |
     +---------+---------++--------+---------++---------++---------++---------+
     | fampwgt | famwgtb  | hhwgt  | perawgt  | perpwgt  | suppwgt  | baswgt  |
     |       0 |   85358  | 85358  |       0  |       0  |   85358  |  85026  |
     +---------+----------+--------+---+------+-----+----+-------+--+---------+
     |           typeain  |  typebin   |  typecin   |  typedin   |  typeein   |
     |  NIU/none [1976+]  |        0   |        0   |        0   |        0   |
     +-------------------++---------+--+-------+----+-----+------++-----------+
     |          dividen  | rentali  | publica  | supplem  |  cpi  |  vnmajid  |
     | NIU/none [1976+]  |       0  |     500  |       0  |    0  |        0  |
     +---------+---------++---------+----------+----------+-------+-+---------+
     | vnminid | presenc  | ownch6  | ownch18  | related  | famu18  | famo18  |
     |       0 |    none  |      0  |       0  |       0  |      0  |      0  |
     +---------+----------+--+------+-+--------+---------++--------++---------+
     | femalef |     laborfo | hhflag |              msa | msarank | pmsarank |
     |    none | 1+ employed |      0 | Portland, ME MSA |     150 |        0 |
     +---------+-------------+--------+------------------+---------+----------+
     |                                 cccode                                 |
     |                                      0                                 |
     +------------------------------------------------------------------------+

. exit,clear