Read Me File for the NCES Common Core of Data Public Elementary/Secondary School Universe Survey: School Year 2000-01:  One Year Later Files (CO, DE, NJ, OK, OR, SD, UT, VT, and PR)
(January 2004)

The following ASCII and SAS data sets contain revised Common Core of Data Public Elementary/ Secondary School Universe Survey: 2000-01 data for Colorado, Delaware, New Jersey, Oklahoma, Oregon, South Dakota, Utah, Vermont, and Puerto Rico:

Content Changes in Revised Files:

Kenutcky:

*Variable TYPE01 changed for 1 record.
*Variable FTE01 changed for 416 records.
*Variable STITLI01 changed for 2 records.
*Variable FRELCH01 changed for 1,159 records.
*Variable REDLCH01 changed for 1,048 records.
*Variable TOTFRL01 changed for 1,139 records.
*Variable MIGRNT01 changed for 2 records.
*Variable PUPTCH01 changed for 413 records.
*Variable IFRELC01 changed for 51 records.
*Variable IREDLC01 changed for 2 records.
*Variable ITOTFR01 changed for 52 records.

Massachusetts:
*Variables MSTREE01 and LSTREE01 changed for 1 record.

New Mexico:
*Variables TITLEI01 and ISTITL01 changed for 1 record.
*Variable STITLI01 changed for 5 records.

New York:
*Variable STID01 changed for 54 records.

Oregon: 
*Variable TOTKG01 changed for 299 records.
*Variable ASKGM01 changed for 393 records.
*Variable ASKGF01 changed for 407 records.
*Variable TOTGRD01 changed for 297 records.
*Variable ASIAN01 changed for 393 records. 
*Variable ASALM01 changed for 393 records.     
*Variable ASALF01 changed for 407 records.
*Variable TOTETH01 changed for 393 records.
*Variable PUPTCH01 changed for 259 records.
*Variable MEMBER01 changed for 299 records.
*Variable ITOTKG01 changed for 299 records.

South Carolina:
*All membership data (total membership, grade totals, race and grade details, race details), FRELCH01, TOTFRL01, PUPTCH01, IFRELC01, and ITOTFRL01 changed for 1 record.

Tennessee:
*Variables SEASCH01, MSTREE01, and LSTREE01 changed for 1 record.

Northern Marianas: 
*Variables FRELCH01 and REDLCH01 changed for 1 record.
*Variable TOTFRL01 changed for 2 records.
*Variables ASKGU01, WHKGU01, AS05U01, WH05M01, WH05F01, and WH05U01 changed for 1 record.
*Variables TOTGRD01 and ASIAN01 changed for 1 record.  
            

Data File User's Guide

ASCII file names
ky011bsc.dat
ma011bsc.dat
nm011bsc.dat
ny011bsc.dat
or011bsc.dat
sc011bsc.dat
tn011bsc.dat
mp011bsc.dat


SAS file names
ky011bsc.sd2
ma011bsc.sd2
nm011bsc.sd2
ny011bsc.sd2
or011bsc.sd2
sc011bsc.sd2
tn011bsc.sd2
mp011bsc.sd2



Merging One Year Later Files with Complete Files:
These revised files can be merged into the below list pre-existing Common Core of Data Public Elementary/Secondary School Universe Survey: 2001-02 data files.  The FIPS code can be used for each state to delete and replace the schools.  The FIPS codes for Kentucky = 21, Massachusetts = 25, New Mexico = 35, New York = 36, Oregon = 41, South Carolina = 45, Tennessee = 47, and Northern Marianas = 69.

sc011akn.sd2 (contains data for Kentucky, Massachusetts, New Mexico, and New York)
sc011aow.sd2 (contains data for Oregon, South Carolina, Tennessee, and the Northern Marianas)

SAS code for merging the One Year Later SAS files into pre-existing SAS CCD School Universe files is as follows:

KENTUCKY
DATA TEMP;
SET LIBNAME.SC011AKN;
WHERE FIPST NE "21";
RUN;
DATA LIBNAME.SC011BKN;
SET TEMP LIBNAME.KY011BSC;
RUN;

MASSACHUSETTS
DATA TEMP;
SET LIBNAME.SC011AKN;
WHERE FIPST NE "25";
RUN;
DATA LIBNAME.SC011BKN;
SET TEMP LIBNAME.MA011BSC;
RUN;

NEW MEXICO
DATA TEMP;
SET LIBNAME.SC011AKN;
WHERE FIPST NE "35";
RUN;
DATA LIBNAME.SC011BKN;
SET TEMP LIBNAME.NM011BSC;
RUN;

NEW YORK
DATA TEMP;
SET LIBNAME.SC011AKN;
WHERE FIPST NE "36";
RUN;
DATA LIBNAME.SC011BKN;
SET TEMP LIBNAME.NY011BSC;
RUN;

OREGON
DATA TEMP;
SET LIBNAME.SC011AOW;
WHERE FIPST NE "41";
RUN;
DATA LIBNAME.SC011BOW;
SET TEMP LIBNAME.OR011BSC;
RUN;

SOUTH CAROLINA
DATA TEMP;
SET LIBNAME.SC011AOW;
WHERE FIPST NE "45";
RUN;
DATA LIBNAME.SC011BOW;
SET TEMP LIBNAME.SC011BSC;
RUN;


TENNESSEE
DATA TEMP;
SET LIBNAME.SC011AOW;
WHERE FIPST NE "47";
RUN;
DATA LIBNAME.SC011BOW;
SET TEMP LIBNAME.TN011BSC;
RUN;

NORTHERN MARIANAS
DATA TEMP;
SET LIBNAME.SC011AOW;
WHERE FIPST NE "69";
RUN;
DATA LIBNAME.SC011BOW;
SET TEMP LIBNAME.MP011BSC;
RUN;

Additional Information on Data Files: 
Please refer to the original 2001-02 school file documentation for more information on content and other user's information.