Schedule of FSCSKey Changes

Schedule of Changes to Illinois newkeys

In FY2002, the NCES dataset included data from one new Illinois library, Orland Hills, P.L.D. (FSCSKEY = IL8023). Inclusion of these data appears to have been in error and this library's data have been deleted from PLDF3. The data are included in Tinley Park Public Library (FSCKEY = IL0525). The Web page says: that the Tinley Park Public Library serves the Villages of Tinley Park and Orland Hills. They have the same physical address, phone number, and Web address. By examining the data submitted from the two, it appears that most numbers submitted are the same (for example, both have 813 subscriptions, 131,029 volumes and 340,412 visits), but some, such as staffing are different. Orland Park's data report 1 ALA-accredited librarian while Tinley Park has 6.9. The data from 2003 are in process and I learned that Orland Park's data will not be reported separately in 2003.

There were a number of problems in the FY2002 data for Illinois that were missed and only came to light in reviewing the FY 2003 data. There are many minor errors in LIBNAME, for instance TOULON P.L.D. (IL0530) is "TOULON P.L.D.IRECTOR" in FY2002, TRI-TWP. P.L.D. (IL0534) was "TRI-TWP. P.L.D.RIC " in FY2002; TOWN AND COUNTRY P.L.D. (IL0159), and "TOWN AND COUNTRY P.L.D.IS"...and others similar. These rather look like errors that arose with cut and paste with insert mode on or a gang replace.

More worrisome are data anomalies. Here are the reported volumes held at six libraries for FY2001-FY2004:

Volumes Reportedly Held
at Six Illinois Libraries
Selected Years
LIBNAME	newkey	FY2001	FY2002	FY2003	FY2004
Cahokia P.L.D.	IL0067	32,294	125,998	33,951	35,739
Calumet City	IL0069	125,831	33,607	129,484	132,424
East St. Louis P.L.	IL0154	54,893	53,444	29,029	28,406
Mt. Carroll Twp. P.L.	IL0357	17,332	17,302	341,863	16,997
C.E. Brehm Mem. P.L.D	IL0363	61,273	199,960	67,940	71,102
Camargo TWP. D.L	IL0548	19,619	49,399	20,810	21,205

Of course, there may well be more that will come out with more systematic analysis.

FY 2005 Changes

Three libraries that reported from FY 1988 through FY 2003 did not report in FY 2004. When they reported again in FY 2005, they were assigned new FSCSKEYs. These libraries are: Hinckley which moves from IL0505 to IL0691, Riverside from IL0455 to IL0689, and Saybrook from IL0478 to IL0690. There were other libraries that had the similar reporting histories in Illinois that did not have new FSCSKEYs in FY 2005.

FY 2006 Changes

Two libraries had similar changes in their FSCSKEYs as the three libraries mentioned for the FY2005 data. Carrier Mills-Stonefront PLD had IL0079 from 1988, did not report in FY2005, and was assigned the new FSCSKEY of IL0695 for the FY2006 data. Similarly, Summit was in IL0518, did not report in FY2005, and was given IL0696 for FY2006. The newkey has been changed to the latter numbers.

Newman Township Library, 108 West Yates Street in Newman, Illinois has been in IL0377 since 1988. It did report in FY2006. Also reporting in these latest data is Newman Township District Library with the same address, phone number, and much overlapping data. It is in IL0694. I believe the two have partial data from the same library but there are differences between the two.

FY 2007 Changes

Untangling Newman Township took a bit of work and is discussed in the "Revision History" for 5/27/09 and is embodied in the SAS code changes in 2006.

 /* ALBANY               */
if year = 1988 and FSCSKEY = 'IL0004' then newkey = 'IL0642';
if year = 1990 and FSCSKEY = 'IL0605' then newkey = 'IL0642';
if year = 1992 and FSCSKEY = 'IL0605' then newkey = 'IL0642';

/* ARGENTA              */
if year = 1988 and FSCSKEY = 'IL0017' then newkey = 'IL0635';
if year = 1989 and FSCSKEY = 'IL0017' then newkey = 'IL0635';
if year = 1990 and FSCSKEY = 'IL0017' then newkey = 'IL0635';
if year = 1991 and FSCSKEY = 'IL0017' then newkey = 'IL0635';

/* CLINTON              */
if year = 1988 and FSCSKEY = 'IL0109' then newkey = 'IL0603';

