**This file creates "inc1"& "entry" files to be combined as 
**the 9-month served FC pop for denominator for maltreatment in foster care.
***EZ9served02c.sps     2002 syntax  


get file 'c:\cfsr\EZdata\EZserved02c.sav'.
FILTER OFF.
USE ALL.
SELECT IF(YRMODA(latremyr,latremmo,latremda) <= YRMODA(2002,9,30)).
EXECUTE .
FILTER OFF.
USE ALL.
SELECT IF(YRMODA(latremyr,latremmo,latremda) >= YRMODA(2002,1,1)).
SAVE OUTFILE='c:\cfsr\EZdata\EZ9served-entry02c.sav'.
EXECUTE .

get file 'c:\cfsr\EZdata\EZserved02c.sav'.
FILTER OFF.
USE ALL.
SELECT IF(YRMODA(latremyr,latremmo,latremda) <= YRMODA(2001,12,31)).
EXECUTE .
FILTER OFF.
USE ALL.
SELECT IF(YRMODA(dodfcyr,dodfcmo,dodfcda) >= YRMODA(2002,1,1) | MISSING(dodfcyr) &
  MISSING(dodfcmo) & MISSING(dodfcda)).
save outfile='c:\cfsr\EZdata\EZ9served-inc1st02c.sav'.
execute.

ADD FILES /FILE=*
 /FILE='c:\cfsr\EZdata\EZ9served-entry02c.sav'.
EXECUTE.
save outfile='c:\cfsr\EZdata\EZtot9served02c.sav'.
exe.
FREQUENCIES
  VARIABLES=state
  /ORDER  ANALYSIS .
exe.