**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 selects the number of familes with own children under 18 who are headed by a single person
**who is either male or female. 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'.

IF (FKIND =1) FAMGRP=0.
IF (FKIND > 1) FAMGRP=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.

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

SELECT IF (a_famrel = 0 | a_famrel = 1) & a_famtyp = 1 &  fownu18 > 0 & hispanic = 1.

VARIABLE LABELS FAMGRP 'Family Kind Recoded'.
VARIABLE LABELS hispanic 'HISPANIC ORIGIN RECODED'.

VALUE LABELS FAMGRP 
0 'Husband Wife Family'
1 'Single Person Family'.

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

CROSSTABS
  /TABLES= hispanic BY famgrp  BY hg_reg
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT TOTAL .