/* CORNELL              */
if year = 1988 and FSCSKEY = 'IL0118' then newkey = 'IL0643';
if year = 1989 and FSCSKEY = 'IL0118' then newkey = 'IL0643';
if year = 1990 and FSCSKEY = 'IL0118' then newkey = 'IL0643';
if year = 1991 and FSCSKEY = 'IL0118' then newkey = 'IL0643';
if year = 1992 and FSCSKEY = 'IL0118' then newkey = 'IL0643';

/* CRESTWOOD            */
if year = 1988 and FSCSKEY = 'IL0122' then newkey = 'IL0637';

/* GRAND TOWER          */
if year = 1988 and FSCSKEY = 'IL0215' then newkey = 'IL0646';
if year = 1989 and FSCSKEY = 'IL0215' then newkey = 'IL0646';
if year = 1990 and FSCSKEY = 'IL0215' then newkey = 'IL0646';
if year = 1991 and FSCSKEY = 'IL0215' then newkey = 'IL0646';
if year = 1992 and FSCSKEY = 'IL0215' then newkey = 'IL0646';

/* LINCOLNWOOD          */
if year = 1988 and FSCSKEY = 'IL0291' then newkey = 'IL0608';

/* MELROSE PARK         */
if year = 1988 and FSCSKEY = 'IL0332' then newkey = 'IL0609';

/* CORTLAND             */
if year = 1991 and FSCSKEY = 'IL0611' then newkey = 'IL0644';
if year = 1992 and FSCSKEY = 'IL0611' then newkey = 'IL0644';

/* FORD HEIGHTS         */
if year = 1993 and FSCSKEY = 'IL0618' then newkey = 'IL8006';

/* DELAND               */
/* if year = 2002 and FSCSKEY = 'IL0136' then CITY = 'DELAND'; */

/* DUQUOIN              */
/* if year = 2002 and FSCSKEY = 'IL0148' then CITY = 'DUQUOIN'; */

/*-------------------2005----------------------------------------------------*/
/* HINCKLEY             */
if year = 1988 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
if year = 1989 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
if year = 1990 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
if year = 1991 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
if year = 1992 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
if year = 1993 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
if year = 1994 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
if year = 1995 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
if year = 1996 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
if year = 1997 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
if year = 1998 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
if year = 1999 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
if year = 2000 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
if year = 2001 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
if year = 2002 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
if year = 2003 and FSCSKEY = 'IL0505' then newkey = 'IL0691';
/*-------------------2005----------------------------------------------------*/

/* LAGRANGE PARK        */
/* if year = 2002 and FSCSKEY = 'IL0274' then CITY = 'LAGRANGE PARK'; */

/* LAHARPE              */
/* if year = 2002 and FSCSKEY = 'IL0275' then CITY = 'LAHARPE'; */

/* MT. OLIVE            */
/* if year = 2002 and FSCSKEY = 'IL0359' then CITY = 'MT. OLIVE'; */

/* OLMSTED              */
/* if year = 2002 and FSCSKEY = 'IL0399' then CITY = 'OLMSTED'; */

/* DEPUE                */
/* if year = 2002 and FSCSKEY = 'IL0482' then CITY = 'DEPUE'; */

/* ORLAND PARK P.L.D.   */
if year = 2002 and FSCSKEY = 'IL8023' then delete;

/*-------------------2005----------------------------------------------------*/
/* RIVERSIDE            */
if year = 1988 and FSCSKEY = 'IL0455' then newkey = 'IL0689';
if year = 1989 and FSCSKEY = 'IL0455' then newkey = 'IL0689';
if year = 1990 and FSCSKEY = 'IL0455' then newkey = 'IL0689';
if year = 1991 and FSCSKEY = 'IL0455' then newkey = 'IL0689';
if year = 1992 and FSCSKEY = 'IL0455' then newkey = 'IL0689';
if year = 1993 and FSCSKEY = 'IL0455' then newkey = 'IL0689';
if year = 1994 and FSCSKEY = 'IL0455' then newkey = 'IL0689';
if year = 1995 and FSCSKEY = 'IL0455' then newkey = 'IL0689';
if year = 1996 and FSCSKEY = 'IL0455' then newkey = 'IL0689';
if year = 1997 and FSCSKEY = 'IL0455' then newkey = 'IL0689';
if year = 1998 and FSCSKEY = 'IL0455' then newkey = 'IL0689';
if year = 1999 and FSCSKEY = 'IL0455' then newkey = 'IL0689';
if year = 2000 and FSCSKEY = 'IL0455' then newkey = 'IL0689';
if year = 2001 and FSCSKEY = 'IL0455' then newkey = 'IL0689';
if year = 2002 and FSCSKEY = 'IL0455' then newkey = 'IL0689';
if year = 2003 and FSCSKEY = 'IL0455' then newkey = 'IL0689';

