1                                                          The SAS System                               10:43 Tuesday, June 23, 2009

NOTE: Unable to open SASUSER.REGSTRY. WORK.REGSTRY will be opened instead.
NOTE: All registry changes will be lost at the end of the session.

WARNING: Unable to copy SASUSER registry to WORK registry. Because of this, you will not see registry customizations during this 
         session.
NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA. 
NOTE: SAS (r) 9.1 (TS1M3)
      Licensed to THE CURATORS OF THE UNIV OF MISSOURI - T&R, Site 0001242018.
NOTE: This session is executing on the AIX 5.2 platform.



NOTE: SAS 9.1.3 Service Pack 4

NOTE: SAS initialization used:
      real time           0.28 seconds
      cpu time            0.10 seconds
      

NOTE: AUTOEXEC processing beginning; file is /home/john/autoexec.sas.

v8= 0  v9= 1 *****
****** Standard OSEDA/MCDC autoexec (autoexec9.sas in sascode) rev. 12/28/2004 3:06PM - Begin execution *******
_v9= v9
Standard filerefs and librefs assigned *****
NOTE: Libref SF32000X was successfully assigned as follows: 
      Levels:           1
      Engine(1):        V9 
      Physical Name(1): /pub/data/sf32000x
NOTE: Libref SF3X was successfully assigned as follows: 
      Levels:           1
      Engine(1):        V9 
      Physical Name(1): /pub/data/sf32000x
NOTE: Libref INDCTRS was successfully assigned as follows: 
      Levels:           1
      Engine(1):        V9 
      Physical Name(1): /pub/data/indctrs
NOTE: Libname LIBRARY refers to the same physical library as SASCTLGS.
NOTE: Libref LIBRARY was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: /pub/sasctlgs/v9
****Finished with generic autoexec ****


***
****Executing my private autoexec.sas file, rev. 02/28/2006 7:40AM
WARNING: Library MAPS is not assigned in this scope.
WARNING: Library GISMAPS is not assigned in this scope.
***** dmsflag= NODMS
dmchk execution begins ***
**Begin execution on  Tuesday 23JUN09 at 10:43 PID=491662

NOTE: AUTOEXEC processing completed.

1           x cd /pub/data/sf32000/Tools
1        !                              ;   %let pgm=invoke_dosets;  filename pgm "&pgm..sas";
2                                                          The SAS System                               10:43 Tuesday, June 23, 2009

