**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 highest level of school completed by individuals who are greater than 25 years of age.
**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 EDUCGRP = a_hga.

RECODE EDUCGRP
(0 THRU 34 = 0)
(35 THRU 38 = 1)
(39 = 2)
(40 THRU 42 = 3)
(43 =4)
(44 THRU 46 = 5).

**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 EDUCGRP 'EDUCATIONAL GROUPINGS'.
VARIABLE LABELS hispanic 'HISPANIC ORIGIN RECODED'.

VALUE LABELS EDUCGRP
0 'Less than 9th Grade'
1 '9th through 12th Grade'
2 'High School Graduate'
3 'Some College'
4 'College Graduate'
5 'Advanced Degree'.

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

SELECT IF a_age GE 25 & hispanic = 0.

**If using state data change hg_reg to hg_st60.
MISSING VALUE EDUCGRP (99).
CROSSTABS
  /TABLES=hispanic BY educgrp By hg_reg
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT ROW .