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)
(May 2003)

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:

Colorado:
*Variable TYPE00 changed for 5 records.

Delaware:
*Variable FTE00 and PUPTCH00 changed for 1 record.
*Variables MIGRNT00 and IMIGRN00 changed for 191 records. 

New Jersey:
State resubmitted entire file.  Most variables in file changed.

Oklahoma:
*Variables MSTREE00, MCITY00, MSTATE00, MZIP00, MZIP400,LSTREE00, LCITY00, LSTATE00, LZIP00, and LZIP400 changed for 2 records. 

Oregon: 
*All Grade2 - Grade 10 variables, membership variable, and race/ethnicity variables, and related flags changed for 10 records.

South Dakota:
*All Grade PK - Grade 6 variables, AM, and WH variables changed for 1 record.

Utah:
*Variables LSTREE00, LCITY00, and LSTATE00 changed for 1 record.
*Variables FTE00 and PUPTCH00 changed for 1 record.
 
Vermont:
*Variable MIGRNT00 changed for 393 records.

Puerto Rico:
*Variables FRELCH00 and REDLCH00 changed for 1531 records.
*Variable IREDLC00 changed for 1535 records. 


Data File User's Guide

ASCII file names
co001bsc.dat
de001bsc.dat
nj001bsc.dat
ok001bsc.dat
or001bsc.dat
sd001bsc.dat
ut001bsc.dat
vt001bsc.dat
pr001bsc.dat

SAS file names
co001bsc.sd2
de001bsc.sd2
nj001bsc.sd2
ok001bsc.sd2
or001bsc.sd2
sd001bsc.sd2
ut001bsc.sd2
vt001bsc.sd2
pr001bsc.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: 1999-2000 data files.  The FIPS code can be used for each state to delete and replace the schools.  The FIPS codes for California=06, Montana=30, and Puerto Rico=72.

sc001aai.sd2 (contains data for Colorado and Delaware)
sc001akn.sd2 (contains data for New Jersey)
sc001aow.sd2 (contains data for Oklahoma, Oregon, South Dakota, Utah, Vermont, and Puerto Rico)

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

COLORADO
DATA TEMP;
SET LIBNAME.SC001AAI;
WHERE FIPST NE "08";
RUN;
DATA LIBNAME.SC001BAI;
SET TEMP LIBNAME.CO001BSC;
RUN;

DELAWARE
DATA TEMP;
SET LIBNAME.SC001AAI;
WHERE FIPST NE "10";
RUN;
DATA LIBNAME.SC001BAI;
SET TEMP LIBNAME.DE001BSC;
RUN;

NEW JERSEY
DATA TEMP;
SET LIBNAME.SC001AKN;
WHERE FIPST NE "34";
RUN;
DATA LIBNAME.SC001BKN;
SET TEMP LIBNAME.NJ001BSC;
RUN;

OKLAHOMA
DATA TEMP;
SET LIBNAME.SC001AOW;
WHERE FIPST NE "40";
RUN;
DATA LIBNAME.SC001BOW;
SET TEMP LIBNAME.OK001BSC;
RUN;

OREGON
DATA TEMP;
SET LIBNAME.SC001AOW;
WHERE FIPST NE "41";
RUN;
DATA LIBNAME.SC001BOW;
SET TEMP LIBNAME.OR001BSC;
RUN;

SOUTH DAKOTA
DATA TEMP;
SET LIBNAME.SC001AOW;
WHERE FIPST NE "46";
RUN;
DATA LIBNAME.SC001BOW;
SET TEMP LIBNAME.SD001BSC;
RUN;

UTAH
DATA TEMP;
SET LIBNAME.SC001AOW;
WHERE FIPST NE "49";
RUN;
DATA LIBNAME.SC001BOW;
SET TEMP LIBNAME.UT001BSC;
RUN;

VERMONT
DATA TEMP;
SET LIBNAME.SC001AOW;
WHERE FIPST NE "50";
RUN;
DATA LIBNAME.SC001BOW;
SET TEMP LIBNAME.VT001BSC;
RUN;

PUERTO RICO
DATA TEMP;
SET LIBNAME.SC001AOW;
WHERE FIPST NE "72";
RUN;
DATA LIBNAME.SC001BOW;
SET TEMP LIBNAME.PR001BSC;
RUN;


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