x cd /pub/data/sf32000/Tools;   %let pgm=invoke_dosets;  filename pgm "&pgm..sas";
 /*--Invoke the %doset macro to create observations in the Datasets dataset for this directory.
     J. Blodgett, OSEDA, Apr., 2009  (this is the "do-over" version created after we lost our data and had
      to restore and/or reconvert it, spring, 2009.
  -- */
   title "Job to Invoke doset Macro for Sets in sf32000, creating sf32000.datasets";


  libname sf32000 '/pub/data/sf32000';

  *-----Run this step ONLY ONCE------------------------------------------;
  *----If you need to rerun (start over) then delete the datasets dataset first.  doset will not
       allow initialize mode if the datasets set already exists.---;
  %***doset(mode=initialize,
         libname=sf32000,debug=0);
  *----------------------------------------------------------------------;

   %global todo;

   %*let todo=uspumas;
   %**let todo=mozips ilzips;
   %*let todo=moregns06ph morgns06phct moregns06phctr moregns06;
   %*let todo=usgeocompgeos usgeocompsgeos usgeocompsph usgeocompsphct usgeocompsphctr
             uscousubsgeo uscousubsph uscousubsphct uscousubsphctr;
   %let todo= usuasph usuasphct usuasphctr
             usmetrosph usmetrosphct usmetrosphctr
             uscds106ph uscds106phct uscds106phctr;
  %let statenm=Missouri;

  /* =======================Begin comment================
 *==============================1-time Fix run to delete obsolete contents-only observations from datasets----;
 data sf32000.datasets_edited;  set sf32000.datasets;
   where libname ne " ";
   run;
 *---ran this step (above) from DM.  After which we deleted the old datasets data set and renamed datasets_edited to datasets.---;
 proc datasets library=sf32000 nolist;
      modify datasets;
      index delete dataset memname;
      index create  dataset=(libname memname) / unique;
      index create memname;
      quit;
     ======================End comment================== */

 %doset(mode=,libname=sf32000,
         memname=usgeos,
         memlabel=%nrbquote(Geographic variables only for all available U.S. summaries),
         geouniv=UnitedStates,
         units=Too many to list,
         Year=2000,
         CreatePgm=usgeos,
         Description=%nrbquote(Contains just the geographic ID fields as read from the Census Bureau <i>usgeo3_uf3</i> file.
We separated out the rows for geographic component summaries and stored those on the usgeocompgeos dataset. ),
        keyvars=SumLev state county  placefp msacmsa pmsa  ua       msacmsa  pmsa,
        keyfmats=sumlev state county fplace   metro metro  uauc2k   metro    pmsa,
        keyquals=|         |    |    state     |     |      |        |         |,
        keyidvars=,
        DataSource=%str(2000 Census, Summary File 3.),
        SortedBy=LogRecNo,
        UsageNotes=%nrbquote(<ul><li> We did not convert the data for all the geographic areas represented on this data set.  We might
in the future if user demand warrants it, but not now.
<li>We have no MCD level (SumLev code 060 - towns in New England) on any our table data sets (for example)
</ul>),
        SubType=geos,
        SetGroup=us,
        VarSet=,
        URLMeta=%str(http://mcdc2.missouri.edu/pub/data/sf32000/Tools/usgeos_reports.html),
        debug=0)



 %doset(mode=,libname=sf32000,
         memname=usgeocompgeos,
         memlabel=%nrbquote(Geographic variables only for all summaries involving a geographic component summary),
         geouniv=UnitedStates,
         units=Geographic Components,
         Year=2000,
         CreatePgm=usgeos,
         Description=%nrbquote(Contains just the geographic ID fields as read from the Census Bureau <i>usgeo3_uf3</i> file.
 We kept only the geographic component summaries on this dataset. ),
        keyvars=SumLev state geocomp,
        keyfmats=sumlev state geocomp,
        keyidvars=,
        DataSource=%str(2000 Census, Summary File 3.),
        SortedBy=LogRecNo,
        UsageNotes=%str(<ul><li>This is the singular version of this data set (see also the usgeocompsgeos data set).  This one has all
the potential geographic component summaries available from the Census Bureau.  But we do NOT HAVE DATA FOR ALL THESE COMPONENTS.  We
only converted data for state levels and above.  Those data are stored in the usgeocomps[ph|phct|pcctr] data sets.
</ul>),
        SubType=geos,
        SetGroup=us,
        VarSet=,
        URLMeta=%str(http://factfinder.census.gov/home/en/epss/geo_components_2.html),
        debug=0)


 %doset(mode=,libname=sf32000,
         memname=usplacesgeos,
         memlabel=%nrbquote(Geographic variables only for place level summaries),
         geouniv=UnitedStates,
         units=Places,
         Year=2000,
         CreatePgm=cnvtsf3us,
         Description=%nrbquote(Contains just the geographic ID fields as read from the Census Bureau <i>usgeo3_uf3</i> file.
 We kept only the place and place-within-county level data on this dataset. ),
        keyvars=SumLev state placefp,
        keyfmats=sumlev state fplace ,
        keyquals=%str(|   |   state),
        keyidvars=,
        DataSource=%str(2000 Census, Summary File 3.),
        SortedBy=LogRecNo,
        UsageNotes=%str(<ul><li>Table data stored separately.
</ul>),
        SubType=geos,
        SetGroup=us,
        VarSet=,
        URLMeta=,
        debug=0)


 %doset(mode=,libname=sf32000,
         memname=usregdivgeos,
         memlabel=%nrbquote(Geographic variables only for nation, region and division level summaries),
         geouniv=UnitedStates,
         units=Nation Region Division,
         Year=2000,
         CreatePgm=cnvtsf3us,
         Description=%nrbquote(Contains just the geographic ID fields as read from the Census Bureau <i>usgeo3_uf3</i> file.
 We kept only the nation totals, Census region and divsion level data on this dataset. ),
        keyvars=SumLev geocomp,
        keyfmats=sumlev geocomp,
        keyquals=%str(|   |   ),
        DataSource=%str(2000 Census, Summary File 3.),
        SortedBy=LogRecNo,
        UsageNotes=%str(<ul><li>Table data stored separately.
</ul>),
        SubType=geos,
        SetGroup=us,
        VarSet=,
        URLMeta=,
        debug=0)


 %doset(mode=,libname=sf32000,
         memname=usuasgeos,
         memlabel=%nrbquote(Geographic variables only for Urban Areas and UA-within-state level summaries),
         geouniv=UnitedStates,
         units=Urban Areas,
         Year=2000,
         CreatePgm=cnvtsf3us,
         Description=%nrbquote(Contains just the geographic ID fields as read from the Census Bureau <i>usgeo3_uf3</i> file.
 We kept only the complete UA (400) and UA-within-state (410) levels on this dataset. ),
        keyvars=SumLev ua state,
        keyfmats=sumlev uauc2k state,
        keyquals=%str(|   |     |  ),
        DataSource=%str(2000 Census, Summary File 3.),
        SortedBy=LogRecNo,
        UsageNotes=%str(<ul><li>Table data stored separately.
</ul>),
        SubType=geos,
        SetGroup=us,
        VarSet=,
        URLMeta=,
        debug=0)


 %doset(mode=,libname=sf32000,
         memname=uszipsgeos,
         memlabel=%nrbquote(Geographic variables only for ZIP/ZCTA 3- and 5-digit levels),
         geouniv=UnitedStates,
         units=%str(3-digit ZCTA, 5-digit ZCTA),
         Year=2000,
         CreatePgm=cnvtsf3us,
         Description=%nrbquote(Contains just the geographic ID fields as read from the Census Bureau <i>usgeo3_uf3</i> file.
 We kept only the complete 3-digit and 5-digit ZCTA levels on this dataset. ),
        keyvars=SumLev ,
        keyfmats=sumlev ,
        keyquals=%str(|  ),
        DataSource=%str(2000 Census, Summary File 3.),
        SortedBy=LogRecNo,
        UsageNotes=%str(<ul><li>Table data stored separately.
</ul>),
        SubType=geos,
        SetGroup=us,
        VarSet=,
        URLMeta=,
        debug=0)


  %doset(mode=,libname=sf32000,
          memname=moph,
          memlabel=%nrbquote(P and H tables for Missouri),
          geouniv=Missouri,
          units=%str(Many, down to BG),
          Year=2000,
          CreatePgm=cnvtsf3,
          Description=%nrbquote(Contains just the P and H tables for all MO geography levels down to Block Group),
         keyvars=SumLev geocomp county  placefp msacmsa pmsa ,
         keyfmats=sumlev geocomp county fplace   metro metro ,
         keyquals=|         |      |     state     |     |,
         keyidvars=,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(  ),
         SubType=ph,
         SetGroup=mo,
         VarSet=Variablesph,
         URLMeta=%str(http://mcdc2.missouri.edu/pub/data/sf32000/Varlabs/Plabels.txt),
         debug=0)

  %doset(mode=,libname=sf32000,
          memname=mophct,
          memlabel=%nrbquote(PCT and HCT tables for Missouri),
          geouniv=Missouri,
          units=%str(Many, down to Tract),
          Year=2000,
          CreatePgm=cnvtsf3,
          Description=%nrbquote(PCT and HCT tables (exc PCTr & HCTr) for all MO geography levels down to Tract),
         keyvars=SumLev geocomp county  placefp msacmsa pmsa ,
         keyfmats=sumlev geocomp county fplace   metro metro ,
         keyquals=|         |      |     state     |     |,
         keyidvars=,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(These more detailed CT tables are not published for levels below Census Tract),
         SubType=phct,
         SetGroup=mo,
         VarSet=Variablesphct,
         URLMeta=%str(http://mcdc2.missouri.edu/pub/data/sf32000/Varlabs/PCTlabels.txt),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=mophctr,
          memlabel=%nrbquote(PCT and HCT tables for Missouri),
          geouniv=Missouri,
          units=%str(Many, down to Tract),
          Year=2000,
          CreatePgm=cnvtsf3,
          Description=%nrbquote(PCT and HCT tables by Race & Hispanic for all MO geography levels down to Tract),
         keyvars=SumLev geocomp county  placefp msacmsa pmsa ,
         keyfmats=sumlev geocomp county fplace   metro metro ,
         keyquals=|         |      |     state     |     |,
         keyidvars=,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>These more detailed CT tables are not published for levels below Census Tract
    <li> These tables have an alpha suffix in their name which indicates the racial/ethnic universe for the table),
         SubType=phctr,
         SetGroup=mo,
         VarSet=Variablesphctr,
         URLMeta=%str(http://mcdc2.missouri.edu/pub/data/sf32000/Varlabs/PCTlabels.txt),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=mostcnty,
          memlabel=%nrbquote(All tables for Missouri State and County levels),
          geouniv=Missouri,
          units=%str(State County),
          Year=2000,
          CreatePgm=cnvtsf3,
          Description=%nrbquote(This data set combines all the tables in moph, mophct and mophctr into a single data set but
 only for the State and County level summaries),
         keyvars=SumLev  county,
         keyfmats=sumlev county,
         keyquals=|         |  ,
         keyidvars=,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>No geographic component summaries.
         <li> The usstcnty  data set has exactly the same data tables but for the entire country.
         </ul>),
         SubType=alltabs,
         SetGroup=mo,
         VarSet=Variables,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=moregns06ph,sortprio=2,
          memlabel=%nrbquote(P and H tables for Missouri county-based regions),
          geouniv=Missouri,
          units=%str(rpc dot ded aaa umx cbsa),
          Year=2000,
          CreatePgm=agg_moregns,
          Description=%nrbquote(Contains just the P and H tables),
         keyvars=SumLev cbsa aaa ded_region dot rpc umx2 ,
         keyfmats=sumlev cbsa aaa dedrgn modot rpcname umxname ,
         keyidvars=,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=sumlev geocode,
         UsageNotes=%nrbquote(  ),
         SubType=ph,
         SetGroup=mo,
         VarSet=Variablesph,
         URLMeta=%str(http://mcdc2.missouri.edu/pub/data/sf32000/Varlabs/Plabels.txt),
         debug=0)

  %doset(mode=,libname=sf32000,
          memname=moregns06phct,sortprio=2,
          memlabel=%nrbquote(PCT and HCT tables for Missouri),
          geouniv=Missouri,
          units=%str(rpc dot ded aaa umx cbsa),
          Year=2000,
          CreatePgm=agg_moregns,
          Description=%nrbquote(PCT and HCT tables (exc PCTr & HCTr) for all MO county-based Regions),
         keyvars=SumLev cbsa aaa  ded_region dot   rpc umx2 ,
         keyfmats=sumlev cbsa aaa dedrgn     modot rpcname umxname ,
         keyidvars=,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=sumlev geocode,
         SubType=phct,
         SetGroup=mo,
         VarSet=Variablesphct,
         URLMeta=%str(http://mcdc2.missouri.edu/pub/data/sf32000/Varlabs/PCTlabels.txt),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=moregns06phctr,sortprio=2,
          memlabel=%nrbquote(PCT and HCT tables with alpha suffixes for Missouri),
          geouniv=Missouri,
          units=%str(rpc dot ded aaa umx cbsa),
          Year=2000,
          CreatePgm=agg_moregns,
          Description=%nrbquote(PCT and HCT tables by Race & Hispanic for all MO county-based Regions),
         keyvars=SumLev cbsa aaa ded_region dot rpc umx2 ,
         keyfmats=sumlev cbsa aaa dedrgn modot rpcname umxname ,
         keyidvars=,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=sumlev geocode,
         UsageNotes=%nrbquote(<ul>
    <li> These tables have an alpha suffix in their name which indicates the racial/ethnic universe for the table </ul>),
         SubType=phctr,
         SetGroup=mo,
         VarSet=Variablesphctr,
         URLMeta=%str(http://mcdc2.missouri.edu/pub/data/sf32000/Varlabs/PCTlabels.txt),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=moregns06,sortprio=2,
          memlabel=%nrbquote(All tables for Missouri county-based Regions),
          geouniv=Missouri,
          units=%str(rpc dot ded aaa umx cbsa),
          Year=2000,
          CreatePgm=agg_moregns,
          Description=%nrbquote(This data set combines all the tables in moregns06ph, moregns06phct and moregns06phctr into a single data set),
         keyvars=SumLev cbsa aaa ded_region dot rpc umx2 ,
         keyfmats=sumlev cbsa aaa dedrgn modot rpcname umxname ,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=sumlev geocode,
         SubType=alltabs,
         SetGroup=mo,
         VarSet=Variables,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=usstcnty,
          memlabel=%nrbquote(All tables for United States at State and County levels),
          geouniv=United States,
          units=%str(State County),
          Year=2000,
          CreatePgm=cnvtsf3_usdata2,
          Description=%nrbquote(U.S. state and county level summaries),
         keyvars=SumLev  state county,
         keyfmats=sumlev state county,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>No geographic component summaries.
         <li> The mostcnty  data set has exactly the same data tables but for the state of Missouri only.
         </ul>),
         SubType=alltabs,
         SetGroup=us,
         VarSet=Variables,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=usregdiv,
          memlabel=%nrbquote(All tables for United States (totals), Regions and Divisions),
          geouniv=United States,
          units=%str(Nation Region Division),
          Year=2000,
          CreatePgm=cnvtsf3_usdata2,
          Description=%nrbquote(U.S. state and county level summaries),
         keyvars=SumLev  geocomp,
         keyfmats=sumlev geocomp,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>Includes geographic component summaries.  Use a filter of
 <code>geocomp   Equals  00</code> to filter out the components.  What will be left is only 14 summaries
 (1 nation, 4 regions and 9 divisions)
         </ul>),
         SubType=alltabs,
         SetGroup=us,
         VarSet=Variables,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)



  %doset(mode=,libname=sf32000,
          memname=usuas,
          memlabel=%nrbquote(All tables for United States Urban Areas),
          geouniv=United States,
          units=%str(Urban Areas),
          Year=2000,
          CreatePgm=cnvtsf3_usdata2,
          Description=%nrbquote(U.S. UAs - Urbanized Areas and Urban Clusters - total and within-state portion summaries),
         keyvars=SumLev  ua     state ,
         keyfmats=sumlev uauc2k state,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>Use the UAtype variables (value C and U) to disinguish between the smaller Urban Clusters and
larger Urbanized Areas
  <li>On level 410 summaries (state portions of UAs) AreaName will consist of the state name followed by "(part)".  So if you wanted to
pull all the UA portions for a state you would not have any variable containing the name of the UA.  You can get around this by using a
format code so that the UA variable is displayed/saved as the name. In Dexter section V-c., in the Format text box, code '
<code>ua $uauc2k40. </code> to specify that you want the UA variable (which contains a 5-digit code) to display as the name of the UA in
stead of the code value.
         <li>SumLev 400 is complete UAs, while SumLev 410 contains the state portion of the UA.  Most UAs are entirely within a state so
 that their are 2 observations with identical tabular data.  The state code is blank on all 400-level summaries, even if the UA is
 entirely within a state.
         </ul>),
         SubType=alltabs,
         SetGroup=us,
         VarSet=Variables,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)



  %doset(mode=,libname=sf32000,
          memname=usplacesph,
          memlabel=%nrbquote(P and H tables for United States for United States at Place and Place-within-county levels),
          geouniv=United States,
          units=%str(Place Place/County),
          Year=2000,
          CreatePgm=cnvtsf3,
          Description=%nrbquote(U.S. place (city) and place-within county level summaries),
         keyvars=SumLev  state county  placefp,
         keyfmats=sumlev state county  place,
         keyquals= |      |     |      state,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>These places are not restricted by population size.  Small towns are included.
         <li>Companion data sets are usplacesgeos, usplacesphct and usplacesphctr.
         </ul>),
         SubType=ph,
         SetGroup=usplaces,
         VarSet=Variablesph,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=usplacesphct,
          memlabel=%nrbquote(PCT and HCT tables for United States for United States at Place and Place-within-county levels),
          geouniv=United States,
          units=%str(Place Place/County),
          Year=2000,
          CreatePgm=cnvtsf3,
          Description=%nrbquote(U.S. place (city) and place-within county level summaries),
         keyvars=SumLev  state county  placefp,
         keyfmats=sumlev state county  place,
         keyquals= |      |     |      state,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>Places are not restricted by any population size.
         </ul>),
         SubType=phct,
         SetGroup=usplaces,
         VarSet=Variablesphct,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=usplacesphctr,
          memlabel=%nrbquote(PCT(r) and HCT(r) tables for United States for United States at Place and Place-within-county levels),
          geouniv=United States,
          units=%str(Place Place/County),
          Year=2000,
          CreatePgm=cnvtsf3,
          Description=%nrbquote(U.S. place (city) and place-within county level summaries),
         keyvars=SumLev  state county  placefp,
         keyfmats=sumlev state county  place,
         keyquals= |      |     |      state,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>Places are not restricted by any population size.
         </ul>),
         SubType=phctr,
         SetGroup=usplaces,
         VarSet=Variablesphctr,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=uspumasph,
          memlabel=%nrbquote(P and H tables for PUMAs for United States),
          geouniv=United States,
          units=PUMA,
          Year=2000,
          CreatePgm=agg_uspumas,
          Description=%nrbquote(Pulbic Use Microsample Area summaries (the 5% sample versions) aggregated/estimated by MCDC),
         keyvars=State,
         keyfmats=state,
         keyquals= |  ,
         DataSource=%str(2000 Census, Summary File 3, with aggregation by MCDC.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>These are aggregated estimates created by the Missouri Census Data Center.
  <li>The Census Bureau did not publish SF3 tables aggregated for these units.
  <li>Aggregation was done from data at the split-block group (code 090) level, using an equivalency file created by MABLE/Geocorr2k.  T
he amount of disaggregating (i.e. apportioning of data in cases where a split-BG crossed a PUMA boundary) was almost never required.
  <li>We currently have no CT tables (PCT and HCT) tables at this level.  That is mostly because there was no BG level data for those
tables and we did not want to estimate using tract level data.  But we might change our mind some day.
         </ul>),
         SubType=ph,
         SetGroup=us,
         VarSet=Variablesph,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)



  %doset(mode=,libname=sf32000,
          memname=uszipsph,
          memlabel=%nrbquote(P and H tables for United States for United States at 3 and 5-digit ZCTA levels),
          geouniv=United States,
          units=%str(ZCTA, 3-digt ZCTA),
          Year=2000,
          CreatePgm=cnvtsf3,
          Description=%nrbquote(U.S. ZCTA (ZIP) and 3-digit ZCTA level summaries: P and H tables),
         keyvars=SumLev  state,
         keyfmats=sumlev state,
         keyquals=%str( |      |)  ,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>ZCTAs are the Census Bureaus approximation of USPS ZIP code areas designed specifically as
 areas for tabulating census data.
         <li>Pseudo-ZIPx with XX and HH as last 2 digits represent areas not assigned a ZIP code and water portion of ZIP areas.
         <li>Companion data sets are uszipsgeos, uszipsphct and uszipsphctr.
         </ul>),
         SubType=ph,
         SetGroup=uszips,
         VarSet=Variablesph,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=uszipsphct,
          memlabel=%nrbquote(PCT and HCT tables for United States for United States at 3 and 5-digit ZCTA levels),
          geouniv=United States,
          units=%str(ZCTA, 3-digt ZCTA),
          Year=2000,
          CreatePgm=cnvtsf3,
          Description=%nrbquote(U.S. ZCTA (ZIP) and 3-digit ZCTA level summaries: PCT and HCT tables),
         keyvars=SumLev  state,
         keyfmats=sumlev state,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>ZCTAs are the Census Bureaus approximation of USPS ZIP code areas designed specifically as
 areas for tabulating census data.
         <li>Pseudo-ZIPx with XX and HH as last 2 digits represent areas not assigned a ZIP code and water portion of ZIP areas.
         <li>Companion data sets are uszipsgeos, uszipsph and uszipsphctr.
         </ul>),
         SubType=phct,
         SetGroup=uszips,
         VarSet=Variablesphct,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=uszipsphctr,
          memlabel=%nrbquote(PCT(r) and HCT(r) tables for United States for United States at 3 and 5-digit ZCTA levels),
          geouniv=United States,
          units=%str(ZCTA, 3-digt ZCTA),
          Year=2000,
          CreatePgm=cnvtsf3,
          Description=%nrbquote(U.S. ZCTA (ZIP) and 3-digit ZCTA level summaries: PCT(r) and HCT(r) tables),
         keyvars=SumLev  state,
         keyfmats=sumlev state,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>ZCTAs are the Census Bureaus approximation of USPS ZIP code areas designed specifically as
 areas for tabulating census data.
         <li>Pseudo-ZIPx with XX and HH as last 2 digits represent areas not assigned a ZIP code and water portion of ZIP areas.
         <li>Companion data sets are uszipsgeos, uszipsph and uszipsphct.
         </ul>),
         SubType=phctr,
         SetGroup=uszips,
         VarSet=Variablesphctr,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  /* =======================Begin comment================

  %doset(mode=,libname=sf32000,
         memname=usgeocompsgeos,
         memlabel=%nrbquote(Geographic variables only for selected summaries involving a geographic component summary at a level of state
or higher),
         geouniv=UnitedStates,
         units=Geographic Components,
         Year=2000,
         CreatePgm=cnvtsf3us,
         Description=%nrbquote(Contains just the geographic ID fields as read from the Census Bureau <i>usgeo3_uf3</i> file for selected
geographic summary levels (nation, region, division and state).),
        keyvars=SumLev state geocomp,
        keyfmats=sumlev state geocomp,
        keyidvars=,
        DataSource=%str(2000 Census, Summary File 3.),
        SortedBy=LogRecNo,
        UsageNotes=%str(<ul><li>This is the plural version of this data set (see also the usgeocompgeos data set).
 This one has only a small subset of
the potential geographic component summaries available from the Census Bureau.  We do have sf3 data tables for the components
on this dataset/ Those data are stored in the usgeocomps[ph|phct|pcctr] data sets.
</ul>),
        SubType=geos,
        SetGroup=us,
        VarSet=,
        URLMeta=%str(http://factfinder.census.gov/home/en/epss/geo_components_2.html),
        debug=0)

  %doset(mode=,libname=sf32000,
          memname=usgeocompsph,
          memlabel=%nrbquote(P, H tables for United States geographic component summaries at state, region and nation levels),
          geouniv=United States,
          units=%str(Geographic Components),
          Year=2000,
          CreatePgm=cnvtsf3us,
          Description=%nrbquote(P and H tables for geographic components of the state, region and nation levels),
         keyvars=SumLev  geocomp state,
         keyfmats=sumlev geocomp state,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%str(<ul><l>Only geographic component summaries.
 <li>The usgeocompgeos data set shows all the many tens of thousands of geocomp summaries are possible. But for the sake of disk space
we only keep them for the most common geographies. If you need a geographic component table for some other unit of geography you will
 need to use American Factfinder.
 <li> If you need CT table data for these geographic components you will need the corresponding phct or phctr data sets.
 </ul>),
         SubType=phtabs,
         SetGroup=us,
         VarSet=Variablesph,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)

%doset(mode=,libname=sf32000,
          memname=usgeocompsphct,
          memlabel=%nrbquote(PCT and  HCT tables for United States geographic component summaries at state, region and nation levels),
          geouniv=United States,
          units=%str(Geographic Components),
          Year=2000,
          CreatePgm=cnvtsf3us,
          Description=%nrbquote(PCT and HCT tables for geographic components of the state, region and nation levels),
         keyvars=SumLev  geocomp state,
         keyfmats=sumlev geocomp state,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%str(<ul><l>Only geographic component summaries.
 <li>The usgeocompgeos data set shows all the many tens of thousands of geocomp summaries are possible. But for the sake of disk space
we only keep them for the most common geographies. If you need a geographic component table for some other unit of geography you will
 need to use American Factfinder.
 <li> If you need P or H table data for these geographic components you will need the corresponding ph data set. If you need one of the
race-specific PCTr or HCTr tables then you need the corresponding phctr data set.
 </ul>),
         SubType=phcttabs,
         SetGroup=us,
         VarSet=Variablesphct,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)

%doset(mode=,libname=sf32000,
          memname=usgeocompsphctr,
          memlabel=%nrbquote(PCTr and  HCTr tables for United States geographic component summaries at state, region and nation levels),
          geouniv=United States,
          units=%str(Geographic Components),
          Year=2000,
          CreatePgm=cnvtsf3us,
          Description=%nrbquote(PCTr and HCTr (race/origin specific) tables for geographic components of the state, region and nation levels),
         keyvars=SumLev  geocomp state,
         keyfmats=sumlev geocomp state,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%str(<ul><l>Only geographic component summaries.
 <li>The usgeocompgeos data set shows all the many tens of thousands of geocomp summaries are possible. But for the sake of disk space
we only keep them for the most common geographies. If you need a geographic component table for some other unit of geography you will
 need to use American Factfinder.
 <li> If you need P or H table data for these geographic components you will need the corresponding ph data set. If you need one of the
non race-specific PCT or HCT tables then you need the corresponding phct data set.
 </ul>),
         SubType=phctrtabs,
         SetGroup=us,
         VarSet=Variablesphctr,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)



   %doset(mode=,libname=sf32000,
          memname=uscousubsph,
          memlabel=%nrbquote(P and H tables for United States for United States at County subdivision (MCD/CCD) level),
          geouniv=United States,
          units=%str(County Subdivisions/Towns),
          Year=2000,
          CreatePgm=cnvtsf3us,
          Description=%nrbquote(County subdivision (MCD/CCD) summaries: P and H tables),
         keyvars=Sumlev state county ,
         keyfmats=Sumlev state county ,
         keyquals=%str( |      |)  ,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>County subdivisions vary in terms of importance and naming terminology by state.
         <li>These are most important in New England and the Middle Atlantic states (NY, PA) where they are known as towns and are
functioning governmental units.  These are referred to as Minor Civil Divisions (MCDs).
         <li>In Missouri these are known as townships, and are used for voting jurisdictions.  But they are functioning governmental units
 in a few counties in the rural west central portion of the state.
         <li>Companion data sets are uscousubsgeos, uscousubsphct and uscousubsphctr.
         </ul>),
         SubType=ph,
         SetGroup=uscousubs,
         VarSet=Variablesph,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=uscousubsphct,
          memlabel=%nrbquote(PCT and HCT tables for United States for United States at County subdivision (MCD/CCD) level),
          geouniv=United States,
          units=%str(County Subdivisions/Towns),
          Year=2000,
          CreatePgm=cnvtsf3us,
          Description=%nrbquote(County subdivision (MCD/CCD) summaries:  PCT and HCT tables),
         keyvars=Sumlev state county ,
         keyfmats=Sumlev state county ,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>County subdivisions vary in terms of importance and naming terminology by state.
         <li>These are most important in New England and the Middle Atlantic states (NY, PA) where they are known as towns and are
functioning governmental units.  These are referred to as Minor Civil Divisions (MCDs).
         <li>In Missouri these are known as townships, and are used for voting jurisdictions.  But they are functioning governmental units
 in a few counties in the rural west central portion of the state.
         <li>Companion data sets are uscousubsgeos, uscousubsph and uscousubsphctr.
         </ul>),
         SubType=phct,
         SetGroup=uscousubs,
         VarSet=Variablesphct,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=uscousubsphctr,
          memlabel=%nrbquote(PCT(r) and HCT(r) tables for United States for United States at County subdivision (MCD/CCD) level),
          geouniv=United States,
          units=%str(County Subdivisions/Towns),
          Year=2000,
          CreatePgm=cnvtsf3us,
          Description=%nrbquote(County subdivision (MCD/CCD) summaries:  PCT(r) and HCT(r) tables),
         keyvars=Sumlev state county ,
         keyfmats=Sumlev state county ,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>County subdivisions vary in terms of importance and naming terminology by state.
         <li>These are most important in New England and the Middle Atlantic states (NY, PA) where they are known as towns and are
functioning governmental units.  These are referred to as Minor Civil Divisions (MCDs).
         <li>In Missouri these are known as townships, and are used for voting jurisdictions.  But they are functioning governmental units
 in a few counties in the rural west central portion of the state.
         <li>Companion data sets are uscousubsgeos, uscousubsph and uscousubsphct.
         </ul>),
         SubType=phctr,
         SetGroup=uscousubs,
         VarSet=Variablesphctr,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)
    ======================End comment================== */