2           /*--Invoke the %doset macro to create observations in the Datasets dataset for this directory.
3               J. Blodgett, OSEDA, Apr., 2009  (this is the "do-over" version created after we lost our data and had
4                to restore and/or reconvert it, spring, 2009.
5            -- */
6             title "Job to Invoke doset Macro for Sets in sf32000, creating sf32000.datasets";
7          
8          
9            libname sf32000 '/pub/data/sf32000';
NOTE: Libref SF32000 was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: /pub/data/sf32000
10         
11           *-----Run this step ONLY ONCE------------------------------------------;
12           *----If you need to rerun (start over) then delete the datasets dataset first.  doset will not
13                allow initialize mode if the datasets set already exists.---;
14           %***doset(mode=initialize,
15                  libname=sf32000,debug=0);
16           *----------------------------------------------------------------------;
17         
18            %global todo;
19         
20            %*let todo=uspumas;
21            %**let todo=mozips ilzips;
22            %*let todo=moregns06ph morgns06phct moregns06phctr moregns06;
23            %*let todo=usgeocompgeos usgeocompsgeos usgeocompsph usgeocompsphct usgeocompsphctr
24                      uscousubsgeo uscousubsph uscousubsphct uscousubsphctr;
25            %let todo= usuasph usuasphct usuasphctr
26                      usmetrosph usmetrosphct usmetrosphctr
27                      uscds106ph uscds106phct uscds106phctr;
28           %let statenm=Missouri;
29         
30           /* =======================Begin comment================
31          *==============================1-time Fix run to delete obsolete contents-only observations from datasets----;
32          data sf32000.datasets_edited;  set sf32000.datasets;
33            where libname ne " ";
34            run;
35          *---ran this step (above) from DM.  After which we deleted the old datasets data set and renamed datasets_edited to
35       ! datasets.---;
36          proc datasets library=sf32000 nolist;
37               modify datasets;
38               index delete dataset memname;
39               index create  dataset=(libname memname) / unique;
40               index create memname;
41               quit;
42              ======================End comment================== */
43         
44          %doset(mode=,libname=sf32000,
45                  memname=usgeos,
46                  memlabel=%nrbquote(Geographic variables only for all available U.S. summaries),
47                  geouniv=UnitedStates,
48                  units=Too many to list,
49                  Year=2000,
50                  CreatePgm=usgeos,
51                  Description=%nrbquote(Contains just the geographic ID fields as read from the Census Bureau <i>usgeo3_uf3</i>
51       ! file.
52         We separated out the rows for geographic component summaries and stored those on the usgeocompgeos dataset. ),
3                                                          The SAS System                               10:43 Tuesday, June 23, 2009

53                 keyvars=SumLev state county  placefp msacmsa pmsa  ua       msacmsa  pmsa,
54                 keyfmats=sumlev state county fplace   metro metro  uauc2k   metro    pmsa,
55                 keyquals=|         |    |    state     |     |      |        |         |,
56                 keyidvars=,
57                 DataSource=%str(2000 Census, Summary File 3.),
58                 SortedBy=LogRecNo,
59                 UsageNotes=%nrbquote(<ul><li> We did not convert the data for all the geographic areas represented on this data
59       ! set.  We might
60         in the future if user demand warrants it, but not now.
61         <li>We have no MCD level (SumLev code 060 - towns in New England) on any our table data sets (for example)
62         </ul>),
63                 SubType=geos,
64                 SetGroup=us,
65                 VarSet=,
66                 URLMeta=%str(http://mcdc2.missouri.edu/pub/data/sf32000/Tools/usgeos_reports.html),
67                 debug=0)
***Not executed because usgeos is not on todo list***
68         
69         
70         
71          %doset(mode=,libname=sf32000,
72                  memname=usgeocompgeos,
73                  memlabel=%nrbquote(Geographic variables only for all summaries involving a geographic component summary),
74                  geouniv=UnitedStates,
75                  units=Geographic Components,
76                  Year=2000,
77                  CreatePgm=usgeos,
78                  Description=%nrbquote(Contains just the geographic ID fields as read from the Census Bureau <i>usgeo3_uf3</i>
78       ! file.
79          We kept only the geographic component summaries on this dataset. ),
80                 keyvars=SumLev state geocomp,
81                 keyfmats=sumlev state geocomp,
82                 keyidvars=,
83                 DataSource=%str(2000 Census, Summary File 3.),
84                 SortedBy=LogRecNo,
85                 UsageNotes=%str(<ul><li>This is the singular version of this data set (see also the usgeocompsgeos data set).
85       ! This one has all
86         the potential geographic component summaries available from the Census Bureau.  But we do NOT HAVE DATA FOR ALL THESE
86       ! COMPONENTS.  We
87         only converted data for state levels and above.  Those data are stored in the usgeocomps[ph|phct|pcctr] data sets.
88         </ul>),
89                 SubType=geos,
90                 SetGroup=us,
91                 VarSet=,
92                 URLMeta=%str(http://factfinder.census.gov/home/en/epss/geo_components_2.html),
93                 debug=0)
***Not executed because usgeocompgeos is not on todo list***
94         
95         
96          %doset(mode=,libname=sf32000,
97                  memname=usplacesgeos,
98                  memlabel=%nrbquote(Geographic variables only for place level summaries),
99                  geouniv=UnitedStates,
100                 units=Places,
101                 Year=2000,
102                 CreatePgm=cnvtsf3us,
4                                                          The SAS System                               10:43 Tuesday, June 23, 2009

103                 Description=%nrbquote(Contains just the geographic ID fields as read from the Census Bureau <i>usgeo3_uf3</i>
103      ! file.
104         We kept only the place and place-within-county level data on this dataset. ),
105                keyvars=SumLev state placefp,
106                keyfmats=sumlev state fplace ,
107                keyquals=%str(|   |   state),
108                keyidvars=,
109                DataSource=%str(2000 Census, Summary File 3.),
110                SortedBy=LogRecNo,
111                UsageNotes=%str(<ul><li>Table data stored separately.
112        </ul>),
113                SubType=geos,
114                SetGroup=us,
115                VarSet=,
116                URLMeta=,
117                debug=0)
***Not executed because usplacesgeos is not on todo list***
118        
119        
120         %doset(mode=,libname=sf32000,
121                 memname=usregdivgeos,
122                 memlabel=%nrbquote(Geographic variables only for nation, region and division level summaries),
123                 geouniv=UnitedStates,
124                 units=Nation Region Division,
125                 Year=2000,
126                 CreatePgm=cnvtsf3us,
127                 Description=%nrbquote(Contains just the geographic ID fields as read from the Census Bureau <i>usgeo3_uf3</i>
127      ! file.
128         We kept only the nation totals, Census region and divsion level data on this dataset. ),
129                keyvars=SumLev geocomp,
130                keyfmats=sumlev geocomp,
131                keyquals=%str(|   |   ),
132                DataSource=%str(2000 Census, Summary File 3.),
133                SortedBy=LogRecNo,
134                UsageNotes=%str(<ul><li>Table data stored separately.
135        </ul>),
136                SubType=geos,
137                SetGroup=us,
138                VarSet=,
139                URLMeta=,
140                debug=0)
***Not executed because usregdivgeos is not on todo list***
141        
142        
143         %doset(mode=,libname=sf32000,
144                 memname=usuasgeos,
145                 memlabel=%nrbquote(Geographic variables only for Urban Areas and UA-within-state level summaries),
146                 geouniv=UnitedStates,
147                 units=Urban Areas,
148                 Year=2000,
149                 CreatePgm=cnvtsf3us,
150                 Description=%nrbquote(Contains just the geographic ID fields as read from the Census Bureau <i>usgeo3_uf3</i>
150      ! file.
151         We kept only the complete UA (400) and UA-within-state (410) levels on this dataset. ),
152                keyvars=SumLev ua state,
153                keyfmats=sumlev uauc2k state,
5                                                          The SAS System                               10:43 Tuesday, June 23, 2009

154                keyquals=%str(|   |     |  ),
155                DataSource=%str(2000 Census, Summary File 3.),
156                SortedBy=LogRecNo,
157                UsageNotes=%str(<ul><li>Table data stored separately.
158        </ul>),
159                SubType=geos,
160                SetGroup=us,
161                VarSet=,
162                URLMeta=,
163                debug=0)
***Not executed because usuasgeos is not on todo list***
164        
165        
166         %doset(mode=,libname=sf32000,
167                 memname=uszipsgeos,
168                 memlabel=%nrbquote(Geographic variables only for ZIP/ZCTA 3- and 5-digit levels),
169                 geouniv=UnitedStates,
170                 units=%str(3-digit ZCTA, 5-digit ZCTA),
171                 Year=2000,
172                 CreatePgm=cnvtsf3us,
173                 Description=%nrbquote(Contains just the geographic ID fields as read from the Census Bureau <i>usgeo3_uf3</i>
173      ! file.
174         We kept only the complete 3-digit and 5-digit ZCTA levels on this dataset. ),
175                keyvars=SumLev ,
176                keyfmats=sumlev ,
177                keyquals=%str(|  ),
178                DataSource=%str(2000 Census, Summary File 3.),
179                SortedBy=LogRecNo,
180                UsageNotes=%str(<ul><li>Table data stored separately.
181        </ul>),
182                SubType=geos,
183                SetGroup=us,
184                VarSet=,
185                URLMeta=,
186                debug=0)
***Not executed because uszipsgeos is not on todo list***
187        
188        
189          %doset(mode=,libname=sf32000,
190                  memname=moph,
191                  memlabel=%nrbquote(P and H tables for Missouri),
192                  geouniv=Missouri,
193                  units=%str(Many, down to BG),
194                  Year=2000,
195                  CreatePgm=cnvtsf3,
196                  Description=%nrbquote(Contains just the P and H tables for all MO geography levels down to Block Group),
197                 keyvars=SumLev geocomp county  placefp msacmsa pmsa ,
198                 keyfmats=sumlev geocomp county fplace   metro metro ,
199                 keyquals=|         |      |     state     |     |,
200                 keyidvars=,
201                 DataSource=%str(2000 Census, Summary File 3.),
202                 SortedBy=LogRecNo,
203                 UsageNotes=%nrbquote(  ),
204                 SubType=ph,
205                 SetGroup=mo,
206                 VarSet=Variablesph,
6                                                          The SAS System                               10:43 Tuesday, June 23, 2009

207                 URLMeta=%str(http://mcdc2.missouri.edu/pub/data/sf32000/Varlabs/Plabels.txt),
208                 debug=0)
***Not executed because moph is not on todo list***
209        
210          %doset(mode=,libname=sf32000,
211                  memname=mophct,
212                  memlabel=%nrbquote(PCT and HCT tables for Missouri),
213                  geouniv=Missouri,
214                  units=%str(Many, down to Tract),
215                  Year=2000,
216                  CreatePgm=cnvtsf3,
217                  Description=%nrbquote(PCT and HCT tables (exc PCTr & HCTr) for all MO geography levels down to Tract),
218                 keyvars=SumLev geocomp county  placefp msacmsa pmsa ,
219                 keyfmats=sumlev geocomp county fplace   metro metro ,
220                 keyquals=|         |      |     state     |     |,
221                 keyidvars=,
222                 DataSource=%str(2000 Census, Summary File 3.),
223                 SortedBy=LogRecNo,
224                 UsageNotes=%nrbquote(These more detailed CT tables are not published for levels below Census Tract),
225                 SubType=phct,
226                 SetGroup=mo,
227                 VarSet=Variablesphct,
228                 URLMeta=%str(http://mcdc2.missouri.edu/pub/data/sf32000/Varlabs/PCTlabels.txt),
229                 debug=0)
***Not executed because mophct is not on todo list***
230        
231        
232          %doset(mode=,libname=sf32000,
233                  memname=mophctr,
234                  memlabel=%nrbquote(PCT and HCT tables for Missouri),
235                  geouniv=Missouri,
236                  units=%str(Many, down to Tract),
237                  Year=2000,
238                  CreatePgm=cnvtsf3,
239                  Description=%nrbquote(PCT and HCT tables by Race & Hispanic for all MO geography levels down to Tract),
240                 keyvars=SumLev geocomp county  placefp msacmsa pmsa ,
241                 keyfmats=sumlev geocomp county fplace   metro metro ,
242                 keyquals=|         |      |     state     |     |,
243                 keyidvars=,
244                 DataSource=%str(2000 Census, Summary File 3.),
245                 SortedBy=LogRecNo,
246                 UsageNotes=%nrbquote(<ul><li>These more detailed CT tables are not published for levels below Census Tract
247            <li> These tables have an alpha suffix in their name which indicates the racial/ethnic universe for the table),
248                 SubType=phctr,
249                 SetGroup=mo,
250                 VarSet=Variablesphctr,
251                 URLMeta=%str(http://mcdc2.missouri.edu/pub/data/sf32000/Varlabs/PCTlabels.txt),
252                 debug=0)
***Not executed because mophctr is not on todo list***
253        
254        
255          %doset(mode=,libname=sf32000,
256                  memname=mostcnty,
257                  memlabel=%nrbquote(All tables for Missouri State and County levels),
258                  geouniv=Missouri,
259                  units=%str(State County),
7                                                          The SAS System                               10:43 Tuesday, June 23, 2009

260                  Year=2000,
261                  CreatePgm=cnvtsf3,
262                  Description=%nrbquote(This data set combines all the tables in moph, mophct and mophctr into a single data set
262      ! but
263         only for the State and County level summaries),
264                 keyvars=SumLev  county,
265                 keyfmats=sumlev county,
266                 keyquals=|         |  ,
267                 keyidvars=,
268                 DataSource=%str(2000 Census, Summary File 3.),
269                 SortedBy=LogRecNo,
270                 UsageNotes=%nrbquote(<ul><li>No geographic component summaries.
271                 <li> The usstcnty  data set has exactly the same data tables but for the entire country.
272                 </ul>),
273                 SubType=alltabs,
274                 SetGroup=mo,
275                 VarSet=Variables,
276                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
277                 debug=0)
***Not executed because mostcnty is not on todo list***
278        
279        
280          %doset(mode=,libname=sf32000,
281                  memname=moregns06ph,sortprio=2,
282                  memlabel=%nrbquote(P and H tables for Missouri county-based regions),
283                  geouniv=Missouri,
284                  units=%str(rpc dot ded aaa umx cbsa),
285                  Year=2000,
286                  CreatePgm=agg_moregns,
287                  Description=%nrbquote(Contains just the P and H tables),
288                 keyvars=SumLev cbsa aaa ded_region dot rpc umx2 ,
289                 keyfmats=sumlev cbsa aaa dedrgn modot rpcname umxname ,
290                 keyidvars=,
291                 DataSource=%str(2000 Census, Summary File 3.),
292                 SortedBy=sumlev geocode,
293                 UsageNotes=%nrbquote(  ),
294                 SubType=ph,
295                 SetGroup=mo,
296                 VarSet=Variablesph,
297                 URLMeta=%str(http://mcdc2.missouri.edu/pub/data/sf32000/Varlabs/Plabels.txt),
298                 debug=0)
***Not executed because moregns06ph is not on todo list***
299        
300          %doset(mode=,libname=sf32000,
301                  memname=moregns06phct,sortprio=2,
302                  memlabel=%nrbquote(PCT and HCT tables for Missouri),
303                  geouniv=Missouri,
304                  units=%str(rpc dot ded aaa umx cbsa),
305                  Year=2000,
306                  CreatePgm=agg_moregns,
307                  Description=%nrbquote(PCT and HCT tables (exc PCTr & HCTr) for all MO county-based Regions),
308                 keyvars=SumLev cbsa aaa  ded_region dot   rpc umx2 ,
309                 keyfmats=sumlev cbsa aaa dedrgn     modot rpcname umxname ,
310                 keyidvars=,
311                 DataSource=%str(2000 Census, Summary File 3.),
312                 SortedBy=sumlev geocode,
8                                                          The SAS System                               10:43 Tuesday, June 23, 2009

313                 SubType=phct,
314                 SetGroup=mo,
315                 VarSet=Variablesphct,
316                 URLMeta=%str(http://mcdc2.missouri.edu/pub/data/sf32000/Varlabs/PCTlabels.txt),
317                 debug=0)
***Not executed because moregns06phct is not on todo list***
318        
319        
320          %doset(mode=,libname=sf32000,
321                  memname=moregns06phctr,sortprio=2,
322                  memlabel=%nrbquote(PCT and HCT tables with alpha suffixes for Missouri),
323                  geouniv=Missouri,
324                  units=%str(rpc dot ded aaa umx cbsa),
325                  Year=2000,
326                  CreatePgm=agg_moregns,
327                  Description=%nrbquote(PCT and HCT tables by Race & Hispanic for all MO county-based Regions),
328                 keyvars=SumLev cbsa aaa ded_region dot rpc umx2 ,
329                 keyfmats=sumlev cbsa aaa dedrgn modot rpcname umxname ,
330                 keyidvars=,
331                 DataSource=%str(2000 Census, Summary File 3.),
332                 SortedBy=sumlev geocode,
333                 UsageNotes=%nrbquote(<ul>
334            <li> These tables have an alpha suffix in their name which indicates the racial/ethnic universe for the table </ul>),
335                 SubType=phctr,
336                 SetGroup=mo,
337                 VarSet=Variablesphctr,
338                 URLMeta=%str(http://mcdc2.missouri.edu/pub/data/sf32000/Varlabs/PCTlabels.txt),
339                 debug=0)
***Not executed because moregns06phctr is not on todo list***
340        
341        
342          %doset(mode=,libname=sf32000,
343                  memname=moregns06,sortprio=2,
344                  memlabel=%nrbquote(All tables for Missouri county-based Regions),
345                  geouniv=Missouri,
346                  units=%str(rpc dot ded aaa umx cbsa),
347                  Year=2000,
348                  CreatePgm=agg_moregns,
349                  Description=%nrbquote(This data set combines all the tables in moregns06ph, moregns06phct and moregns06phctr
349      ! into a single data set),
350                 keyvars=SumLev cbsa aaa ded_region dot rpc umx2 ,
351                 keyfmats=sumlev cbsa aaa dedrgn modot rpcname umxname ,
352                 DataSource=%str(2000 Census, Summary File 3.),
353                 SortedBy=sumlev geocode,
354                 SubType=alltabs,
355                 SetGroup=mo,
356                 VarSet=Variables,
357                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
358                 debug=0)
***Not executed because moregns06 is not on todo list***
359        
360        
361          %doset(mode=,libname=sf32000,
362                  memname=usstcnty,
363                  memlabel=%nrbquote(All tables for United States at State and County levels),
364                  geouniv=United States,
9                                                          The SAS System                               10:43 Tuesday, June 23, 2009

365                  units=%str(State County),
366                  Year=2000,
367                  CreatePgm=cnvtsf3_usdata2,
368                  Description=%nrbquote(U.S. state and county level summaries),
369                 keyvars=SumLev  state county,
370                 keyfmats=sumlev state county,
371                 DataSource=%str(2000 Census, Summary File 3.),
372                 SortedBy=LogRecNo,
373                 UsageNotes=%nrbquote(<ul><li>No geographic component summaries.
374                 <li> The mostcnty  data set has exactly the same data tables but for the state of Missouri only.
375                 </ul>),
376                 SubType=alltabs,
377                 SetGroup=us,
378                 VarSet=Variables,
379                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
380                 debug=0)
***Not executed because usstcnty is not on todo list***
381        
382        
383          %doset(mode=,libname=sf32000,
384                  memname=usregdiv,
385                  memlabel=%nrbquote(All tables for United States (totals), Regions and Divisions),
386                  geouniv=United States,
387                  units=%str(Nation Region Division),
388                  Year=2000,
389                  CreatePgm=cnvtsf3_usdata2,
390                  Description=%nrbquote(U.S. state and county level summaries),
391                 keyvars=SumLev  geocomp,
392                 keyfmats=sumlev geocomp,
393                 DataSource=%str(2000 Census, Summary File 3.),
394                 SortedBy=LogRecNo,
395                 UsageNotes=%nrbquote(<ul><li>Includes geographic component summaries.  Use a filter of
396         <code>geocomp   Equals  00</code> to filter out the components.  What will be left is only 14 summaries
397         (1 nation, 4 regions and 9 divisions)
398                 </ul>),
399                 SubType=alltabs,
400                 SetGroup=us,
401                 VarSet=Variables,
402                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
403                 debug=0)
***Not executed because usregdiv is not on todo list***
404        
405        
406        
407          %doset(mode=,libname=sf32000,
408                  memname=usuas,
409                  memlabel=%nrbquote(All tables for United States Urban Areas),
410                  geouniv=United States,
411                  units=%str(Urban Areas),
412                  Year=2000,
413                  CreatePgm=cnvtsf3_usdata2,
414                  Description=%nrbquote(U.S. UAs - Urbanized Areas and Urban Clusters - total and within-state portion
414      ! summaries),
415                 keyvars=SumLev  ua     state ,
416                 keyfmats=sumlev uauc2k state,
417                 DataSource=%str(2000 Census, Summary File 3.),
10                                                         The SAS System                               10:43 Tuesday, June 23, 2009

418                 SortedBy=LogRecNo,
419                 UsageNotes=%nrbquote(<ul><li>Use the UAtype variables (value C and U) to disinguish between the smaller Urban
419      ! Clusters and
420        larger Urbanized Areas
421          <li>On level 410 summaries (state portions of UAs) AreaName will consist of the state name followed by "(part)".  So if
421      !  you wanted to
422        pull all the UA portions for a state you would not have any variable containing the name of the UA.  You can get around
422      ! this by using a
423        format code so that the UA variable is displayed/saved as the name. In Dexter section V-c., in the Format text box, code
423      ! '
424        <code>ua $uauc2k40. </code> to specify that you want the UA variable (which contains a 5-digit code) to display as the
424      ! name of the UA in
425        stead of the code value.
426                 <li>SumLev 400 is complete UAs, while SumLev 410 contains the state portion of the UA.  Most UAs are entirely
426      ! within a state so
427         that their are 2 observations with identical tabular data.  The state code is blank on all 400-level summaries, even if
427      ! the UA is
428         entirely within a state.
429                 </ul>),
430                 SubType=alltabs,
431                 SetGroup=us,
432                 VarSet=Variables,
433                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
434                 debug=0)

Mode has been assigned as update
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      cpu time            0.04 seconds
      


NOTE: The data set WORK.CONTENTS has 16594 observations and 39 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           1.10 seconds
      cpu time            0.75 seconds
      

WARNING: The quoted string currently being processed has become more than 262 characters long.  You may have unbalanced quotation 
         marks.
WARNING: The quoted string currently being processed has become more than 262 characters long.  You may have unbalanced quotation 
         marks.

NOTE: There were 16594 observations read from the data set WORK.CONTENTS.
NOTE: The data set WORK._USUAS has 1 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.22 seconds
      cpu time            0.15 seconds
      


NOTE: There were 53 observations read from the data set SF32000.DATASETS.
NOTE: There were 1 observations read from the data set WORK._USUAS.
NOTE: The data set SF32000.DATASETS has 53 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.14 seconds
11                                                         The SAS System                               10:43 Tuesday, June 23, 2009

      cpu time            0.04 seconds
      

_indxfilename= /pub/data/sf32000/datasets.sas7bndx
NOTE: Composite index dataset has been defined.
NOTE: MODIFY was successful for SF32000.DATASETS.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.27 seconds
      cpu time            0.02 seconds
      

435        
436        
437        
438          %doset(mode=,libname=sf32000,
439                  memname=usplacesph,
440                  memlabel=%nrbquote(P and H tables for United States for United States at Place and Place-within-county levels),
441                  geouniv=United States,
442                  units=%str(Place Place/County),
443                  Year=2000,
444                  CreatePgm=cnvtsf3,
445                  Description=%nrbquote(U.S. place (city) and place-within county level summaries),
446                 keyvars=SumLev  state county  placefp,
447                 keyfmats=sumlev state county  place,
448                 keyquals= |      |     |      state,
449                 DataSource=%str(2000 Census, Summary File 3.),
450                 SortedBy=LogRecNo,
451                 UsageNotes=%nrbquote(<ul><li>These places are not restricted by population size.  Small towns are included.
452                 <li>Companion data sets are usplacesgeos, usplacesphct and usplacesphctr.
453                 </ul>),
454                 SubType=ph,
455                 SetGroup=usplaces,
456                 VarSet=Variablesph,
457                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
458                 debug=0)
***Not executed because usplacesph is not on todo list***
459        
460        
461          %doset(mode=,libname=sf32000,
462                  memname=usplacesphct,
463                  memlabel=%nrbquote(PCT and HCT tables for United States for United States at Place and Place-within-county
463      ! levels),
464                  geouniv=United States,
465                  units=%str(Place Place/County),
466                  Year=2000,
467                  CreatePgm=cnvtsf3,
468                  Description=%nrbquote(U.S. place (city) and place-within county level summaries),
469                 keyvars=SumLev  state county  placefp,
470                 keyfmats=sumlev state county  place,
471                 keyquals= |      |     |      state,
472                 DataSource=%str(2000 Census, Summary File 3.),
473                 SortedBy=LogRecNo,
474                 UsageNotes=%nrbquote(<ul><li>Places are not restricted by any population size.
475                 </ul>),
476                 SubType=phct,
477                 SetGroup=usplaces,
12                                                         The SAS System                               10:43 Tuesday, June 23, 2009

478                 VarSet=Variablesphct,
479                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
480                 debug=0)
***Not executed because usplacesphct is not on todo list***
481        
482        
483          %doset(mode=,libname=sf32000,
484                  memname=usplacesphctr,
485                  memlabel=%nrbquote(PCT(r) and HCT(r) tables for United States for United States at Place and
485      ! Place-within-county levels),
486                  geouniv=United States,
487                  units=%str(Place Place/County),
488                  Year=2000,
489                  CreatePgm=cnvtsf3,
490                  Description=%nrbquote(U.S. place (city) and place-within county level summaries),
491                 keyvars=SumLev  state county  placefp,
492                 keyfmats=sumlev state county  place,
493                 keyquals= |      |     |      state,
494                 DataSource=%str(2000 Census, Summary File 3.),
495                 SortedBy=LogRecNo,
496                 UsageNotes=%nrbquote(<ul><li>Places are not restricted by any population size.
497                 </ul>),
498                 SubType=phctr,
499                 SetGroup=usplaces,
500                 VarSet=Variablesphctr,
501                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
502                 debug=0)
***Not executed because usplacesphctr is not on todo list***
503        
504        
505          %doset(mode=,libname=sf32000,
506                  memname=uspumasph,
507                  memlabel=%nrbquote(P and H tables for PUMAs for United States),
508                  geouniv=United States,
509                  units=PUMA,
510                  Year=2000,
511                  CreatePgm=agg_uspumas,
512                  Description=%nrbquote(Pulbic Use Microsample Area summaries (the 5% sample versions) aggregated/estimated by
512      ! MCDC),
513                 keyvars=State,
514                 keyfmats=state,
515                 keyquals= |  ,
516                 DataSource=%str(2000 Census, Summary File 3, with aggregation by MCDC.),
517                 SortedBy=LogRecNo,
518                 UsageNotes=%nrbquote(<ul><li>These are aggregated estimates created by the Missouri Census Data Center.
519          <li>The Census Bureau did not publish SF3 tables aggregated for these units.
520          <li>Aggregation was done from data at the split-block group (code 090) level, using an equivalency file created by
520      ! MABLE/Geocorr2k.  T
521        he amount of disaggregating (i.e. apportioning of data in cases where a split-BG crossed a PUMA boundary) was almost
521      ! never required.
522          <li>We currently have no CT tables (PCT and HCT) tables at this level.  That is mostly because there was no BG level
522      ! data for those
523        tables and we did not want to estimate using tract level data.  But we might change our mind some day.
524                 </ul>),
525                 SubType=ph,
526                 SetGroup=us,
13                                                         The SAS System                               10:43 Tuesday, June 23, 2009

527                 VarSet=Variablesph,
528                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
529                 debug=0)
***Not executed because uspumasph is not on todo list***
530        
531        
532        
533          %doset(mode=,libname=sf32000,
534                  memname=uszipsph,
535                  memlabel=%nrbquote(P and H tables for United States for United States at 3 and 5-digit ZCTA levels),
536                  geouniv=United States,
537                  units=%str(ZCTA, 3-digt ZCTA),
538                  Year=2000,
539                  CreatePgm=cnvtsf3,
540                  Description=%nrbquote(U.S. ZCTA (ZIP) and 3-digit ZCTA level summaries: P and H tables),
541                 keyvars=SumLev  state,
542                 keyfmats=sumlev state,
543                 keyquals=%str( |      |)  ,
544                 DataSource=%str(2000 Census, Summary File 3.),
545                 SortedBy=LogRecNo,
546                 UsageNotes=%nrbquote(<ul><li>ZCTAs are the Census Bureaus approximation of USPS ZIP code areas designed
546      ! specifically as
547         areas for tabulating census data.
548                 <li>Pseudo-ZIPx with XX and HH as last 2 digits represent areas not assigned a ZIP code and water portion of ZIP
548      !  areas.
549                 <li>Companion data sets are uszipsgeos, uszipsphct and uszipsphctr.
550                 </ul>),
551                 SubType=ph,
552                 SetGroup=uszips,
553                 VarSet=Variablesph,
554                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
555                 debug=0)
***Not executed because uszipsph is not on todo list***
556        
557        
558          %doset(mode=,libname=sf32000,
559                  memname=uszipsphct,
560                  memlabel=%nrbquote(PCT and HCT tables for United States for United States at 3 and 5-digit ZCTA levels),
561                  geouniv=United States,
562                  units=%str(ZCTA, 3-digt ZCTA),
563                  Year=2000,
564                  CreatePgm=cnvtsf3,
565                  Description=%nrbquote(U.S. ZCTA (ZIP) and 3-digit ZCTA level summaries: PCT and HCT tables),
566                 keyvars=SumLev  state,
567                 keyfmats=sumlev state,
568                 DataSource=%str(2000 Census, Summary File 3.),
569                 SortedBy=LogRecNo,
570                 UsageNotes=%nrbquote(<ul><li>ZCTAs are the Census Bureaus approximation of USPS ZIP code areas designed
570      ! specifically as
571         areas for tabulating census data.
572                 <li>Pseudo-ZIPx with XX and HH as last 2 digits represent areas not assigned a ZIP code and water portion of ZIP
572      !  areas.
573                 <li>Companion data sets are uszipsgeos, uszipsph and uszipsphctr.
574                 </ul>),
575                 SubType=phct,
576                 SetGroup=uszips,
14                                                         The SAS System                               10:43 Tuesday, June 23, 2009

577                 VarSet=Variablesphct,
578                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
579                 debug=0)
***Not executed because uszipsphct is not on todo list***
580        
581        
582          %doset(mode=,libname=sf32000,
583                  memname=uszipsphctr,
584                  memlabel=%nrbquote(PCT(r) and HCT(r) tables for United States for United States at 3 and 5-digit ZCTA levels),
585                  geouniv=United States,
586                  units=%str(ZCTA, 3-digt ZCTA),
587                  Year=2000,
588                  CreatePgm=cnvtsf3,
589                  Description=%nrbquote(U.S. ZCTA (ZIP) and 3-digit ZCTA level summaries: PCT(r) and HCT(r) tables),
590                 keyvars=SumLev  state,
591                 keyfmats=sumlev state,
592                 DataSource=%str(2000 Census, Summary File 3.),
593                 SortedBy=LogRecNo,
594                 UsageNotes=%nrbquote(<ul><li>ZCTAs are the Census Bureaus approximation of USPS ZIP code areas designed
594      ! specifically as
595         areas for tabulating census data.
596                 <li>Pseudo-ZIPx with XX and HH as last 2 digits represent areas not assigned a ZIP code and water portion of ZIP
596      !  areas.
597                 <li>Companion data sets are uszipsgeos, uszipsph and uszipsphct.
598                 </ul>),
599                 SubType=phctr,
600                 SetGroup=uszips,
601                 VarSet=Variablesphctr,
602                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
603                 debug=0)
***Not executed because uszipsphctr is not on todo list***
604        
605        
606          /* =======================Begin comment================
607        
608          %doset(mode=,libname=sf32000,
609                 memname=usgeocompsgeos,
610                 memlabel=%nrbquote(Geographic variables only for selected summaries involving a geographic component summary at
610      ! a level of state
611        or higher),
612                 geouniv=UnitedStates,
613                 units=Geographic Components,
614                 Year=2000,
615                 CreatePgm=cnvtsf3us,
616                 Description=%nrbquote(Contains just the geographic ID fields as read from the Census Bureau <i>usgeo3_uf3</i>
616      ! file for selected
617        geographic summary levels (nation, region, division and state).),
618                keyvars=SumLev state geocomp,
619                keyfmats=sumlev state geocomp,
620                keyidvars=,
621                DataSource=%str(2000 Census, Summary File 3.),
622                SortedBy=LogRecNo,
623                UsageNotes=%str(<ul><li>This is the plural version of this data set (see also the usgeocompgeos data set).
624         This one has only a small subset of
625        the potential geographic component summaries available from the Census Bureau.  We do have sf3 data tables for the
625      ! components
15                                                         The SAS System                               10:43 Tuesday, June 23, 2009

626        on this dataset/ Those data are stored in the usgeocomps[ph|phct|pcctr] data sets.
627        </ul>),
628                SubType=geos,
629                SetGroup=us,
630                VarSet=,
631                URLMeta=%str(http://factfinder.census.gov/home/en/epss/geo_components_2.html),
632                debug=0)
633        
634          %doset(mode=,libname=sf32000,
635                  memname=usgeocompsph,
636                  memlabel=%nrbquote(P, H tables for United States geographic component summaries at state, region and nation
636      ! levels),
637                  geouniv=United States,
638                  units=%str(Geographic Components),
639                  Year=2000,
640                  CreatePgm=cnvtsf3us,
641                  Description=%nrbquote(P and H tables for geographic components of the state, region and nation levels),
642                 keyvars=SumLev  geocomp state,
643                 keyfmats=sumlev geocomp state,
644                 DataSource=%str(2000 Census, Summary File 3.),
645                 SortedBy=LogRecNo,
646                 UsageNotes=%str(<ul><l>Only geographic component summaries.
647         <li>The usgeocompgeos data set shows all the many tens of thousands of geocomp summaries are possible. But for the sake
647      ! of disk space
648        we only keep them for the most common geographies. If you need a geographic component table for some other unit of
648      ! geography you will
649         need to use American Factfinder.
650         <li> If you need CT table data for these geographic components you will need the corresponding phct or phctr data sets.
651         </ul>),
652                 SubType=phtabs,
653                 SetGroup=us,
654                 VarSet=Variablesph,
655                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
656                 debug=0)
657        
658        %doset(mode=,libname=sf32000,
659                  memname=usgeocompsphct,
660                  memlabel=%nrbquote(PCT and  HCT tables for United States geographic component summaries at state, region and
660      ! nation levels),
661                  geouniv=United States,
662                  units=%str(Geographic Components),
663                  Year=2000,
664                  CreatePgm=cnvtsf3us,
665                  Description=%nrbquote(PCT and HCT tables for geographic components of the state, region and nation levels),
666                 keyvars=SumLev  geocomp state,
667                 keyfmats=sumlev geocomp state,
668                 DataSource=%str(2000 Census, Summary File 3.),
669                 SortedBy=LogRecNo,
670                 UsageNotes=%str(<ul><l>Only geographic component summaries.
671         <li>The usgeocompgeos data set shows all the many tens of thousands of geocomp summaries are possible. But for the sake
671      ! of disk space
672        we only keep them for the most common geographies. If you need a geographic component table for some other unit of
672      ! geography you will
673         need to use American Factfinder.
674         <li> If you need P or H table data for these geographic components you will need the corresponding ph data set. If you
674      ! need one of the
16                                                         The SAS System                               10:43 Tuesday, June 23, 2009

675        race-specific PCTr or HCTr tables then you need the corresponding phctr data set.
676         </ul>),
677                 SubType=phcttabs,
678                 SetGroup=us,
679                 VarSet=Variablesphct,
680                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
681                 debug=0)
682        
683        %doset(mode=,libname=sf32000,
684                  memname=usgeocompsphctr,
685                  memlabel=%nrbquote(PCTr and  HCTr tables for United States geographic component summaries at state, region and
685      ! nation levels),
686                  geouniv=United States,
687                  units=%str(Geographic Components),
688                  Year=2000,
689                  CreatePgm=cnvtsf3us,
690                  Description=%nrbquote(PCTr and HCTr (race/origin specific) tables for geographic components of the state,
690      ! region and nation levels),
691                 keyvars=SumLev  geocomp state,
692                 keyfmats=sumlev geocomp state,
693                 DataSource=%str(2000 Census, Summary File 3.),
694                 SortedBy=LogRecNo,
695                 UsageNotes=%str(<ul><l>Only geographic component summaries.
696         <li>The usgeocompgeos data set shows all the many tens of thousands of geocomp summaries are possible. But for the sake
696      ! of disk space
697        we only keep them for the most common geographies. If you need a geographic component table for some other unit of
697      ! geography you will
698         need to use American Factfinder.
699         <li> If you need P or H table data for these geographic components you will need the corresponding ph data set. If you
699      ! need one of the
700        non race-specific PCT or HCT tables then you need the corresponding phct data set.
701         </ul>),
702                 SubType=phctrtabs,
703                 SetGroup=us,
704                 VarSet=Variablesphctr,
705                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
706                 debug=0)
707        
708        
709        
710           %doset(mode=,libname=sf32000,
711                  memname=uscousubsph,
712                  memlabel=%nrbquote(P and H tables for United States for United States at County subdivision (MCD/CCD) level),
713                  geouniv=United States,
714                  units=%str(County Subdivisions/Towns),
715                  Year=2000,
716                  CreatePgm=cnvtsf3us,
717                  Description=%nrbquote(County subdivision (MCD/CCD) summaries: P and H tables),
718                 keyvars=Sumlev state county ,
719                 keyfmats=Sumlev state county ,
720                 keyquals=%str( |      |)  ,
721                 DataSource=%str(2000 Census, Summary File 3.),
722                 SortedBy=LogRecNo,
723                 UsageNotes=%nrbquote(<ul><li>County subdivisions vary in terms of importance and naming terminology by state.
724                 <li>These are most important in New England and the Middle Atlantic states (NY, PA) where they are known as
724      ! towns and are
17                                                         The SAS System                               10:43 Tuesday, June 23, 2009

725        functioning governmental units.  These are referred to as Minor Civil Divisions (MCDs).
726                 <li>In Missouri these are known as townships, and are used for voting jurisdictions.  But they are functioning
726      ! governmental units
727         in a few counties in the rural west central portion of the state.
728                 <li>Companion data sets are uscousubsgeos, uscousubsphct and uscousubsphctr.
729                 </ul>),
730                 SubType=ph,
731                 SetGroup=uscousubs,
732                 VarSet=Variablesph,
733                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
734                 debug=0)
735        
736        
737          %doset(mode=,libname=sf32000,
738                  memname=uscousubsphct,
739                  memlabel=%nrbquote(PCT and HCT tables for United States for United States at County subdivision (MCD/CCD)
739      ! level),
740                  geouniv=United States,
741                  units=%str(County Subdivisions/Towns),
742                  Year=2000,
743                  CreatePgm=cnvtsf3us,
744                  Description=%nrbquote(County subdivision (MCD/CCD) summaries:  PCT and HCT tables),
745                 keyvars=Sumlev state county ,
746                 keyfmats=Sumlev state county ,
747                 DataSource=%str(2000 Census, Summary File 3.),
748                 SortedBy=LogRecNo,
749                 UsageNotes=%nrbquote(<ul><li>County subdivisions vary in terms of importance and naming terminology by state.
750                 <li>These are most important in New England and the Middle Atlantic states (NY, PA) where they are known as
750      ! towns and are
751        functioning governmental units.  These are referred to as Minor Civil Divisions (MCDs).
752                 <li>In Missouri these are known as townships, and are used for voting jurisdictions.  But they are functioning
752      ! governmental units
753         in a few counties in the rural west central portion of the state.
754                 <li>Companion data sets are uscousubsgeos, uscousubsph and uscousubsphctr.
755                 </ul>),
756                 SubType=phct,
757                 SetGroup=uscousubs,
758                 VarSet=Variablesphct,
759                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
760                 debug=0)
761        
762        
763          %doset(mode=,libname=sf32000,
764                  memname=uscousubsphctr,
765                  memlabel=%nrbquote(PCT(r) and HCT(r) tables for United States for United States at County subdivision (MCD/CCD)
765      !  level),
766                  geouniv=United States,
767                  units=%str(County Subdivisions/Towns),
768                  Year=2000,
769                  CreatePgm=cnvtsf3us,
770                  Description=%nrbquote(County subdivision (MCD/CCD) summaries:  PCT(r) and HCT(r) tables),
771                 keyvars=Sumlev state county ,
772                 keyfmats=Sumlev state county ,
773                 DataSource=%str(2000 Census, Summary File 3.),
774                 SortedBy=LogRecNo,
775                 UsageNotes=%nrbquote(<ul><li>County subdivisions vary in terms of importance and naming terminology by state.
18                                                         The SAS System                               10:43 Tuesday, June 23, 2009

776                 <li>These are most important in New England and the Middle Atlantic states (NY, PA) where they are known as
776      ! towns and are
777        functioning governmental units.  These are referred to as Minor Civil Divisions (MCDs).
778                 <li>In Missouri these are known as townships, and are used for voting jurisdictions.  But they are functioning
778      ! governmental units
779         in a few counties in the rural west central portion of the state.
780                 <li>Companion data sets are uscousubsgeos, uscousubsph and uscousubsphct.
781                 </ul>),
782                 SubType=phctr,
783                 SetGroup=uscousubs,
784                 VarSet=Variablesphctr,
785                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
786                 debug=0)
787            ======================End comment================== */
788        
789        
790        %doset(mode=,libname=sf32000,
791                  memname=usmetrosph,
792                  memlabel=%nrbquote(P and H tables for United States for United States at Metro Area level),
793                  geouniv=United States,
794                  units=%str(Metro Areas),
795                  Year=2000,
796                  CreatePgm=cnvtsf3us,
797                  Description=%nrbquote(Metro Area summaries: P and H tables),
798                 keyvars=sumlev state msacmsa,
799                 keyfmats=sumlev state metro,
800                 keyquals=%str( |      |)  ,
801                 DataSource=%str(2000 Census, Summary File 3.),
802                 SortedBy=LogRecNo,
803                 UsageNotes=%nrbquote(<ul><li>These are the metro area definitions in effect at the time of the 2k census
803      ! (pre-CBSA).
804                 <li>Includes summaries for MSAs, CMSAs, NECMAs (in New England only) and PMSAs, as well as the state portions of
804      !  each.
805                 <li>Companion data sets are usmetrosgeos, usmetrosphct and usmetrosphctr.
806                 </ul>),
807                 SubType=ph,
808                 SetGroup=usmetros,
809                 VarSet=Variablesph,
810                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
811                 debug=0)

Mode has been assigned as update
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      


NOTE: The data set WORK.CONTENTS has 5632 observations and 39 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.49 seconds
      cpu time            0.28 seconds
      

WARNING: The quoted string currently being processed has become more than 262 characters long.  You may have unbalanced quotation 
         marks.
19                                                         The SAS System                               10:43 Tuesday, June 23, 2009

WARNING: The quoted string currently being processed has become more than 262 characters long.  You may have unbalanced quotation 
         marks.

NOTE: There were 5632 observations read from the data set WORK.CONTENTS.
NOTE: The data set WORK._USMETROSPH has 1 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.15 seconds
      cpu time            0.10 seconds
      


NOTE: MODIFY was successful for SF32000.USMETROSPH.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.13 seconds
      cpu time            0.06 seconds
      


NOTE: There were 53 observations read from the data set SF32000.DATASETS.
NOTE: There were 1 observations read from the data set WORK._USMETROSPH.
NOTE: The data set SF32000.DATASETS has 53 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.17 seconds
      cpu time            0.03 seconds
      

_indxfilename= /pub/data/sf32000/datasets.sas7bndx
NOTE: Composite index dataset has been defined.
NOTE: MODIFY was successful for SF32000.DATASETS.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.15 seconds
      cpu time            0.03 seconds
      

812        
813        
814          %doset(mode=,libname=sf32000,
815                  memname=usmetrosphct,
816                  memlabel=%nrbquote(PCT and HCT tables for United States for United States at Metro Area level),
817                  geouniv=United States,
818                  units=%str(Metro Areas),
819                  Year=2000,
820                  CreatePgm=cnvtsf3us,
821                  Description=%nrbquote(Metro Area summaries:  PCT and HCT tables),
822                 keyvars=sumlev state msacmsa,
823                 keyfmats=sumlev state msacmsa,
824                 DataSource=%str(2000 Census, Summary File 3.),
825                 SortedBy=LogRecNo,
826                 UsageNotes=%nrbquote(<ul><li>These are the metro area definitions in effect at the time of the 2k census
826      ! (pre-CBSA).
827                 <li>Includes summaries for MSAs, CMSAs, NECMAs (in New England only) and PMSAs, as well as the state portions of
827      !  each.
828                 <li>Companion data sets are usmetrosgeos, usmetrosphct and usmetrosphctr.
829                 </ul>),
830                 SubType=phct,
831                 SetGroup=usmetros,
20                                                         The SAS System                               10:43 Tuesday, June 23, 2009

832                 VarSet=Variablesphct,
833                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
834                 debug=0)

Mode has been assigned as update
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      


NOTE: The data set WORK.CONTENTS has 4465 observations and 39 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.43 seconds
      cpu time            0.22 seconds
      

WARNING: The quoted string currently being processed has become more than 262 characters long.  You may have unbalanced quotation 
         marks.
WARNING: The quoted string currently being processed has become more than 262 characters long.  You may have unbalanced quotation 
         marks.

NOTE: There were 4465 observations read from the data set WORK.CONTENTS.
NOTE: The data set WORK._USMETROSPHCT has 1 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.13 seconds
      cpu time            0.09 seconds
      


NOTE: MODIFY was successful for SF32000.USMETROSPHCT.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.10 seconds
      cpu time            0.04 seconds
      


NOTE: There were 53 observations read from the data set SF32000.DATASETS.
NOTE: There were 1 observations read from the data set WORK._USMETROSPHCT.
NOTE: The data set SF32000.DATASETS has 53 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.10 seconds
      cpu time            0.04 seconds
      

_indxfilename= /pub/data/sf32000/datasets.sas7bndx
NOTE: Composite index dataset has been defined.
NOTE: MODIFY was successful for SF32000.DATASETS.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.10 seconds
      cpu time            0.02 seconds
      

835        
836        
837          %doset(mode=,libname=sf32000,
21                                                         The SAS System                               10:43 Tuesday, June 23, 2009

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

Mode has been assigned as update
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      


NOTE: The data set WORK.CONTENTS has 6643 observations and 39 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.52 seconds
      cpu time            0.29 seconds
      

WARNING: The quoted string currently being processed has become more than 262 characters long.  You may have unbalanced quotation 
         marks.
WARNING: The quoted string currently being processed has become more than 262 characters long.  You may have unbalanced quotation 
         marks.

NOTE: There were 6643 observations read from the data set WORK.CONTENTS.
NOTE: The data set WORK._USMETROSPHCTR has 1 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.15 seconds
      cpu time            0.10 seconds
      


NOTE: MODIFY was successful for SF32000.USMETROSPHCTR.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.15 seconds
      cpu time            0.07 seconds
      


22                                                         The SAS System                               10:43 Tuesday, June 23, 2009

NOTE: There were 53 observations read from the data set SF32000.DATASETS.
NOTE: There were 1 observations read from the data set WORK._USMETROSPHCTR.
NOTE: The data set SF32000.DATASETS has 53 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.15 seconds
      cpu time            0.04 seconds
      

_indxfilename= /pub/data/sf32000/datasets.sas7bndx
NOTE: Composite index dataset has been defined.
NOTE: MODIFY was successful for SF32000.DATASETS.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.13 seconds
      cpu time            0.04 seconds
      

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

Mode has been assigned as update
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      


NOTE: The data set WORK.CONTENTS has 5632 observations and 39 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.50 seconds
      cpu time            0.23 seconds
      


NOTE: There were 5632 observations read from the data set WORK.CONTENTS.
23                                                         The SAS System                               10:43 Tuesday, June 23, 2009

NOTE: The data set WORK._USCDS106PH has 1 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.15 seconds
      cpu time            0.08 seconds
      


NOTE: MODIFY was successful for SF32000.USCDS106PH.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.13 seconds
      cpu time            0.03 seconds
      


NOTE: There were 53 observations read from the data set SF32000.DATASETS.
NOTE: There were 1 observations read from the data set WORK._USCDS106PH.
NOTE: The data set SF32000.DATASETS has 53 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.11 seconds
      cpu time            0.03 seconds
      

_indxfilename= /pub/data/sf32000/datasets.sas7bndx
NOTE: Composite index dataset has been defined.
NOTE: MODIFY was successful for SF32000.DATASETS.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.10 seconds
      cpu time            0.02 seconds
      

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

Mode has been assigned as update
NOTE: DATA statement used (Total process time):
24                                                         The SAS System                               10:43 Tuesday, June 23, 2009

      real time           0.01 seconds
      cpu time            0.01 seconds
      


NOTE: The data set WORK.CONTENTS has 4465 observations and 39 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.39 seconds
      cpu time            0.23 seconds
      


NOTE: There were 4465 observations read from the data set WORK.CONTENTS.
NOTE: The data set WORK._USCDS106PHCT has 1 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.12 seconds
      cpu time            0.08 seconds
      


NOTE: MODIFY was successful for SF32000.USCDS106PHCT.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.13 seconds
      cpu time            0.03 seconds
      


NOTE: There were 53 observations read from the data set SF32000.DATASETS.
NOTE: There were 1 observations read from the data set WORK._USCDS106PHCT.
NOTE: The data set SF32000.DATASETS has 53 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.14 seconds
      cpu time            0.05 seconds
      

_indxfilename= /pub/data/sf32000/datasets.sas7bndx
NOTE: Composite index dataset has been defined.
NOTE: MODIFY was successful for SF32000.DATASETS.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.14 seconds
      cpu time            0.01 seconds
      

903        
904        
905          %doset(mode=,libname=sf32000,
906                  memname=uscds106phctr,
907                  memlabel=%nrbquote(PCT(r) and HCT(r) tables for United States for United States for Congressional Districts
907      ! (106th)),
908                  geouniv=United States,
909                  units=%str(cd106 Areas),
910                  Year=2000,
911                  CreatePgm=cnvtsf3us,
912                  Description=%nrbquote(Congressional District (106th) summaries:  PCT(r) and HCT(r) tables),
913                 keyvars=sumlev state,
914                 keyfmats=sumlev state,
25                                                         The SAS System                               10:43 Tuesday, June 23, 2009

915                 DataSource=%str(2000 Census, Summary File 3.),
916                 SortedBy=LogRecNo,
917                 UsageNotes=%nrbquote(<ul><li>These are for the 106th Congressional Districts as defined at the time of the 2k
917      ! census (elected in 1998).
918                 <li>Companion data sets are uscds106geos, uscds106ph and uscds106phct.
919        </ul>),
920                 SubType=phctr,
921                 SetGroup=uscd106,
922                 VarSet=Variablesphctr,
923                 URLMeta=%str(http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000/Varlabs),
924                 debug=0)

Mode has been assigned as update
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      


NOTE: The data set WORK.CONTENTS has 6643 observations and 39 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.51 seconds
      cpu time            0.29 seconds
      


NOTE: There were 6643 observations read from the data set WORK.CONTENTS.
NOTE: The data set WORK._USCDS106PHCTR has 1 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.13 seconds
      cpu time            0.08 seconds
      


NOTE: MODIFY was successful for SF32000.USCDS106PHCTR.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.14 seconds
      cpu time            0.05 seconds
      


NOTE: There were 53 observations read from the data set SF32000.DATASETS.
NOTE: There were 1 observations read from the data set WORK._USCDS106PHCTR.
NOTE: The data set SF32000.DATASETS has 53 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.11 seconds
      cpu time            0.05 seconds
      

_indxfilename= /pub/data/sf32000/datasets.sas7bndx
NOTE: Composite index dataset has been defined.
NOTE: MODIFY was successful for SF32000.DATASETS.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.11 seconds
      cpu time            0.03 seconds
      
26                                                         The SAS System                               10:43 Tuesday, June 23, 2009


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

Mode has been assigned as update
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      


NOTE: The data set WORK.CONTENTS has 5632 observations and 39 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.50 seconds
      cpu time            0.25 seconds
      


NOTE: There were 5632 observations read from the data set WORK.CONTENTS.
NOTE: The data set WORK._USUASPH has 1 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.14 seconds
      cpu time            0.08 seconds
      


NOTE: MODIFY was successful for SF32000.USUASPH.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.14 seconds
      cpu time            0.04 seconds
      


NOTE: There were 53 observations read from the data set SF32000.DATASETS.
NOTE: There were 1 observations read from the data set WORK._USUASPH.
NOTE: The data set SF32000.DATASETS has 53 observations and 46 variables.
NOTE: DATA statement used (Total process time):
27                                                         The SAS System                               10:43 Tuesday, June 23, 2009

      real time           0.12 seconds
      cpu time            0.05 seconds
      

_indxfilename= /pub/data/sf32000/datasets.sas7bndx
NOTE: Composite index dataset has been defined.
NOTE: MODIFY was successful for SF32000.DATASETS.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.14 seconds
      cpu time            0.02 seconds
      

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

Mode has been assigned as update
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      


NOTE: The data set WORK.CONTENTS has 4465 observations and 39 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.42 seconds
      cpu time            0.23 seconds
      


NOTE: There were 4465 observations read from the data set WORK.CONTENTS.
NOTE: The data set WORK._USUASPHCT has 1 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.13 seconds
      cpu time            0.08 seconds
      


28                                                         The SAS System                               10:43 Tuesday, June 23, 2009

NOTE: MODIFY was successful for SF32000.USUASPHCT.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.12 seconds
      cpu time            0.03 seconds
      


NOTE: There were 53 observations read from the data set SF32000.DATASETS.
NOTE: There were 1 observations read from the data set WORK._USUASPHCT.
NOTE: The data set SF32000.DATASETS has 53 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.11 seconds
      cpu time            0.03 seconds
      

_indxfilename= /pub/data/sf32000/datasets.sas7bndx
NOTE: Composite index dataset has been defined.
NOTE: MODIFY was successful for SF32000.DATASETS.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.08 seconds
      cpu time            0.01 seconds
      

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

Mode has been assigned as update
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      


NOTE: The data set WORK.CONTENTS has 6643 observations and 39 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.51 seconds
      cpu time            0.29 seconds
29                                                         The SAS System                               10:43 Tuesday, June 23, 2009

      


NOTE: There were 6643 observations read from the data set WORK.CONTENTS.
NOTE: The data set WORK._USUASPHCTR has 1 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.13 seconds
      cpu time            0.07 seconds
      


NOTE: MODIFY was successful for SF32000.USUASPHCTR.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.14 seconds
      cpu time            0.06 seconds
      


NOTE: There were 53 observations read from the data set SF32000.DATASETS.
NOTE: There were 1 observations read from the data set WORK._USUASPHCTR.
NOTE: The data set SF32000.DATASETS has 53 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.12 seconds
      cpu time            0.05 seconds
      

_indxfilename= /pub/data/sf32000/datasets.sas7bndx
NOTE: Composite index dataset has been defined.
NOTE: MODIFY was successful for SF32000.DATASETS.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.10 seconds
      cpu time            0.02 seconds
      

988        
989        
990        
991           proc sort data=sf32000.datasets out=bysortprio;
992             by SortPrio GeoUniv SetGroup SubType Memname ;   run;

NOTE: There were 53 observations read from the data set SF32000.DATASETS.
NOTE: The data set WORK.BYSORTPRIO has 53 observations and 46 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.09 seconds
      cpu time            0.04 seconds
      

993        
994           proc datasets library=sf32000 nolist;
995              modify datasets;
996              index delete dataset memname;
NOTE: Index dataset deleted.
WARNING: No key variables have been defined for file DATASETS.
WARNING: No index named memname.
997              index create  dataset=(libname memname) / unique;
NOTE: Composite index dataset has been defined.
30                                                         The SAS System                               10:43 Tuesday, June 23, 2009

998              index create memname;
NOTE: Simple index memname has been defined.
999              quit;

NOTE: MODIFY was successful for SF32000.DATASETS.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.25 seconds
      cpu time            0.03 seconds
      

1000       
1001       
1002       
1003           options mprint msglevel=i;
1004            %gendshtm(libname=sf32000,debug=0,runprocc=1);
WARNING: The quoted string currently being processed has become more than 262 characters long.  You may have unbalanced quotation 
         marks.
WARNING: The quoted string currently being processed has become more than 262 characters long.  You may have unbalanced quotation 
         marks.
WARNING: The quoted string currently being processed has become more than 262 characters long.  You may have unbalanced quotation 
         marks.
MPRINT(GENDSHTM):   proc datasets library=sf32000 nolist;
MPRINT(GENDSHTM):   modify datasets;
MPRINT(GENDSHTM):   index delete memname;
NOTE: Index memname deleted.
MPRINT(GENDSHTM):   *--in case it already exists--;
MPRINT(GENDSHTM):   index create memname ;
NOTE: Simple index memname has been defined.
MPRINT(GENDSHTM):   quit;

NOTE: MODIFY was successful for SF32000.DATASETS.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.14 seconds
      cpu time            0.01 seconds
      

MPRINT(GENDSHTM):   *----Generate a Datasets.html file in the current directory based on dataset info from the datasets dataset and 
proc contents----;
MPRINT(GENDSHTM):   proc contents data=sf32000._all_ noprint out=datasets_contents( keep=memname memtype memlabel nobs crdate 
engine varnum where=(varnum=1 and lowcase(memname) ne 'datasets_contents') rename=(crdate=created));
MPRINT(GENDSHTM):   run;

NOTE: The data set WORK.DATASETS_CONTENTS has 53 observations and 7 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           7.52 seconds
      cpu time            5.03 seconds
      

MPRINT(GENDSHTM):   data sf32000.datasets_contents;
MPRINT(GENDSHTM):   length libname $8;
MPRINT(GENDSHTM):   retain libname "sf32000";
MPRINT(GENDSHTM):   set datasets_contents;
MPRINT(GENDSHTM):   memname=lowcase(memname);
MPRINT(GENDSHTM):   if memlabel="'" then memlabel=" ";
MPRINT(GENDSHTM):   drop varnum;
MPRINT(GENDSHTM):   format created datetime7.;
31                                                         The SAS System                               10:43 Tuesday, June 23, 2009

MPRINT(GENDSHTM):   run;

NOTE: There were 53 observations read from the data set WORK.DATASETS_CONTENTS.
NOTE: The data set SF32000.DATASETS_CONTENTS has 53 observations and 7 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      cpu time            0.01 seconds
      

MPRINT(GENDSHTM):   proc sort data=sf32000.datasets_contents;
MPRINT(GENDSHTM):   by memname;
MPRINT(GENDSHTM):   run;

NOTE: There were 53 observations read from the data set SF32000.DATASETS_CONTENTS.
NOTE: SAS sort was used.
NOTE: The data set SF32000.DATASETS_CONTENTS has 53 observations and 7 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.07 seconds
      cpu time            0.02 seconds
      

MPRINT(GENDSHTM):   data sf32000.datasets ;
MPRINT(GENDSHTM):   *<----New, 11/16/2006 11:54AM. We update the datasets dataset per contents data-;
MPRINT(GENDSHTM):   update sf32000.datasets (in=indatasets) sf32000.datasets_contents(rename=(memlabel=memlabelC));
MPRINT(GENDSHTM):   by memname;
MPRINT(GENDSHTM):   if memlabel=' ' then memlabel=memlabelC;
MPRINT(GENDSHTM):   drop memlabelC;
MPRINT(GENDSHTM):   if not indatasets then sortprio="9";
MPRINT(GENDSHTM):   if setgroup= '  ' then setgroup=geouniv;
MPRINT(GENDSHTM):   run;

INFO: Index memname selected for BY clause processing.
NOTE: There were 53 observations read from the data set SF32000.DATASETS.
NOTE: There were 53 observations read from the data set SF32000.DATASETS_CONTENTS.
NOTE: The data set SF32000.DATASETS has 53 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.08 seconds
      cpu time            0.04 seconds
      

MPRINT(GENDSHTM):   proc datasets library=sf32000 nolist;
MPRINT(GENDSHTM):   *--we just updated the dataset so we have to replace indices-;
MPRINT(GENDSHTM):   modify datasets;
MPRINT(GENDSHTM):   index delete dataset memname;
WARNING: No key variables have been defined for file DATASETS.
WARNING: No index named dataset.
MPRINT(GENDSHTM):   index create dataset=(libname memname) / unique;
NOTE: Composite index dataset has been defined.
MPRINT(GENDSHTM):   index create memname;
NOTE: Simple index memname has been defined.
MPRINT(GENDSHTM):   quit;

NOTE: MODIFY was successful for SF32000.DATASETS.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.13 seconds
      cpu time            0.03 seconds
32                                                         The SAS System                               10:43 Tuesday, June 23, 2009

      

MPRINT(GENDSHTM):   data allsets;
MPRINT(GENDSHTM):   update sf32000.datasets (where=(SortPrio ne "X" and not( memname=:'_template') and libname="sf32000" ) 
in=indatasets) sf32000.datasets_contents(rename=(memlabel=memlabelC));
INFO: Index dataset selected for WHERE clause optimization.
MPRINT(GENDSHTM):   by memname;
MPRINT(GENDSHTM):   if memlabel=' ' then memlabel=memlabelC;
MPRINT(GENDSHTM):   drop memlabelC;
MPRINT(GENDSHTM):   if not indatasets then sortprio="9";
MPRINT(GENDSHTM):   format created datetime7.;
MPRINT(GENDSHTM):   if indatasets then call symput('libpath',trim(libpath));
MPRINT(GENDSHTM):   if setgroup= '  ' then setgroup=geouniv;
MPRINT(GENDSHTM):   run;

INFO: Use of index dataset for WHERE clause optimization cancelled.
INFO: Index memname selected for BY clause processing.
NOTE: There were 53 observations read from the data set SF32000.DATASETS.
      WHERE (SortPrio not = 'X') and (not (memname=:'_template')) and (libname='sf32000');
NOTE: There were 53 observations read from the data set SF32000.DATASETS_CONTENTS.
NOTE: The data set WORK.ALLSETS has 53 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.08 seconds
      cpu time            0.03 seconds
      

MPRINT(GENDSHTM):   proc sort data=allsets;
MPRINT(GENDSHTM):   by SortPrio SetGroup Geouniv SubType descending years Memname;
MPRINT(GENDSHTM):   run;

NOTE: There were 53 observations read from the data set WORK.ALLSETS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ALLSETS has 53 observations and 46 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.13 seconds
      cpu time            0.04 seconds
      

MPRINT(GENDSHTM):   proc format;
MPRINT(GENDSHTM):   *--the $tb format will cause a character to be put in the cell so it will not be empty when value is blank;
MPRINT(GENDSHTM):   *--we leave all those blanks ON PURPOSE to make the format length sufficiently long.--;
MPRINT(GENDSHTM):   value $tb ' '='&nbsp;' other=[$char200.];
NOTE: Format $TB has been output.
MPRINT(GENDSHTM):   run;

NOTE: PROCEDURE FORMAT used (Total process time):
      real time           0.06 seconds
      cpu time            0.00 seconds
      

MPRINT(GENDSHTM):   data _null_;
MPRINT(GENDSHTM):   set allsets end=last;
MPRINT(GENDSHTM):   by SortPrio SetGroup;
MPRINT(GENDSHTM):   file "/pub/data/sf32000/Datasets.html" lrecl=500;
MPRINT(GENDSHTM):   if _n_=1 then do;
MPRINT(GENDSHTM):   put "<html> <head> <title> Datasets in directory /pub/data/sf32000 </title>" / '<META NAME="robots" 
33                                                         The SAS System                               10:43 Tuesday, June 23, 2009

CONTENT="noindex"> ' '<META NAME="author" CONTENT="gendshtm macro"> </head>';
MPRINT(GENDSHTM):   put '<body bgcolor="ffffaa"><center>';
MPRINT(GENDSHTM):   put '<h3><a href="http://mcdc2.missouri.edu">Missouri Census Data Center</a></h3>';
MPRINT(GENDSHTM):   put "<h4>Summary of Data Tables in <a 
href=""http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf32000"">/pub/data/sf32000</a> With Links to Detailed Metadata</h4>";
MPRINT(GENDSHTM):   put '	<TABLE  cellspacing=1 cellpadding=3 rules=GROUPS frame=BOX border=1 width="98%" bgcolor="#000000" 
bordercolor="#0000FF">';
MPRINT(GENDSHTM):   end;
MPRINT(GENDSHTM):   _n+1;
MPRINT(GENDSHTM):   if mod(_n,14)=1 or (first.setgroup and _n gt 6) then do;
MPRINT(GENDSHTM):   *<---repeat the headers every 14 observations or when a new group starts but no more than every 6---;
MPRINT(GENDSHTM):   _n=1;
MPRINT(GENDSHTM):   put '<thead><TR>';
WARNING: The quoted string currently being processed has become more than 262 characters long.  You may have unbalanced quotation 
         marks.
WARNING: The quoted string currently being processed has become more than 262 characters long.  You may have unbalanced quotation 
         marks.
WARNING: The quoted string currently being processed has become more than 262 characters long.  You may have unbalanced quotation 
         marks.
MPRINT(GENDSHTM):   put '<TD ALIGN=CENTER bgcolor="#D0D0D0"><font  face="Arial, Helvetica, Helv" size="2" color="#0033AA"  > 
<b>#</b></font></TD> <TD ALIGN=LEFT bgcolor="#D0D0D0"><font  face="Arial, Helvetica, Helv" size="2" color="#0033AA"    > <b>Name 
<br>(dexter link)</b></font></TD> <TD ALIGN=LEFT bgcolor="#D0D0D0" width="20%"><font  face="Arial, Helvetica, Helv" size="2" 
color="#0033AA" >  <b>Label</b></font>  </TD>' '<TD ALIGN=RIGHT bgcolor="#D0D0D0"><font  face="Arial, Helvetica, Helv" size="2" 
color="#0033AA"> <b>#Rows</b></font></TD> <TD ALIGN=RIGHT bgcolor="#D0D0D0"><font  face="Arial, Helvetica, Helv" size="2" 
color="#0033AA"   > <b>#Cols</b></font></TD> <TD ALIGN=CENTER bgcolor="#D0D0D0"><font  face="Arial, Helvetica, Helv" size="2" 
color="#0033AA"   > <b>Geographic<br>Universe</b></font></TD>' '<TD ALIGN=CENTER bgcolor="#D0D0D0" width="20%"><font  face="Arial, 
Helvetica, Helv" size="2" color="#0033AA">  <b>Units</b></font>  </TD> <TD ALIGN=CENTER bgcolor="#D0D0D0"><font  face="Arial, 
Helvetica, Helv" size="2" color="#0033AA"  > <b>Link to<br>Details</b></font></TD> <TD ALIGN=RIGHT bgcolor="#D0D0D0"><font  
face="Arial, Helvetica, Helv" size="2" color="#0033AA"   > <b>Size<br>in KB</b></font></TD> <TD ALIGN=CENTER 
bgcolor="#D0D0D0"><font  face="Arial, Helvetica, Helv" size="2" color="#0033AA"  > <b>Created</b></font></TD>  <TD ALIGN=LEFT 
bgcolor="#D0D0D0"><font  face="Arial, Helvetica, Helv" size="2" color="#0033AA"> <b>Eng</b></font></TD></TR></thead>';
MPRINT(GENDSHTM):   end;
MPRINT(GENDSHTM):   length _url $255;
MPRINT(GENDSHTM):   retain filetype "sf32000";
MPRINT(GENDSHTM):   
_url='http://mcdc2.missouri.edu/cgi-bin/broker?_PROGRAM=websas.dispdada.sas&_SERVICE='||"appdev"||'&libname='||trim(libname)|| 
'&memname='||trim(memname);
MPRINT(GENDSHTM):   *<=============platform dependent================;
MPRINT(GENDSHTM):   if scan(libpath,-1) ne filetype then _url=trim(_url)||'&libpath='||urlencode(trim(libpath));
MPRINT(GENDSHTM):   _url=quote(trim(_url));
MPRINT(GENDSHTM):   length _xref $200;
MPRINT(GENDSHTM):   length _view $1;
MPRINT(GENDSHTM):   if memtype='VIEW' then _view='1';
MPRINT(GENDSHTM):   else _view='0';
MPRINT(GENDSHTM):   *<--flag for uex2dex pgm--;
MPRINT(GENDSHTM):   *---no longer accessing URLxtract variable -- we always generate _xref pointing to dexter---;
MPRINT(GENDSHTM):   
_xref='"'||'http://mcdc2.missouri.edu/cgi-bin/broker?_PROGRAM=websas.uex2dex.sas&_SERVICE='||"appdev"||'&path='||"/pub/data/sf32000"
||'&dset='|| trim(memname)||'&view='||_view||'"';
MPRINT(GENDSHTM):   ***else _xref="http://mcdc2.missouri.edu/cgi-bin/callapp.pl?dir=&libpath"||'&dset='||trim(memname)|| 
'&form=xtract.html';
MPRINT(GENDSHTM):   put '<tr>' '<TD ALIGN=RIGHT bgcolor="#D0D0D0"><font  face="Arial, Helvetica, Helv" size="2" 
color="#0033AA"><b>' _n_ '</b></font></TD> <TD ALIGN=LEFT bgcolor="#FFFFFF"><font  face="Arial, Helvetica, Helv" size="2" 
color="#0000FF">' '<a href=' _xref '>' memname '</a></font></TD> ' / '<TD ALIGN=LEFT bgcolor="#FFFFFF" width="20%"><font  
face="Arial Narrow, Arial, Helvetica, Helv" size="2" color="#0000FF">' memlabel $tb. '</font></TD> <TD ALIGN=RIGHT 
bgcolor="#FFFFFF"><font  face="Arial, Helvetica, Helv" size="2" color="#0000FF">' nobs comma7. '</font></TD> <TD ALIGN=RIGHT 
34                                                         The SAS System                               10:43 Tuesday, June 23, 2009

bgcolor="#FFFFFF"><font  face="Arial, Helvetica, Helv" size="2" color="#0000FF">' nvars comma7. '</font></TD> <TD ALIGN=LEFT 
bgcolor="#FFFFFF"><font  face="Arial, Helvetica, Helv" size="2" color="#0000FF">' GeoUniv $tb. '</font></TD> <TD ALIGN=LEFT 
bgcolor="#FFFFFF" width="15%"><font  face="Arial Narrow, Arial, Helvetica, Helv" size="2" color="#0000FF">' Units $tb. 
'</font></TD>';
MPRINT(GENDSHTM):   put '<TD ALIGN=LEFT bgcolor="#FFFFFF"><font  face="Arial, Helvetica, Helv" size="2" color="#0000FF">';
MPRINT(GENDSHTM):   if GeoUniv ne " " or Description ne " " then put '<a href=' _url '>Details</a></font></TD>';
MPRINT(GENDSHTM):   else put '&nbsp;&nbsp; NA </font></td>';
MPRINT(GENDSHTM):   put '<TD ALIGN=RIGHT bgcolor="#FFFFFF"><font  face="Arial, Helvetica, Helv" size="1" color="#0000FF">' kbytes 
comma9. '</font></TD>  <TD ALIGN=RIGHT bgcolor="#FFFFFF"><font  face="Arial, Helvetica, Helv" size="2" color="#0000FF">' created 
datetime7. '</font></TD> <TD ALIGN=LEFT bgcolor="#FFFFFF"><font  face="Arial, Helvetica, Helv" size="2" color="#0000FF">' engine 
$6. '</font></TD>' ;
MPRINT(GENDSHTM):   put '</TR>';
MPRINT(GENDSHTM):   if last then do;
MPRINT(GENDSHTM):   put ' </TABLE>' / '</font></CENTER></body></html>';
MPRINT(GENDSHTM):   end;
MPRINT(GENDSHTM):   run;

NOTE: The file "/pub/data/sf32000/Datasets.html" is:
      File Name=/pub/data/sf32000/Datasets.html,
      Owner Name=john,Group Name=mcdc,
      Access Permission=rw-rw-r--

NOTE: 462 records were written to the file "/pub/data/sf32000/Datasets.html".
      The minimum record length was 5.
      The maximum record length was 500.
NOTE: There were 53 observations read from the data set WORK.ALLSETS.
NOTE: DATA statement used (Total process time):
      real time           0.09 seconds
      cpu time            0.06 seconds
      

1005       
1006       
1007            %include sascode(notify);
0
**** invoke_dosets (491662) has completed  23JUN09 10:43:46 syserr=0 sysrc= 0 *****

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
      real time           20.93 seconds
      cpu time            11.18 seconds