The syntax is available on the Children’s Bureau (CB) website.
A zip file is available with the code files and supporting files for completing data quality checks and calculating performance on the indicators. For detailed instructions on how to access, download and run the syntax, see "Instructions and Tips for Running the CFSR Round 3 Statewide Data Indicators Syntax."
You can also access a PDF copy of the syntax used to perform data quality checks, calculate observed performance, and calculate risk-standardized performance on the seven statewide data indicators. This document can be used to develop a better understanding of the statistical calculations or provide assistance for individuals who do not have SPSS and/or STATA statistical software to run the syntax files.
Syntax to calculate risk-standardized performance for each state uses a national, risk-adjusted model that requires child-level data from all states (i.e., national datasets) and thus cannot be replicated by states and interested parties
A copy of AFCARs files or NCANDS files submitted to CB can be obtained from the person or team within the state responsible for transmitting it to CB. Additionally, submitted NCANDS files are also accessible from the secure NCANDS portal, which requires login credentials. Questions can be directed to members of the state data team or the Capacity Building Center for States.
State and CB calculations for observed performance will be identical if the state uses the same AFCARS or NCANDS data submissions as CB used. If any updates have been made to the data files since the data were submitted to CB, the results could be different.
Risk-standardized performance (RSP) cannot be calculated by the states. Calculating RSP requires data for all states and the SPSS syntax provided by CB does not implement RSP calculations.
The Capacity Building Center for States, with support from CB, is available to assist states with assessing the reason(s) for discrepancies between state and CB performance calculations. For assistance, contact your Capacity Building Center for States Tailored Services Liaison or email firstname.lastname@example.org.
Yes, it is possible to calculate observed performance using alternative statistical software or programming languages. The underlying logic of the SPSS syntax can be replicated and, if the logic is replicated correctly, results produced from alternative methods will match CB’s results, assuming the exact same AFCARS and NCANDS data submissions are used. If the results produced from alternative methods do not match CB’s results, then there is an error in the developed methods.
The Center for States is available to assist with efforts to calculate performance on the statewide data indicators using SPSS or other software. Additionally, The Center for States can help identify others who have developed alternative methods and might be available for peer support. To learn more, contact your Tailored Services Liaison or email email@example.com.