%doset(mode=,libname=sf32000,
          memname=usmetrosph,
          memlabel=%nrbquote(P and H tables for United States for United States at Metro Area level),
          geouniv=United States,
          units=%str(Metro Areas),
          Year=2000,
          CreatePgm=cnvtsf3us,
          Description=%nrbquote(Metro Area summaries: P and H tables),
         keyvars=sumlev state msacmsa,
         keyfmats=sumlev state metro,
         keyquals=%str( |      |)  ,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>These are the metro area definitions in effect at the time of the 2k census (pre-CBSA). 
         <li>Includes summaries for MSAs, CMSAs, NECMAs (in New England only) and PMSAs, as well as the state portions of each.
         <li>Companion data sets are usmetrosgeos, usmetrosphct and usmetrosphctr.
         </ul>),
         SubType=ph,
         SetGroup=usmetros,
         VarSet=Variablesph,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=usmetrosphct,
          memlabel=%nrbquote(PCT and HCT tables for United States for United States at Metro Area level),
          geouniv=United States,
          units=%str(Metro Areas),
          Year=2000,
          CreatePgm=cnvtsf3us,
          Description=%nrbquote(Metro Area summaries:  PCT and HCT tables),
         keyvars=sumlev state msacmsa,
         keyfmats=sumlev state msacmsa,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>These are the metro area definitions in effect at the time of the 2k census (pre-CBSA). 
         <li>Includes summaries for MSAs, CMSAs, NECMAs (in New England only) and PMSAs, as well as the state portions of each.
         <li>Companion data sets are usmetrosgeos, usmetrosphct and usmetrosphctr.
         </ul>),
         SubType=phct,
         SetGroup=usmetros,
         VarSet=Variablesphct,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=usmetrosphctr,
          memlabel=%nrbquote(PCT(r) and HCT(r) tables for United States for United States at Metro Area level),
          geouniv=United States,
          units=%str(Metro Areas),
          Year=2000,
          CreatePgm=cnvtsf3us,
          Description=%nrbquote(Metro Area summaries:  PCT(r) and HCT(r) tables),
         keyvars=sumlev state msacmsa,
         keyfmats=sumlev state msacmsa,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>These are the metro area definitions in effect at the time of the 2k census (pre-CBSA). 
         <li>Includes summaries for MSAs, CMSAs, NECMAs (in New England only) and PMSAs, as well as the state portions of each.
         <li>Companion data sets are usmetrosgeos, usmetrosphct and usmetrosphctr.
         </ul>),
         SubType=phctr,
         SetGroup=usmetros,
         VarSet=Variablesphctr,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=uscds106ph,
          memlabel=%nrbquote(P and H tables for United States for United States for Congressional Districts (106th)),
          geouniv=United States,
          units=%str(cd106),
          Year=2000,
          CreatePgm=cnvtsf3us,
          Description=%nrbquote(Congressional District (106th) summaries: P and H tables),
         keyvars=sumlev state,
         keyfmats=sumlev state,
         keyquals=%str( |      |)  ,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>These are for the 106th Congressional Districts as defined at the time of the 2k census (elected in 1998). 
         <li>Companion data sets are uscds106geos, uscds106phct and uscds106phctr.
