/*
  This is sascode(sas_shr_libs.sas).  Rev. 8/10/2009 10:34:54 AM , jgb. 
  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============================= */

%global opt;

%macro server_test;
  %let opt=%str(access=readonly;);
  %if &server eq mcdcshr2 %then %do;
    %let opt=;
  %end;
%mend;

%server_test;

 %libname(indctrs,opts=&opt)        /* Key indicators */
 %libname(indctrs,custom,opts=&opt) 
 libname indctrs2 '/pub/data/indctrs/custom' &opt;  *<---alias for custom-; 
 %libname(kidscnt,opts=&opt)
 %libname(srcount,opts=&opt)
 %libname(mosenior,opts=&opt);  /* Missouri Senior Count data for project 2006 */ 
  
  
/* ===========================2000 Census filetypes================================== */    
 %libname(workflow,opts=&opt)     /* first county to county workflows file */
 %libname(sf12000x,opts=&opt)      /* Standard MCDC Extract from SF1  */
  libname sf1x '/put/data/sf12000x' &opt;  /* alias libref */
 %libname(sf12000, opts=&opt)       /* Full SF1 datasets               */
  libname sf1  '/pub/data/sf12000' &opt;   /* alias libref */
 %libname(mig2000,opts=&opt);     /* 1995-2000 county to county and other migration data */

  libname sf1test '/pub/data/sf12000/sf1test' &opt;  /* experimental version */

 %libname(sf1prof,opts=&opt)       /* Census Bureau Demographic Profile ("DP-1" data, May, 2001) */

  libname sf1geos '/pub/data/sf12000/xxgeos' &opt; /* SF1 geographic headers - 2 sets per state */
  libname xxgeos '/pub/data/sf12000/xxgeos' &opt;
  
/* ============================Population Estimates================================= */  
  
  %libname(popests, opts=&opt)
  libname popeste '/pub/data/popests/temp' &opt;  *<---this is where we put empbargoed estimates---; 
  
 %libname(popests,nchsbri, opts=&opt) 

 %libname(sf22000, opts=&opt)        /* Summary File 2 */
  libname sf2 '/pub/data/sf22000' &opt; /* alias for sf22000 */    
  
 %libname(sf3prof, opts=&opt)     /* Data as used in the DP-2, DP-3 and DP-4 profiles */
  
 %libname(sf32000, opts=&opt);    /* Summary File 3 -- Complete Tables */ 
  libname sf3 '/pub/data/sf32000' &opt;
  
 %libname(sf32000x, opts=&opt);   /* Summary File 3 - standard extracts*/
  libname sf3x '/pub/data/sf32000x' &opt;   
  
 %libname(sf42000, opts=&opt);  /* Summary File 4 */  

 %libname(pl942000, opts=&opt)      /* Public Law 94-171 (Redistricting) file */ 
  libname pl94 '/pub/data/pl942000' &opt;  
 
 %libname(pums2000, opts=&opt);     /* Public Use MicroSample data, both 1 and 5 pct samples */
  libname pums '/pub/data/pums2000' &opt;  /* alias for pums2000  */
  
 %libname(desex, opts=&opt);   /* Standard demographics for use by DESE */ 
 
 %libname(eeo2000, opts=&opt);  /* EEO special tabs - occupations by race, hispanic, sex, age, etc. */ 
 

