Instructions for Executing SPSS Syntax to Generate Counts for CFSR 
                          NCANDS Technical Team  November 6, 2001


     Each section of the CFSR is associated with an SPSS syntax file.  To derive counts for a particular section, execute the syntax associated with that section.  Consult SPSS documentation for instructions on how to execute syntax files.  Note that each set of syntax addresses a path and file name structure which must be modified to be site specific.  

The name of the syntax file for each section is provided below.

CFSR SECTION                         SPSS Syntax File Name
Section I (Reports)                  cfsr_i_rpts.sps
Section I (Duplicate Children)       cfsr_i_dupchld.sps
Section I (Unique Children)          cfsr_i_unqchld.sps
Section II (Reports)                 cfsr_ii_rpts.sps 
Section II (Duplicate Children)      cfsr_ii_dupchld.sps
Section II (Unique Children)         cfsr_ii_unqchld.sps 
Section III (Duplicate Children)     cfsr_iii_dupchld.sps
Section III (Unique Children)        cfsr_iii_unqchld.sps
Section IV (Unique Children)         cfsr_iv_dupchld.sps
Section IV (Unique Children)         cfsr_iv_unqchld.sps
Section V (Unique Children)          cfsr_v_unqchld.sps
Section VI (Unique Children)         cfsr_vi_unqchld.sps
Section VII (Unique Children)        cfsr_vii_unqchld.sps

     After loading the syntax for the appropriate section, the entry for the file name associated with the initial 'GET FILE' command must be edited to be site specific.  Most often the file referenced will be the one routinely provided to the State upon acceptance of their Child File submission.

     The syntax provided will also permit States to generate counts for the CFSR using ASCII data that have been extracted for submission to NCANDS.  However, an additional step is required in that the ASCII file must be converted to an SPSS .SAV file using the appropriate variable naming conventions.  Such a conversion can be accomplished by executing the SPSS syntax file CFSR_CONVERT_ASCII.SPS.  After loading this syntax file, enter the name of your ASCII file in conjunction with the 'DATA LIST' command line and the name of the .SAV file you are to create on the 'SAVE OUTFILE' command line.  Once these entries are made and the syntax is executed, a .SAV file suitable for processing with the CFSR syntax will be generated.  The location of this file will then be the basis for the site specific modification noted above. 

	Questions concerning this syntax should be directed to the NCANDS Technical Team liaison for the State.