</ul>),
         SubType=ph,
         SetGroup=uscd106,
         VarSet=Variablesph,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=uscds106phct,
          memlabel=%nrbquote(PCT and HCT tables for United States for United States for Congressional Districts (106th)),
          geouniv=United States,
          units=%str(cd106 Areas),
          Year=2000,
          CreatePgm=cnvtsf3us,
          Description=%nrbquote(Congressional District (106th) summaries:  PCT and HCT tables),
         keyvars=sumlev state,
         keyfmats=sumlev state,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>These are for the 106th Congressional Districts as defined at the time of the 2k census (elected in 1998). 
          <li>Companion data sets are uscds106geos, uscds106ph and uscds106phctr.
</ul>),
         SubType=phct,
         SetGroup=uscd106,
         VarSet=Variablesphct,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=uscds106phctr,
          memlabel=%nrbquote(PCT(r) and HCT(r) tables for United States for United States for Congressional Districts (106th)),
          geouniv=United States,
          units=%str(cd106 Areas),
          Year=2000,
          CreatePgm=cnvtsf3us,
          Description=%nrbquote(Congressional District (106th) summaries:  PCT(r) and HCT(r) tables),
         keyvars=sumlev state,
         keyfmats=sumlev state,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>These are for the 106th Congressional Districts as defined at the time of the 2k census (elected in 1998). 
         <li>Companion data sets are uscds106geos, uscds106ph and uscds106phct.