/* ======================================1990 Census filetypes=================================== */
 %libname(pl9490, opts=&opt)        /* Public Law 94-171 data         */
 %libname(pl9490,pl9490tx, opts=&opt) /* 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, opts=&opt)        /* Full STF1 datasets */
 %libname(stf901x, opts=&opt)       /* original MCDC Extract from STF1 */
 %libname(stf901x2, opts=&opt)      /* new MCDC Extract from STF1 for compatibility with sf12000x sets */
 

 %libname(stf903, opts=&opt)        /* Full STF3 datasets */
 %libname(stf903x, opts=&opt)       /* Standard MCDC extract from STF3 */
 libname stf93xtr  '/pub/data/stf903x/slvl140.bystate' &opt; /* census tract data by state */
 libname stf93xbg  '/pub/data/stf903x/slvl150.bystate' &opt; /* block group data by state */
 libname stf93xpl  '/pub/data/stf903x/slvl160.bystate' &opt; /* census tract data by state */
 %libname(stf903x2, opts=&opt)        /* New STF3 extracts for trend reports */

  %libname(pums90, opts=&opt)       /* Public Use Microsample data, A and B samples. */

 /* ================================1980 Census filetypes======================================= */

 %libname(stf803, opts=&opt)        /* Full STF3 datasets*/
 %libname(stf803x2, opts=&opt)       /* Standard extracts*/

 /* =================================Geographic reference======================================= */

 %libname(georef, opts=&opt)       /* Various 1990 geographic reference */
 %libname(marf2, opts=&opt)        /* 1980 Master Area Reference File 2*/
 %libname(corrlst, opts=&opt)       /* Geographic(mostly) correlation lists */
 %libname(blkrel, opts=&opt)        /* 1990/2000 census block relationship files from Census Bureau  */ 
 %libname(mable2k, opts=&opt)       /* Master Area Block Level Equivalency files as used in geocorr2k */


 /* ===============================Other========================================================= */
  libname modotx '/pub/data/modotx' &opt;  /* mostly sf32000-based data for Mo Dept of Trans. */
  %libname(beareis, opts=&opt)         /* REIS data from the Bureau of Economic Analysis */
  libname beareis1 '/pub/data/beareis/test' &opt; 
  %libname(cbp, opts=&opt)          /* County Business Patterns  */
  %libname(saipe, opts=&opt)        /* Small Area Income and Poverty estimates */ 
  %libname(misc, opts=&opt)         /* Miscellaneous  */
  %libname(temp, opts=&opt)         /* Typically, output created for a user that will not be kept long */
  %libname(nces, opts=&opt)         /* Public School Universe files, 1998, from Natl Center for Ed Stats */ 
  %libname(empwage, opts=&opt)      /* Employment and Wage data for MO (mostly via MERIC)  */ 
  
  %libname(moprofs , opts=&opt) *<---to allowed shared editing. Added 5-18-04--; 
 
   %libname(acspums, opts=&opt)    /* American Community Survey PUMS data, 2004 */  

   *--Following ACS libs added 8-17-06--;  
   %libname(acs2005, opts=&opt);     /* American Community Survey data, 2005 (released in 2006) */
   libname acsbt05 '/pub/data/acs2005/basetabs' &opt; /* all base tables for acs2005 */

 /* Adding these 11/16/2007 9:37:25 AM  */ 
   %libname(acs2006, opts=&opt);
   **libname acssumry '/pub/data/acs2006/summary' &opt; 
   **libname acspros  '/pub/data/acs2005/profiles' &opt; 
   
   %libname(irsmig, opts=&opt);  /* IRS county to county migration data
*/
   
 /* Adding bls_la per request from bce 3/31/2008 */
   %libname(bls_la, opts=&opt);  /* local unemployment data from BLS */ 
    
   
/* adding cntypage bce 6/6/2008 */
   %libname(cntypage, opts=&opt);

/* added moprojs on 7/31/2008 */
   %libname(moprojs, opts=&opt);

/* added acs2007 (bce) on 9/23/2008 */
   %libname(acs2007, opts=&opt);
/* added basetbls and acscuryr (jgb) on 8/10/2009 */
   libname acscuryr "/pub/data/acs2007" &opt;   *<----edit each year.---; 
   libname basetbls "/pub/data/acs2007/basetbls" &opt;   *<---edit each year. Note acsbt07 below will remain--; 
   %libname(acs, opts=&opt);
   

/* added (bce) on 10/24/2008 */
   libname acsbt07 '/pub/data/acs2007/basetbls' &opt;
   libname acsbt06 '/pub/data/acs2006/summary' &opt;
   libname acspf07 '/pub/data/acs2007/profiles' &opt;
   libname acspf06 '/pub/data/acs2006/profiles' &opt;


/* added (bce) on 1/22/2009 */
   %libname(sf32kacs, opts=&opt);

/* added (bce) on 02/13/2009 */
   %libname(ag2007, opts=&opt);

/* added (bce) on 02/23/2009 */
   %libname(popests2, opts=&opt);

/* added (bce) on 06/09/2009 */
   libname billy '/home/billy/sasdataset' &opt;