**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 married families with own children under 6 who are living below the poverty threshold.
**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'.

COMPUTE PVGRP100 = POVLL.

RECODE PVGRP100 
(1 THRU 3 = 0)
(4 THRU 14 = 1).

**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 PVGRP100 'POVERTY LEVELS RECODED'.
VARIABLE LABELS hispanic 'HISPANIC ORIGIN RECODED'.

VALUE LABELS PVGRP100 
0 'Poverty'
1 'Above Poverty'.
 
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 the records
**pertaining to families with own children under 18, change fownu6 > 0 to fownu18 >0.

SELECT IF hispanic=1 & (a_famrel = 0 | a_famrel = 1) & (a_maritl = 1 | a_maritl = 2) & fownu6 > 0.

**If selecting state data change hg_reg to hg_st60.
CROSSTABS
  /TABLES=hispanic  BY PVGRP100 BY hg_reg
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .