**EZ9served01c.sps   12-29-2003  2001 syntax  for calculating the denominator for maltreatment in foster care.
**This file creates "inc1"& "entry" files to be combined as 
**the 9-month served FC pop for denominator of Safety Measure 


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

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

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