* SPSS syntax to generate:
* CFSR Item I) Total C/AN Reports Disposed. 
* Field RPTID is used to identify unique reports.
* Syntax applies to NCANDS Child File V4.0.
************************************************************************************.
****** Lines beginning with '*' are comments and are not executed by SPSS.     *****.
****** Name of State Master File must be entered in highlighted section below. *****.
************************************************************************************.


**********************************************************************************.
********** Enter name of the State Master File in following command line *********.
get file = 'ENTER STATE FILE NAME HERE'
    /keep = staterr subyr rptid rptdisp .


* Group reports with the same ID together using the SORT command.
* If more than one child in the report, multiple entries are found for that report.
sort cases by rptid . 

* Remove multiple entries by selecting only the first entry for each report.
* SPSS lag function below means: 
*  'Select record if the Report ID is not the same as previous Report ID (i.e, the first entry)'.
select if (rptid ne lag(rptid)) .

* Active file now contains only unique reports.
* Following command generates count of reports within this disposition year. 
freq subyr.