Jump to main content.

State and County Emission Summaries

State Summary

The graph below shows state-level emissions grouped by major source sectors. The same information is also available for the individual counties below.


View the chart data in Microsoft Excel (Download Excel Viewer) View the chart data in HTML (New window opens)
County Summary The map below shows relative emission density (tons per square mile) by dividing counties into three groups, with the darker-shaded counties having higher relative emission density. This is not an indicator of air quality. To compare counties with respect to air quality and health-related information, visit the AirCompare Web site. To view county emission summaries, select a county from the drop-down menu or from the map. Results will appear beside the map.
Content-type: text/html Cache-Control: no-cache This request completed with errors. Sas Log for this Request NOTE: running request program dataprog.dw_do_all_emis.sas NOTE: %INCLUDE (level 1) file /public/data/mxplorer/sasprogs/dw_do_all_emis.sas is file /public/data/mxplorer/sasprogs/dw_do_all_emis.sas. 2 +options mprint symbolgen mlogic; 3 +%macro doall; 4 + 5 +%global pol stfips; 6 + 7 +ods listing close; 8 +ods html3 file=_webout(notop) 9 +rs=none 10 +path=&_tmpcat (url=&_replay); 11 + 12 +data _null_; 13 + length img1 $500; 14 + file _webout; 15 + 16 +put '<!DOCTYPE html 17 + PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" 18 + "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">'; 19 + 20 +put '<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">'; 21 +put '<!-- #BeginTemplate "/Templates/emis_template.dwt" -->'; 22 +put '<!-- DW6 -->'; 23 +put '<!-- EPA Template version 3.2.1, 28 June 2006 -->'; 24 +put '<head>'; 25 + put '<!-- #BeginEditable "doctitle" -->'; 26 + put '<title>State and County Emission Summaries \| Air Emission Sources \| US EPA</title>'; 27 + put '<meta name="DC.description" content="" />'; 28 + put '<meta name="Keywords" content="" />'; 29 + put '<!-- #EndEditable -->'; 30 + put '<!-- #BeginEditable "metaElements" -->'; 31 + put '<meta name="DC.title" content="" />'; 32 + put '<meta name="DC.subject" content="" />'; 33 + put '<meta name="DC.type" content="" />'; 34 + put '<!-- For date metadata, use the format YYYY-MM-DD -->'; 35 + put '<meta name="DC.date.modified" content="" />'; 36 + put '<meta name="DC.date.created" content="" />'; 37 + put '<meta name="DC.date.reviewed" content="" />'; 38 + put '<!-- #EndEditable -->'; 39 + 40 + put '<meta name="DC.language" content="en" />'; 41 + put '<meta name="DC.creator" content="" />'; 42 + put '<link rel="schema.DC" href="http://purl.org/dc/elements/1.1/" />'; 43 + put '<link rel="meta" href="http://www.epa.gov/labels.rdf" type="application/rdf+xml" title="ICRA labels" />'; 44 + put '<meta http-equiv="Content-Style-Type" content="text/css" />'; 45 + put '<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />'; 46 + 47 + put '<style type="text/css" media="screen">@import "http://www.epa.gov/epafiles/s/epa.css";</style>'; 48 + put '<!--[if lt IE 7]>'; 49 + put '<link rel="stylesheet" type="text/css" href="http://www.epa.gov/epafiles/s/ie.css" />'; 50 + put '<![endif]-->'; 51 + put '<link rel="stylesheet" type="text/css" media="print" href="http://www.epa.gov/epafiles/s/print.css" />'; 52 + put '<script type="text/javascript" src="http://www.epa.gov/epafiles/js/epa-core.js"></script>'; 53 + put '<script type="text/javascript" src="http://www.epa.gov/epafiles/js/extra.js"></script>'; 54 +put '</head>'; 55 + 56 +put '<body>'; 57 +put '<p class="skip"><a id="skiptop" href="#content" title="Jump to main content.">Jump to main content.</a></p>'; 58 + 59 +put '<div id="header">'; 60 +put '<!-- START EPA HEADER -->'; 61 + 62 + put '<div id="logo">'; 63 +put '<a href="http://www.epa.gov/" title="US EPA home page">'; 64 +put '<img src="http://www.epa.gov/epafiles/images/logo_epaseal.gif" alt="[logo] US EPA" width="100" height="111" />'; 65 +put '</a>'; 66 +put '</div>'; 67 + 68 + put '<div id="areaname">'; 69 +put '<!-- START AREA NAME -->'; 70 + put '<p>Air Emission Sources</p>'; 71 + put '</div>'; 72 +put '<!-- END AREA NAME -->'; 73 + 74 + put '<!-- START SEARCH CONTROLS -->'; 75 + put '<form id="EPAsearch" method="get" action="http://nlquery.epa.gov/epasearch/epasearch">'; 76 + put '<!-- START AREA SPECIFIC LINKS AND SEARCH BOX -->'; 77 + put '<!-- CHANGE links to point to your own recent additions and contact pages -->'; 78 + put "<!-- REMOVE recent additions link if your area doesn't have one -->"; 79 + put '<p><a href="http://www.epa.gov/air/emissions/contact.htm">Contact Us</a>'; 80 + put '<span class="search">'; 81 + put '<strong>Search:</strong>'; 82 + put '<input name="typeofsearch" id="EPAall" type="radio" value="epa"/>'; 83 + put '<label for="EPAall">All EPA</label>'; 84 + put '<input name="typeofsearch" id="Areaall" type="radio" value="area" checked="checked" />'; 85 + put '<label for="Areaall">This Area</label>'; 86 + put '<input name="querytext" id="searchbox" value="" />'; 87 + put '<input name="submit" id="searchbutton" type="submit" value="Go" />'; 88 + put '<input type="hidden" name="fld" value="YOUR TSSMS HERE" />'; 89 + put '<input type="hidden" name="areaname" value="AREA NAME HERE" />'; 90 + put '<input type="hidden" name="areacontacts" value="AREA CONTACT US LINK HERE" />'; 91 + put '<!-- AREA ADVANCED SEARCH URL HERE (OPTIONAL) -->'; 92 + put '<input type="hidden" name="areasearchurl" value="" />'; 93 + put '<!-- THE REMAINING HIDDEN INPUTS ARE USED BY THE SEARCH ENGINE - DO NOT EDIT -->'; 94 + put '<input type="hidden" name="result_template" value="epafiles_default.xsl" />'; 95 + put '<input type="hidden" name="filter" value="samplefilt.hts" />'; 96 + put '</span>'; 97 + put '</p>'; 98 + put '</form>'; 99 +put '<!-- END SEARCH CONTROLS -->'; 100 + 101 + put '<ul>'; put '<!-- BEGIN BREADCRUMBS -->'; 102 + put '<li class="first">You are here:<a href="http://www.epa.gov/">EPA Home</a></li>'; 103 + put '<!-- START AREA BREADCRUMBS -->'; 104 + put '<!-- #BeginEditable "breadcrumbs" -->'; 105 + put '<li>'; 106 + put '<a href="http://www.epa.gov/air/">Air & Radiation</a></li>'; 107 + put '<li><a href="http://www.epa.gov/air/emissions/index.htm">Air Emission Sources</a></li>'; 108 + put '<li>State and County Emission Summaries</li>'; 109 + put '<!-- #EndEditable -->'; 110 + put '<!-- END AREA BREADCRUMBS -->'; 111 + put '</ul>'; put '<!-- END BREADCRUMBS -->'; 112 +put '</div>'; 113 + 114 +put '<!-- END EPA HEADER -->'; 115 + 116 +put '<hr class="skip" />'; 117 + 118 +put '<p class="skip">'; 119 +put '<a name="pagecontents" id="pagecontents">'; 120 +put '</a>'; 121 +put '<a name="pagetop" id="pagetop">'; 122 +put '</a>'; 123 +put '</p>'; 124 + 125 +put '<div id="content">'; 126 +put '<!-- BEGIN CONTENT -->'; 127 + put '<!-- EPA SITE-WIDE ANNOUNCEMENTS - DO NOT REMOVE - this code is used for emergency messages -->'; 128 + put '<!-- If this page is a Sub-Office/Sub-Region/Center/Lab/Topic home page, CHANGE "sitewidec" TO "sitewideb" -->'; 129 + put '<p id="sitewidec">'; 130 +put '</p>'; 131 + 132 + put '<!-- BEGIN PAGE NAME -->'; 133 + put '<h1>'; 134 + put '<!-- #BeginEditable "PageName" -->State and County Emission Summaries<!-- #EndEditable -->'; 135 + put '</h1>'; 136 + put '<!-- END PAGE NAME -->'; 137 + 138 + put '<!-- BEGIN CONTENT AREA -->'; 139 + put '<!-- #BeginEditable "content" -->'; 140 + 141 + put '<h4>State Summary</h4>'; 142 + put '<p>The graph below shows state-level emissions grouped by major source sectors.'; 143 + put 'The same information is also available for the individual counties below.</p>'; 144 + img1='<img src="http://www.epa.gov/cgi-bin/broker?_service=data'\|\| 145 + '&_program=dataprog.dw_12cat_state.sas'\|\| 146 + '&_debug=0'\|\| 147 + '&pol='\|\|"&pol"\|\| 148 + '&stfips='\|\|"&stfips"\|\| 149 + '" border="0" vspace="2" alt="State-level Emissions Chart">'; 150 + put '<table>'; 151 + put '<tr><td>'; 152 + put img1; 153 + put '<img src="http://www.epa.gov/air/emissions/images/spacer.gif" alt="Note to users of screen readers: The following links provide the chart data for the state-level emissions chart." 153!+/>'; 154 + put '</td></tr>'; 155 + put '<tr><td>'; 156 + put '<br />'; 157 + link1='<a href="http://www.epa.gov/cgi-bin/broker?_service=data&_program=dataprog.dw_12cat_state_table.sas&pol='\|\|"&pol"\|\|'&stfips='\|\|"&stfips"\|\|'&query=csv">View the chart data in 157!+Microsoft Excel</a>'; 158 + put link1; 159 + put ' '; 160 + link1a='<font size=1>(<a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=c8378bf4-996c-4569-b547-75edbd03aaf0&DisplayLang=en">Download Excel Viewer</a>)</font>'; 161 + link1b='<a href="http://www.epa.gov/epahome/exitepa.htm" title="EPA External Link Disclaimer"><img src="http://www.epa.gov/epafiles/images/epafiles_misc_exitepadisc.gif" width="87" 161!+height="13" alt="Exit EPA Disclaimer" /></a>'; 162 + put link1a link1b; 163 + put '<br />'; 164 + link2='<a href="http://www.epa.gov/cgi-bin/broker?_service=data&_program=dataprog.dw_12cat_state_table.sas&pol='\|\|"&pol"\|\|'&stfips='\|\|"&stfips"\|\|'&query=htm&_debug=0" target="_blank">View 164!+the chart data in HTML</a>'; 165 + put link2; 166 + put ' '; 167 + put '<font size=1>(New window opens)</font>'; 168 + put '</td></tr>'; 169 + put '<tr><td colspan="2">'; 170 +run; 171 + 172 +%start map stuff; 173 +%let year=2002; 174 + 175 +%let year=2002; 176 + 177 +%if &pol=225 %then %do; %let poll=Carbon Monoxide; %end; 178 +%if &pol=219 %then %do; %let poll=Lead; %end; 179 +%if &pol=227 %then %do; %let poll=Nitrogen Oxides; %end; 180 +%if &pol=229 %then %do; %let poll=VOCs; %end; 181 +%if &pol=230 %then %do; %let poll=PM10; %end; 182 +%if &pol=231 %then %do; %let poll=PM25; %end; 183 +%if &pol=228 %then %do; %let poll=Sulfur Dioxide; %end; 184 + 185 +prep maps; 186 +have to get PR from the counties map data set; 187 +data stmap; 188 + length fips $5.; 189 + %if &stfips=72 or &stfips=02 %then %do; 190 + set maps.counties; 191 + if x>0; 192 + %end; 193 + %else %do; 194 + set maps.county; 195 + %end; 196 + stfips=put(state,z2.); 197 + ctyfips=put(county,z3.); 198 + fips=put(state,z2.)\|\|put(county,z3.); 199 + if stfips="&stfips"; 200 + ******new code to handle dade county FL; 201 + if stfips='12' and ctyfips='025' then do; 202 + ctyfips='086'; county=86; 203 + end; 204 +run; 205 +proc sort; by stfips ctyfips; run; 206 +proc sort data=maps.uscity out=preread(keep=state city lat long pop capital); 207 + by descending pop; 208 + where state=&stfips; 209 +run; 210 +data cityread; 211 + keep state city x y; 212 + set maps.uscity; contains unprojected coordinates in decimal degrees; 213 + set preread; 214 + if _n_ le 2 or capital='Y'; 215 + if state="&stfips" and (capital='Y' or pop>250000); 216 + convert unproj degrees to radians; 217 + y=latarcos(-1)/180; 218 + x=longarcos(-1)/180; 219 +run; 220 +data both; 221 + set stmap cityread; 222 +run; 223 +proc gproject data=both out=bothp; 224 + id state; 225 +run; 226 + 227 +***** split back out; 228 +data newmap newcities; 229 + set bothp; 230 + if city=' ' then output newmap; 231 + else output newcities; 232 +run; 233 + 234 +data names; 235 + keep ctyfips ctyname; 236 + set aqtag.county_names; 237 + if substr(fips,1,2)="&stfips"; 238 + ctyfips=substr(fips,3,3); 239 + call symput('stname',trim(left(put(stnamel(stname),$50.)))); 240 +run; 241 +proc sort data=names; by ctyfips; run; 242 +proc sort data=newmap; by ctyfips; run; 243 + 244 +data newstate; 245 + drop density; 246 + length htmlvar $600.; 247 + merge newmap (in=in1) names; 248 + by ctyfips; 249 + if in1; 250 + drillvar='href="http://www.epa.gov/cgi-bin/broker?_service=data'\|\| 251 + '&_PROGRAM=dataprog.dw_12cat_cty.sas&_debug=0&ctyfips='\|\|ctyfips\|\| 252 + '&stfips='\|\|trim(left(put(&stfips,z2.)))\|\| 253 + '&ctyname='\|\|trim(left(ctyname))\|\| 254 + '&pol='\|\|trim(left(&pol))\|\|'" target="myFrame"'; 255 + altvar='alt="'\|\|trim(left(ctyname))\|\|'"'; 256 + htmlvar=trim(left(drillvar)) \|\|' '\|\| trim(left(altvar)); 257 +run; 258 + 259 +proc sql; 260 + create table nameslist as 261 + select distinct ctyname, ctyfips 262 + from newstate; 263 +run; 264 + 265 +%build select list; 266 +data _null_; 267 + file _webout; 268 + set nameslist end=last; 269 + if _n_=1 then do; 270 + put '<h4>County Summary</h4>'; 271 + put '<form method="post" action="http://www.epa.gov/cgi-bin/redirect.pl" target="myFrame">'; 272 + put '<p>The map below shows relative emission density (tons per square mile) by dividing counties into three groups, with the darker-shaded counties having higher relative emission 272!+density. '; 273 + put 'This is not an indicator of air quality. To compare counties with respect to air quality and health-related information, visit the '; 274 + put '<a href="http://www.epa.gov/aircompare/">AirCompare Web site</a>. '; 275 + put 'To view county emission summaries, select a county from the drop-down menu or from the map. Results will appear beside the map.</p>'; 276 + put '<label for="list">Results will appear beside the map.</label> '; 277 + put '<select name="Target" id="list">'; 278 + end; 279 + option='<option value="http://www.epa.gov/cgi-bin/broker?_service=data'\|\|'&'\|\| 280 + '_program=dataprog.dw_12cat_cty.sas'\|\|'&'\|\| 281 + '_debug=0'\|\|'&'\|\| 282 + 'ctyfips='\|\|ctyfips\|\|'&'\|\| 283 + 'stfips='\|\|trim(left(put(&stfips,z2.)))\|\|'&'\|\| 284 + 'ctyname='\|\|trim(left(ctyname))\|\|'&'\|\| 285 + 'pol='\|\|trim(left(&pol))\|\| 286 + '">'\|\|trim(left(ctyname))\|\|'</option>'; 287 + put option; 288 + if last then do; 289 + put '</select>'; 290 + put '<input type="submit" value="GO" name="submit" />'; 291 + put '</form>'; 292 + put '<tr><td>'; 293 + end; 294 +run; 295 + 296 +goptions reset=all /transparency/ cells ctext=black htext=1 ftext='swiss' fontres=presentation 297 + cback=white dev=gif /hpos=100 vpos=40/ /gsfname=_webout/ xpixels=460 ypixels=360; 298 + 299 +*** now add annotation; 300 +data cities; 301 + length color function style $8 text $25; 302 + retain function 'label' xsys ysys '2' hsys '3' when 'a'; 303 + set newcities; 304 + if state=&stfips; 305 + if capital='Y' then do; 306 + color='black'; size=2; text='V'; 307 + position='5'; style='marker'; output; 308 + color='black'; text=city; size=5; 309 + position='e'; style='swiss'; output; 310 + end; 311 + else do; 312 + color='black'; size=2; text='W'; 313 + position='5'; style='marker'; output; 314 + color='black'; text=city; size=4; 315 + position='e'; style='swiss'; output; 316 + end; 317 +run; 318 + 319 +now add emiss density data; 320 +%if &pol=219 %then %do; 321 +data emis; 322 + set aqtag.lead2002v3_ctysum; 323 + if state_fips=&stfips; 324 +run; 325 +%end; 326 +%else %do; 327 +%include '/public/data/mxplorer/sasprogs/pw_airqst.sas'; 328 +proc sql; 329 + connect to oracle (user=&userid password=&userpasswd path="&path" buffsize=100); 330 +create table emis as 331 +select * from connection to oracle ( 332 +/* original query 333 +select county.state_fips, 334 + county.county_fips, 335 + county.county_surface_area, 336 + emission_county_summary.emission_amt 337 +from aq_target.emission_county_summary emission_county_summary, 338 + aq_target.county county, 339 + aq_target.pollutant pollutant 340 +where emission_county_summary.pollutant_id=pollutant.pollutant_id and 341 + emission_county_summary.county_id=county.county_id and 342 + emission_county_summary.year_id=&year and 343 + pollutant.pollutant_id=%quote(%'&pol%') and 344 + county.state_fips=%quote(%'&stfips%') 345 +order by 1,2 346 +/ 347 +/new query from Brad and EJ/ 348 +select state_fips, county_fips, county_surface_area, emission_amt 349 + from aq_target.MV_NEI_CNTY_SUMMARY where state_fips = %quote(%'&stfips%') and 350 +pollutant_id = %quote(%'&pol%') and year_id=&year 351 + order by 1,2 352 +); 353 +%put &sqlxrc; 354 +debug sql; 355 +%put &sqlxmsg; 356 +debug sql; 357 +disconnect from oracle; 358 +quit; 359 +%end; 360 + 361 +data mapdata; 362 + keep state county emission_amt county_surface_area; 363 + set emis; 364 + state=input(state_fips,2.); 365 + county=input(county_fips,3.); 366 +run; 367 + 368 +proc means data=mapdata noprint; 369 + by state county; 370 + var emission_amt county_surface_area; 371 + output out=mapdata2 sum(emission_amt)=cty_tot median(county_surface_area)=area; 372 +run; 373 + 374 +data mapdata3; 375 + keep state county density; 376 + set mapdata2; 377 + density=cty_tot/area; 378 +run; 379 + 380 +data mapdata4; 381 + length state 5. county 6.; 382 + merge mapdata3 newstate; 383 + by state county; 384 +run; 385 +reds; 386 +pattern1 value=msolid color=cxcc9999;light; 387 +pattern2 value=msolid color=cxcc6699; 388 +pattern3 value=msolid color=cxcc0033;dark; 389 + 390 +greens; 391 +pattern1 value=msolid color=cxccff99;light; 392 +pattern2 value=msolid color=cx99cc66; 393 +pattern3 value=msolid color=cx006633;dark; 394 + 395 +blues; 396 +pattern1 value=msolid color=cx99cccc;light; 397 +pattern2 value=msolid color=cx6699cc; 398 +pattern3 value=msolid color=cx3366cc;dark; 399 + 400 +purples; 401 +pattern1 value=msolid color=cxccccff;light; 402 +pattern2 value=msolid color=cx9999cc; 403 +pattern3 value=msolid color=cx6666cc;dark; 404 + 405 +legend1 label=(f=swiss h=3pct "&poll Emissions in &year (Tons per Square Mile)") value=(h=3pct) down=3; 406 +--------------------------MAP IT-----------------------------; 407 +PROC GMAP MAP=newstate DATA=mapdata4 ALL; 408 + %if &pol=219 %then %do; 409 + format density 11.9; 410 + %end; 411 + %else %do; 412 + format density 10.2; 413 + %end; 414 +ID state county; 415 +CHORO density / cempty=black html=htmlvar 416 + coutline=black annotate=cities legend=legend1 levels=3; 417 +run; 418 +quit; 419 + 420 +data _null_; 421 + file _webout; 422 + put '</td>'; 423 + put '<td>'; 424 + put '<iframe name="myFrame" width="470" height="360" scrolling="no" frameborder="1" marginwidth="0" marginheight="0" style=" background:white; margin:0px; padding:0px; 424!+"></iframe></td></tr>'; 425 + put '</table>'; 426 + 427 + put '<!-- #EndEditable -->'; 428 + put '<!-- BEGIN AREA FOOTER - ADD text/links for area footer within this paragraph tag -->'; 429 + put '<p id="areafooter">If there is an Area footer, put it here.</p>'; 430 + put '<!-- END AREA FOOTER -->'; 431 +put '</div>'; 432 +put '<!-- END CONTENT -->'; 433 + 434 +put '<hr class="skip" />'; 435 + 436 +put '<div id="area-nav">'; 437 +put '<!-- BEGIN AREA MAIN NAVIGATION -->'; 438 + put '<h3 class="skip">Local Navigation</h3>'; 439 + put '<ul>'; 440 + put '<li>';put '<a href="http://www.epa.gov/air/emissions/index.htm">Air Emission Sources Home</a>';put '</li>'; 441 + put '<li>';put '<a href="http://www.epa.gov/air/emissions/basic.htm">Basic Information</a>';put '</li>'; 442 + put '<li>';put '<a href="http://www.epa.gov/air/emissions/where.htm">Where You Live</a>';put '</li>'; 443 + put '<li>';put '<a href="http://www.epa.gov/air/emissions/co.htm">Carbon Monoxide</a>';put '</li>'; 444 + put '<li>';put '<a href="http://www.epa.gov/air/emissions/pb.htm">Lead</a>';put '</li>'; 445 + put '<li>';put '<a href="http://www.epa.gov/air/emissions/nox.htm">Nitrogen Oxides</a>';put '</li>'; 446 + put '<li>';put '<a href="http://www.epa.gov/air/emissions/voc.htm">Volatile Organic Compounds</a>';put '</li>'; 447 + put '<li>';put '<a href="http://www.epa.gov/air/emissions/pm.htm">Particulate Matter</a>';put '</li>'; 448 + put '<li>';put '<a href="http://www.epa.gov/air/emissions/so2.htm">Sulfur Dioxide</a>';put '</li>'; 449 + put '<li>';put '<a href="http://www.epa.gov/air/emissions/multi.htm">Multipollutant Comparison</a>';put'</li>'; 450 + put '</ul>'; 451 +put '</div>'; put '<!-- END AREA MAIN NAVIGATION -->'; 452 + 453 +put '<hr class="skip" />'; 454 + 455 +put '<div id="footer">'; 456 +put '<!-- BEGIN FOOTER -->'; 457 + put '<ul id="globalfooter">'; 458 + put '<li>';put '<a href="http://www.epa.gov/">EPA Home</a>';put '</li>'; 459 + put '<li>';put '<a href="http://www.epa.gov/epafiles/usenotice.htm">Privacy and Security Notice</a>';put '</li>'; 460 + put '<!-- CHANGE link to point to your own contact page -->'; 461 + put '<li class="last">';put '<a href="#">Contact Us</a>';put '</li>'; 462 + put '</ul>'; 463 +put '</div>'; 464 +put '<!-- END FOOTER -->'; 465 + 466 +put '<p class="skip">'; 467 +put '<a id="skipbot" href="#content" title="Jump to main content.">Jump to main content.</a>'; 468 +put '</p>'; 469 +put '</body>'; 470 +put '<!-- #EndTemplate -->'; 471 +put '</html>'; 472 +run; 473 +ods html3 close; 474 +%mend doall; 475 +%doall NOTE: Writing HTML3 Body file: _WEBOUT NOTE: The file _WEBOUT is: Access Method=Application Server Access Method, Network connection type=Full Duplex, Peer IP address=::ffff:134.67.99.205 NOTE: 127 records were written to the file _WEBOUT. The minimum record length was 4. The maximum record length was 384. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds The SAS System NOTE: There were 55534 observations read from the data set MAPS.COUNTY. NOTE: The data set WORK.STMAP has 266 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.47 seconds cpu time 0.07 seconds NOTE: There were 266 observations read from the data set WORK.STMAP. NOTE: The data set WORK.STMAP has 266 observations and 7 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds NOTE: There were 60 observations read from the data set MAPS.USCITY. WHERE state=33; NOTE: The data set WORK.PREREAD has 60 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.40 seconds cpu time 0.02 seconds NOTE: There were 60 observations read from the data set WORK.PREREAD. NOTE: The data set WORK.CITYREAD has 3 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: There were 266 observations read from the data set WORK.STMAP. NOTE: There were 3 observations read from the data set WORK.CITYREAD. NOTE: The data set WORK.BOTH has 269 observations and 12 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds NOTE: PARALLEL1 = 43.34897036. NOTE: PARALLEL2 = 44.653317925. NOTE: There were 269 observations read from the data set WORK.BOTH. NOTE: The data set WORK.BOTHP has 269 observations and 12 variables. NOTE: PROCEDURE GPROJECT used (Total process time): The SAS System real time 0.01 seconds cpu time 0.01 seconds NOTE: There were 269 observations read from the data set WORK.BOTHP. NOTE: The data set WORK.NEWMAP has 266 observations and 12 variables. NOTE: The data set WORK.NEWCITIES has 3 observations and 12 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.00 seconds NOTE: Data file AQTAG.COUNTY_NAMES.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 3227 observations read from the data set AQTAG.COUNTY_NAMES. NOTE: The data set WORK.NAMES has 10 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.27 seconds cpu time 0.02 seconds NOTE: There were 10 observations read from the data set WORK.NAMES. NOTE: The data set WORK.NAMES has 10 observations and 2 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds NOTE: There were 266 observations read from the data set WORK.NEWMAP. NOTE: The data set WORK.NEWMAP has 266 observations and 12 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 475:1 WARNING: Multiple lengths were specified for the BY variable ctyfips by input data sets. This may cause unexpected results. WARNING: The variable density in the DROP, KEEP, or RENAME list has never been referenced. NOTE: There were 266 observations read from the data set WORK.NEWMAP. NOTE: There were 10 observations read from the data set WORK.NAMES. NOTE: The data set WORK.NEWSTATE has 266 observations and 16 variables. NOTE: DATA statement used (Total process time): The SAS System real time 0.12 seconds cpu time 0.01 seconds NOTE: Table WORK.NAMESLIST created, with 10 rows and 2 columns. NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. NOTE: PROCEDURE SQL used (Total process time): real time 0.02 seconds cpu time 0.00 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 475:1 NOTE: The file _WEBOUT is: Access Method=Application Server Access Method, Network connection type=Full Duplex, Peer IP address=::ffff:134.67.99.205 NOTE: 21 records were written to the file _WEBOUT. The minimum record length was 7. The maximum record length was 218. NOTE: There were 10 observations read from the data set WORK.NAMESLIST. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 3 observations read from the data set WORK.NEWCITIES. NOTE: The data set WORK.CITIES has 6 observations and 22 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds NOTE: %INCLUDE (level 2) file /public/data/mxplorer/sasprogs/pw_airqst.sas is file /public/data/mxplorer/sasprogs/pw_airqst.sas. 476 +%macro pw; 477 +%global userid userpasswd path; 478 +%let userid=lqn; 479 +%let userpasswd=Gibbitz99; 480 +%let path=airqst.percheron; 481 +%mend pw; The SAS System 482 +%pw run; NOTE: %INCLUDE (level 2) ending. NOTE: %INCLUDE (level 1) resuming. ERROR: ORACLE connection error: ORA-28001: the password has expired.* NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. NOTE: Statement not executed due to NOEXEC option. -28001 ORA-28001: the password has expired NOTE: Statement not executed due to NOEXEC option. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.16 seconds cpu time 0.01 seconds ERROR: File WORK.EMIS.DATA does not exist. NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 482:97 482:128 WARNING: The variable emission_amt in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable county_surface_area in the DROP, KEEP, or RENAME list has never been referenced. NOTE: The SAS System stopped processing this step because of errors. NOTE: SAS set option OBS=0 and will continue to check statements. This may cause NOTE: No observations in data set. WARNING: The data set WORK.MAPDATA may be incomplete. When this step was stopped there were 0 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds ERROR: Variable EMISSION_AMT not found. ERROR: Variable COUNTY_SURFACE_AREA not found. ERROR: Variable EMISSION_AMT not found. ERROR: Variable COUNTY_SURFACE_AREA not found. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.MAPDATA2 may be incomplete. When this step was stopped there were 0 observations and 0 variables. NOTE: PROCEDURE MEANS used (Total process time): real time 0.01 seconds cpu time 0.00 seconds WARNING: The variable state in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable county in the DROP, KEEP, or RENAME list has never been referenced. The SAS System NOTE: The data set WORK.MAPDATA3 has 0 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds NOTE: The data set WORK.MAPDATA4 has 0 observations and 17 variables. NOTE: DATA statement used (Total process time): real time 0.14 seconds cpu time 0.00 seconds WARNING: RUN statement ignored due to previous errors. Submit QUIT; to terminate the procedure. NOTE: PROCEDURE GMAP used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 483 +run; NOTE: %INCLUDE (level 1) ending. NOTE: request has completed