/* SAYBROOK             */
if year = 1988 and FSCSKEY = 'IL0478' then newkey = 'IL0690';
if year = 1989 and FSCSKEY = 'IL0478' then newkey = 'IL0690';
if year = 1990 and FSCSKEY = 'IL0478' then newkey = 'IL0690';
if year = 1991 and FSCSKEY = 'IL0478' then newkey = 'IL0690';
if year = 1992 and FSCSKEY = 'IL0478' then newkey = 'IL0690';
if year = 1993 and FSCSKEY = 'IL0478' then newkey = 'IL0690';
if year = 1994 and FSCSKEY = 'IL0478' then newkey = 'IL0690';
if year = 1995 and FSCSKEY = 'IL0478' then newkey = 'IL0690';
if year = 1996 and FSCSKEY = 'IL0478' then newkey = 'IL0690';
if year = 1997 and FSCSKEY = 'IL0478' then newkey = 'IL0690';
if year = 1998 and FSCSKEY = 'IL0478' then newkey = 'IL0690';
if year = 1999 and FSCSKEY = 'IL0478' then newkey = 'IL0690';
if year = 2000 and FSCSKEY = 'IL0478' then newkey = 'IL0690';
if year = 2001 and FSCSKEY = 'IL0478' then newkey = 'IL0690';
if year = 2002 and FSCSKEY = 'IL0478' then newkey = 'IL0690';
if year = 2003 and FSCSKEY = 'IL0478' then newkey = 'IL0690';

/* WILLIAMSVILLE        */
if year = 1988 and FSCSKEY = 'IL0582' then newkey = 'IL0687';
if year = 1989 and FSCSKEY = 'IL0582' then newkey = 'IL0687';
if year = 1990 and FSCSKEY = 'IL0582' then newkey = 'IL0687';
if year = 1991 and FSCSKEY = 'IL0582' then newkey = 'IL0687';
if year = 1992 and FSCSKEY = 'IL0582' then newkey = 'IL0687';
if year = 1993 and FSCSKEY = 'IL0582' then newkey = 'IL0687';
if year = 1994 and FSCSKEY = 'IL0582' then newkey = 'IL0687';
if year = 1995 and FSCSKEY = 'IL0582' then newkey = 'IL0687';
if year = 1996 and FSCSKEY = 'IL0582' then newkey = 'IL0687';
if year = 1997 and FSCSKEY = 'IL0582' then newkey = 'IL0687';
if year = 1998 and FSCSKEY = 'IL0582' then newkey = 'IL0687';
if year = 1999 and FSCSKEY = 'IL0582' then newkey = 'IL0687';
if year = 2000 and FSCSKEY = 'IL0582' then newkey = 'IL0687';
if year = 2001 and FSCSKEY = 'IL0582' then newkey = 'IL0687';
/*-------------------2005----------------------------------------------------*/

/*-------------------2006----------------------------------------------------*/
/* Newman Township             */                                                                                                       
if year = 1988 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 1989 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 1990 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 1991 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 1992 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 1993 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 1994 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 1995 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 1996 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 1997 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 1998 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 1999 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 2000 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 2001 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 2002 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 2003 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 2004 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 2005 and FSCSKEY = 'IL0377' then newkey = 'IL0694';                                                                           
if year = 2006 and FSCSKEY = 'IL0377' then delete;                                                                                      
                                                                                                                                        
/* Carrier Mills-Stonefort PLD */
if year = 1988 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 1989 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 1990 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 1991 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 1992 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 1993 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 1994 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 1995 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 1996 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 1997 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 1998 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 1999 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 2000 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 2001 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 2002 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 2003 and FSCSKEY = 'IL0079' then newkey = 'IL0695';
if year = 2004 and FSCSKEY = 'IL0079' then newkey = 'IL0695';


/* SUMMIT               */
if year = 1988 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 1989 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 1990 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 1991 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 1992 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 1993 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 1994 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 1995 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 1996 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 1997 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 1998 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 1999 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 2000 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 2001 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 2002 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 2003 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
if year = 2004 and FSCSKEY = 'IL0518' then newkey = 'IL0696';
/*-------------------2006----------------------------------------------------*/

December 16, 2022