**This program was written by Gia Elise Barboza at the Julian Samora Research Institute for
**the purpose of selecting data from the March Current Population Survey File. This program
**selects the the percentage of married families with own children under 6 that who are
**living with parents that are working full time..You must change the following line to the location where the data is located
** (i.e. the  SAV file).
GET FILE = 'C:\Notre Dame Project\CPS Variables\Zipped Files\March 2000\cps2000.SAV'.

**Recode a_wkstat variable to reflect less categories.
IF (a_wkstat= 1 | a_wkstat >2) WORKING=0.
IF (a_wkstat=2) WORKING=1.

VARIABLE LABELS WORKING 'WORK STATUS RECODED'.

VALUE LABELS WORKING
0 'No Full Time Status'
1 'Full Time Status'.

**We recode the following variables to give us hispanic and non-hispanic groups.
IF (a_reorgn<=7) hispanic=0.
IF (a_reorgn > 7 & a_race=1) hispanic=1.

VARIABLE LABELS hispanic 'HISPANIC ORIGIN RECODED'.

VALUE LABELS hispanic 
0 'hispanic'
1 'non-hispanic white'.

**This is a recoded variable that is not included in the raw text file. The March
**Supplement Final Weight has two implied decimal points. The variable finwght
**reflects this fact. 

WEIGHT BY finwght.

**To change the selection criteria to include HISPANICS ONLY, set hispanic = 0, for non-hispanic white set hispanic=1.
**To select state data, add the following to the selection criteria below
** (hg_st60=21 | hg_st60=59 | hg_st60=74 | hg_st60=93 | hg_st60=33).   

**TO select for the families with own children UNDER 18 change fownu6 > 0 to fownu18 > 0.
SELECT IF  hispanic=1 & a_wkstat > 0 & (a_famrel = 0 | a_famrel = 1) & (a_maritl = 1 | a_maritl = 2) & fownu6 > 0.

CROSSTABS
  /TABLES=hispanic BY WORKING BY hg_reg
  /FORMAT= AVALUE TABLES
  /CELLS= ROW TOTAL .