</ul>),
         SubType=phctr,
         SetGroup=uscd106,
         VarSet=Variablesphctr,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)

   %doset(mode=,libname=sf32000,
          memname=usuasph,
          memlabel=%nrbquote(P and H tables for United States for United States for Urbanized Areas),
          geouniv=United States,
          units=%str(Urbanized Areas),
          Year=2000,
          CreatePgm=cnvtsf3us,
          Description=%nrbquote(Urbanized Area summaries: P and H tables),
         keyvars=sumlev state ua,
         keyfmats=sumlev state urbarea,
         keyquals=%str( |      |)  ,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>These are for the Urbanized Areas as defined at the time of the 2k census . 
         </ul>),
         SubType=ph,
         SetGroup=usua,
         VarSet=Variablesph,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=usuasphct,
          memlabel=%nrbquote(PCT and HCT tables for United States for United States for Urbanized Areas),
          geouniv=United States,
          units=%str(Urbanized Areas),
          Year=2000,
          CreatePgm=cnvtsf3us,
          Description=%nrbquote(Urbanized Area summaries:  PCT and HCT tables),
         keyvars=sumlev state ua,
         keyfmats=sumlev state urbarea,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>These are for the Urbanized Areas as defined at the time of the 2k census . 
          </ul>),
         SubType=phct,
         SetGroup=usua,
         VarSet=Variablesphct,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)


  %doset(mode=,libname=sf32000,
          memname=usuasphctr,
          memlabel=%nrbquote(PCT(r) and HCT(r) tables for United States for United States for Urbanized Areas),
          geouniv=United States,
          units=%str(Urbanized Areas),
          Year=2000,
          CreatePgm=cnvtsf3us,
          Description=%nrbquote(Urbanized Area summaries:  PCT(r) and HCT(r) tables),
         keyvars=sumlev state ua,
         keyfmats=sumlev state urbarea,
         DataSource=%str(2000 Census, Summary File 3.),
         SortedBy=LogRecNo,
         UsageNotes=%nrbquote(<ul><li>These are for the Urbanized Areas as defined at the time of the 2k census . 
         </ul>),
         SubType=phctr,
         SetGroup=usua,
         VarSet=Variablesphctr,
         URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
         debug=0)

   

   proc sort data=sf32000.datasets out=bysortprio;
     by SortPrio GeoUniv SetGroup SubType Memname ;   run;

   proc datasets library=sf32000 nolist;
      modify datasets;
      index delete dataset memname;
      index create  dataset=(libname memname) / unique;
      index create memname;
      quit;

       

    options mprint msglevel=i;
     %gendshtm(libname=sf32000,debug=0,runprocc=1);


     %include sascode(notify);