/* This is sascode(sas_shr_libs.sas). Rev. 11/16/2007 9:37:40 AM This code assigns the predefined librefs used by the mcdcshr SAS Share server. Used by the Missouri Census Data Center (MCDC) and OSEDA as a tool for providing remote access to their extensive data archive. This code is included by the various start_shr sas modules in /pvt/system. Coded by John Blodgett, Office of Social and Economic Data Analysis (OSEDA), under contract with the Missouri Census Data Center. Initial coding: July, 2001. Entries for new subdirectories of /pub/data will be added as they are created. ***<====NOTE: See http://mcdc.missouri.edu/applications/uexplore.html for a better explanation of some of these directories and to access the data and related metadata using the uexplore/dexter web tools. */ /* The libname macro takes the single positional argument, filetype, and generates the SAS statement: libname &filetype "/pub/data/&filetype" access=readonly; */ /* ============================Key Indicators Data Base============================= */ %libname(indctrs) /* Key indicators */ libname custom '/pub/data/indctrs/custom' access=readonly; libname indctrs2 (custom); *<---alias for custom-; libname kidscnt '/pub/data/indctrs/kidscnt' access=readonly; libname srcount '/pub/data/indctrs/srcount' access=readonly; %libname(mosenior); /* Missouri Senior Count data for project 2006 */ /* ===========================2000 Census filetypes================================== */ %libname(workflow); /* first county to county workflows file */ %libname(sf12000x) /* Standard MCDC Extract from SF1 */ libname sf1x (sf12000x); /* alias libref */ %libname(sf12000) /* Full SF1 datasets */ libname sf1 (sf12000); /* alias libref */ libname(mig2000); /* 1995-2000 county to county and other migration data */ libname sf1test '/pub/data/sf12000/sf1test' access=readonly; /* experimental version */ %libname(sf1prof) /* Census Bureau Demographic Profile ("DP-1" data, May, 2001) */ libname sf1geos '/pub/data/sf12000/xxgeos' access=readonly; /* SF1 geographic headers - 2 sets per state */ libname xxgeos (sf1geos); /* ============================Population Estimates================================= */ libname popests '/pub/data/popests' access=readonly; libname popeste '/pub/data/popests/temp' access=readonly; *<---this is where we put empbargoed estimates---; %libname(popests,nchsbri) %libname(sf22000) /* Summary File 2 */ libname sf2 (sf22000); /* alias for sf22000 */ %libname(sf3prof) /* Data as used in the DP-2, DP-3 and DP-4 profiles */ %libname(sf32000); /* Summary File 3 -- Complete Tables */ libname sf3 (sf32000); %libname(sf32000x); /* Summary File 3 - standard extracts */ libname sf3x (sf32000x); %libname(sf42000); /* Summary File 4 */ %libname(pl942000) /* Public Law 94-171 (Redistricting) file */ libname pl94 (pl942000); %libname(pums2000); /* Public Use MicroSample data, both 1 and 5 pct samples */ libname pums (pums2000); /* alias for pums2000 */ %libname(desex); /* Standard demographics for use by DESE */ %libname(eeo2000); /* EEO special tabs - occupations by race, hispanic, sex, age, etc. */ /* ======================================1990 Census filetypes=================================== */ %libname(pl9490) /* Public Law 94-171 data */ %libname(pl9490,pl9490tx) /* Special 1990 PL94 extract set used to generate our PL94 Basic Trend reports. In many cases the data has been converted to 2000 geography. */ %libname(stf901) /* Full STF1 datasets */ %libname(stf901x) /* original MCDC Extract from STF1 */ %libname(stf901x2) /* new MCDC Extract from STF1 for compatibility with sf12000x sets */ %libname(stf903) /* Full STF3 datasets */ %libname(stf903x) /* Standard MCDC extract from STF3 */ libname stf93xtr '/pub/data/stf903x/slvl140.bystate' access=readonly; /* census tract data by state */ libname stf93xbg '/pub/data/stf903x/slvl150.bystate' access=readonly; /* block group data by state */ libname stf93xpl '/pub/data/stf903x/slvl160.bystate' access=readonly; /* census tract data by state */ %libname(stf903x2) /* New STF3 extracts for trend reports */ %libname(pums90) /* Public Use Microsample data, A and B samples. */ /* ================================1980 Census filetypes======================================= */ %libname(stf803) /* Full STF3 datasets */ %libname(stf803x2) /* Standard extracts */ /* =================================Geographic reference======================================= */ %libname(georef ) /* Various 1990 geographic reference */ %libname(marf2 ) /* 1980 Master Area Reference File 2 */ %libname(corrlst) /* Geographic(mostly) correlation lists */ %libname(blkrel) /* 1990/2000 census block relationship files from Census Bureau */ %libname(mable2k) /* Master Area Block Level Equivalency files as used in geocorr2k */ /* ===============================Other========================================================= */ libname modotx '/pub/data/modotx' access=readonly; /* mostly sf32000-based data for Mo Dept of Trans. */ %libname(beareis ) /* REIS data from the Bureau of Economic Analysis */ %libname(cbp) /* County Business Patterns */ %libname(saipe) /* Small Area Income and Poverty estimates */ %libname(misc) /* Miscellaneous */ %libname(temp) /* Typically, output created for a user that will not be kept long */ %libname(nces) /* Public School Universe files, 1998, from Natl Center for Ed Stats */ %libname(empwage) /* Employment and Wage data for MO (mostly via MERIC) */ libname moprofs '/pub/data/moprofs'; *<---to allowed shared editing. Added 5-18-04--; %libname(acspums) /* American Community Survey PUMS data, 2004 */ *--Following ACS libs added 8-17-06--; %libname(acs2005); /* American Community Survey data, 2005 (released in 2006) */ libname basetabs '/pub/data/acs2005/basetabs' access=readonly; /* all base tables for acs2005 */ /* Adding these 11/16/2007 9:37:25 AM */ %libname(acs2006); libname acssumry '/pub/data/acs2006/summary' access=readonly; libname acspros '/pub/data/acs2005/profiles' access=readonly; %libname(irsmig); /* IRS county to county migration data */ /* Adding bls_la per request from bce 3/31/2008 */ %libname(bls_la); /* local unemployment data from BLS */ /* adding cntypage bce 6/6/2008 */ %libname(cntypage); /* added moprojs on 7/31/2008 */ %libname(moprojs);