/****************************************************************/ /* S A S S A M P L E P R O G R A M */ /* */ /* NAME: POVERTY.SAS */ /* TITLE: USING EMBEDDED SQL, CALCULATES STATE POVERTY RATES */ /* AUTHOR: BILL STJOHN -- OPTIMISTGARAGE@YAHOO.COM */ /* HTTP://WWW.GEOCITIES.COM/OPTIMISTGARAGE */ /* KEYS: SQL SELECT WHERE ORDER HAVING AS */ /* PROCS: SQL */ /* DATA: Source: U.S. Census Bureau */ /* http://ferret.bls.census.gov/macro/032002/pov/new25_006.htm */ /****************************************************************/ data poverty; input state $ 1-26 total bnv bns brv brs anv ans arv ars; pctjab = ((anv - bnv) / total) * 100; /***************************************************************************************** /*Source: U.S. Census Bureau. http://ferret.bls.census.gov/macro/032002/pov/new25_006.htm /* /*Table 25. Poverty Status by State in 2001 /*(Numbers in thousands) /* Below poverty level | Below 125 Percent of Poverty /* | Number in poverty |Percent in poverty| Number below 125% |Percent below 125% /* | |Standard | | Standard| |Standard | |Standard /* Total| Value | Error | Value | Error| Value | Error | Value | Error /*WEIGHTED PERSON COUNT /*FAMILIES */ cards; Alabama 1239 157 13 12.7 1.00 223 16 18.0 1.15 Alaska 169 12 1 7.1 0.76 17 2 10.2 0.90 Arizona 1312 158 16 12.0 1.12 210 18 16.0 1.26 Arkansas 736 107 9 14.6 1.14 144 11 19.6 1.28 California 8093 762 40 9.4 0.46 1124 49 13.9 0.55 Colorado 1133 63 7 5.6 0.63 102 9 9.0 0.79 Connecticut 920 44 5 4.8 0.58 66 7 7.1 0.70 Delaware 214 11 2 5.3 0.70 16 2 7.6 0.83 District of Columbia 117 19 2 16.4 1.43 23 2 19.9 1.54 Florida 4390 459 26 10.5 0.55 642 31 14.6 0.64 Georgia 2234 253 23 11.3 0.96 334 26 15.0 1.08 Hawaii 296 29 3 9.8 0.96 40 4 13.5 1.11 Idaho 347 30 3 8.7 0.92 48 4 13.9 1.13 Illinois 3243 254 19 7.8 0.55 334 21 10.3 0.62 Indiana 1702 104 11 6.1 0.61 163 14 9.6 0.75 Iowa 793 54 6 6.8 0.71 77 7 9.7 0.83 Kansas 719 53 6 7.4 0.75 73 7 10.2 0.87 Kentucky 1125 117 11 10.4 0.91 179 13 15.9 1.09 Louisiana 1149 155 14 13.5 1.13 221 17 19.2 1.30 Maine 347 26 3 7.4 0.70 41 3 11.9 0.87 Maryland 1350 74 9 5.5 0.66 109 11 8.1 0.79 Massachusetts 1638 118 12 7.2 0.68 169 14 10.3 0.80 Michigan 2709 189 15 7.0 0.55 264 18 9.7 0.64 Minnesota 1343 71 8 5.3 0.61 99 10 7.4 0.72 Mississippi 770 127 11 16.5 1.25 186 13 24.1 1.44 Missouri 1492 105 11 7.0 0.72 143 13 9.6 0.83 Montana 251 24 3 9.5 0.99 40 3 15.9 1.24 Nebraska 449 33 4 7.3 0.80 41 4 9.2 0.89 Nevada 535 24 3 4.5 0.61 39 4 7.3 0.76 New Hampshire 329 14 2 4.4 0.58 21 2 6.2 0.68 New Jersey 2305 148 13 6.4 0.54 203 15 8.8 0.63 New Mexico 469 67 7 14.4 1.30 86 7 18.4 1.44 New York 4829 579 27 12.0 0.53 792 32 16.4 0.60 North Carolina 2194 208 17 9.5 0.73 288 20 13.1 0.84 North Dakota 179 20 2 11.1 0.91 23 2 12.9 0.97 Ohio 3111 247 18 8.0 0.56 330 21 10.6 0.64 Oklahoma 931 112 10 12.0 0.99 144 11 15.4 1.10 Oregon 900 77 8 8.6 0.86 112 10 12.4 1.01 Pennsylvania 3339 239 17 7.2 0.50 329 20 9.8 0.57 Rhode Island 261 20 2 7.5 0.73 26 2 9.9 0.83 South Carolina 1060 118 11 11.2 0.96 144 12 13.6 1.04 South Dakota 203 11 1 5.6 0.65 16 2 7.9 0.76 Tennessee 1617 190 17 11.7 1.01 273 21 16.9 1.18 Texas 5478 636 35 11.6 0.59 880 41 16.1 0.68 Utah 544 48 5 8.7 0.92 64 6 11.8 1.05 Vermont 164 11 1 6.6 0.71 18 2 10.7 0.89 Virginia 1917 137 15 7.2 0.75 191 18 10.0 0.87 Washington 1553 141 14 9.1 0.88 207 17 13.3 1.04 West Virginia 502 66 5 13.2 0.95 88 6 17.6 1.07 Wisconsin 1504 83 9 5.5 0.60 110 11 7.3 0.68 Wyoming 138 8 1 6.0 0.71 13 1 9.1 0.86 ; /*---------------------------------------------------*/ /*-- USING EMBEDDED SQL: --*/ /*-- Which states have poverty rates greater than --*/ /*-- the national average? --*/ /*---------------------------------------------------*/ proc sql; title 'U.S. STATES WITH THE HIGHEST PERCENTAGES OF PEOPLE AT RISK FOR POVERTY'; title2 'Sorted by percentage. Individuals at risk listed in THOUSANDS.'; select state, pctjab as at_risk format=6.2, (anv - bnv) as THOUSNDS from poverty having ((anv - bnv) / total) > (sum(anv) - sum(bnv))/sum(total) order by pctjab desc; quit;