/* This SAS program will make a SAS DATASET from the three Segment files *.pl */ /* User will have to modify the libname,data and infile statements to conform to his environment*/ /* This modification needs to be done in each of the three infile statements */ /* Also change dataset name in the merge stage at the end of the program to conform the user's dataset name*/ /* Checks are made on LOCRECNO as the three files are conbined */ /* User should check SAS log*/ /* */ /* Code modified by todd.graham@metc.state.mn.us 2/15/2011 to format fields in File01 and 02 as NUMERIC variables (instead of Character Text) */ /* Also in Geo file: AREALAND, AREAWATR, POP100, HU100, INTPTLAT, INTPTLON */ libname CEN2010 'N:\CommDev\SAS\census\cen2010'; /* Confirm physical location of your new LIB */ data work.header; infile 'N:\CommDev\Research\Research\Census Data\Census 2010\TXgeo2010.pl' lrecl = 482 missover pad; /* Confirm physical location of your PL file downloads */ INPUT @1 FILEID $6. /*File Identification*/ @7 STUSAB $2. /*State/US-Abbreviation (USPS)*/ @9 SUMLEV $3. /*Summary Level*/ @12 GEOCOMP $2. /*Geographic Component*/ @14 CHARITER $3. /*Characteristic Iteration*/ @17 CIFSN $2. /*Characteristic Iteration File Sequence Number*/ @19 LOGRECNO $7. /*Logical Record Number*/ @26 REGION $1. /*Region*/ @27 DIVISION $1. /*Division*/ @28 STATE $2. /*State (FIPS)*/ @30 COUNTY $3. /*County*/ @33 COUNTYCC $2. /*FIPS County Class Code*/ @35 COUNTYSC $2. /*County Size Code*/ @37 COUSUB $5. /*County Subdivision (FIPS)*/ @42 COUSUBCC $2. /*FIPS County Subdivision Class Code*/ @44 COUSUBSC $2. /*County Subdivision Size Code*/ @46 PLACE $5. /*Place (FIPS)*/ @51 PLACECC $2. /*FIPS Place Class Code*/ @53 PLACESC $2. /*Place Size Code*/ @55 TRACT $6. /*Census Tract*/ @61 BLKGRP $1. /*Block Group*/ @62 BLOCK $4. /*Block*/ @66 IUC $2. /*Internal Use Code*/ @68 CONCIT $5. /*Consolidated City (FIPS)*/ @73 CONCITCC $2. /*FIPS Consolidated City Class Code*/ @75 CONCITSC $2. /*Consolidated City Size Code*/ @77 AIANHH $4. /*American Indian Area/Alaska Native Area/Hawaiian Home Land (Census)*/ @81 AIANHHFP $5. /*American Indian Area/Alaska Native Area/Hawaiian Home Land (FIPS)*/ @86 AIANHHCC $2. /*FIPS American Indian Area/Alaska Native Area/Hawaiian Home Land Class Code*/ @88 AIHHTLI $1. /*American Indian Trust Land/Hawaiian Home Land Indicator*/ @89 AITSCE $3. /*American Indian Tribal Subdivision (Census)*/ @92 AITS $5. /*American Indian Tribal Subdivision (FIPS)*/ @97 AITSCC $2. /*FIPS American Indian Tribal Subdivision Class Code*/ @99 TTRACT $6. /*Tribal Census Tract*/ @105 TBLKGRP $1. /*Tribal Block Group*/ @106 ANRC $5. /*Alaska Native Regional Corporation (FIPS)*/ @111 ANRCCC $2. /*FIPS Alaska Native Regional Corporation Class Code*/ @113 CBSA $5. /*Metropolitan Statistical Area/Micropolitan Statistical Area*/ @118 CBSASC $2. /*Metropolitan Statistical Area/Micropolitan Statistical Area Size Code*/ @120 METDIV $5. /*Metropolitan Division*/ @125 CSA $3. /*Combined Statistical Area*/ @128 NECTA $5. /*New England City and Town Area*/ @133 NECTASC $2. /*New England City and Town Area Size Code*/ @135 NECTADIV $5. /*New England City and Town Area Division*/ @140 CNECTA $3. /*Combined New England City and Town Area*/ @143 CBSAPCI $1. /*Metropolitan Statistical Area/Micropolitan Statistical Area Principal City Indicator*/ @144 NECTAPCI $1. /*New England City and Town Area Principal City Indicator*/ @145 UA $5. /*Urban Area*/ @150 UASC $2. /*Urban Area Size Code*/ @152 UATYPE $1. /*Urban Area Type*/ @153 UR $1. /*Urban/Rural*/ @154 CD $2. /*Congressional District (111th)*/ @156 SLDU $3. /*State Legislative District (Upper Chamber) (Year 1)*/ @159 SLDL $3. /*State Legislative District (Lower Chamber) (Year 1)*/ @162 VTD $6. /*Voting District*/ @168 VTDI $1. /*Voting District Indicator*/ @169 RESERVE2 $3. /*Reserved*/ @172 ZCTA5 $5. /*ZIP Code Tabulation Area (5 digit)*/ @177 SUBMCD $5. /*Subminor Civil Division (FIPS)*/ @182 SUBMCDCC $2. /*FIPS Subminor Civil Division Class Code*/ @184 SDELM $5. /*School District (Elementary)*/ @189 SDSEC $5. /*School District (Secondary)*/ @194 SDUNI $5. /*School District (Unified)*/ @199 AREALAND 14. /*Area (Land)*/ @213 AREAWATR 14. /*Area (Water)*/ @227 NAME $90. /*Area Name-Legal/Statistical Area Description (LSAD) Term-Part Indicator*/ @317 FUNCSTAT $1. /*Functional Status Code*/ @318 GCUNI $1. /*Geographic Change User Note Indicator*/ @319 POP100 9. /*Population Count (100%)*/ @328 HU100 9. /*Housing Unit Count (100%)*/ @337 INTPTLAT 11. /*Internal Point (Latitude)*/ @348 INTPTLON 12. /*Internal Point (Longitude)*/ @360 LSADC $2. /*Legal/Statistical Area Description Code*/ @362 PARTFLAG $1. /*Part Flag*/ @363 RESERVE3 $6. /*Reserved*/ @369 UGA $5. /*Urban Growth Area*/ @374 STATENS $8. /*State (ANSI)*/ @382 COUNTYNS $8. /*County (ANSI)*/ @390 COUSUBNS $8. /*County Subdivision (ANSI)*/ @398 PLACENS $8. /*Place (ANSI)*/ @406 CONCITNS $8. /*Consolidated City (ANSI)*/ @414 AIANHHNS $8. /*American Indian Area/Alaska Native Area/Hawaiian Home Land (ANSI)*/ @422 AITSNS $8. /*American Indian Tribal Subdivision (ANSI)*/ @430 ANRCNS $8. /*Alaska Native Regional Corporation (ANSI)*/ @438 SUBMCDNS $8. /*Subminor Civil Division (ANSI)*/ @446 CD113 $2. /*Congressional District (113th)*/ @448 CD114 $2. /*Congressional District (114th)*/ @450 CD115 $2. /*Congressional District (115th)*/ @452 SLDU2 $3. /*State Legislative District (Upper Chamber) (Year 2)*/ @455 SLDU3 $3. /*State Legislative District (Upper Chamber) (Year 3)*/ @458 SLDU4 $3. /*State Legislative District (Upper Chamber) (Year 4)*/ @461 SLDL2 $3. /*State Legislative District (Lower Chamber) (Year 2)*/ @464 SLDL3 $3. /*State Legislative District (Lower Chamber) (Year 3)*/ @467 SLDL4 $3. /*State Legislative District (Lower Chamber) (Year 4)*/ @470 AIANHHSC $2. /*American Indian Area/Alaska Native Area/Hawaiian Home Land Size Code*/ @472 CSASC $2. /*Combined Statistical Area Size Code*/ @474 CNECTASC $2. /*Combined NECTA Size Code*/ @476 MEMI $1. /*Metropolitan Micropolitan Indicator*/ @477 NMEMI $1. /*NECTA Metropolitan Micropolitan Indicator*/ @478 PUMA $5. /*Public Use Microdata Area*/ @483 RESERVED $18. /*Reserved*/; format AREALAND 14. AREAWATR 14.; run; data work.part1; infile 'N:\CommDev\Research\Research\Census Data\Census 2010\TX000012010.pl' lrecl = 20000 dlm=',' dsd missover pad; /* Confirm physical location of your PL file downloads */ LENGTH FILEID $6 /*File Identification*/ STUSAB $2 /*State/US-Abbreviation (USPS)*/ CHARITER $3 /*Characteristic Iteration*/ CIFSN $2 /*Characteristic Iteration File Sequence Number*/ LOGRECNO $7 /*Logical Record Number*/ P0010001 8 /*P1-1: Total*/ P0010002 8 /*P1-2: Population of one race*/ P0010003 8 /*P1-3: White alone*/ P0010004 8 /*P1-4: Black or African American alone*/ P0010005 8 /*P1-5: American Indian and Alaska Native alone*/ P0010006 8 /*P1-6: Asian alone*/ P0010007 8 /*P1-7: Native Hawaiian and Other Pacific Islander alone*/ P0010008 8 /*P1-8: Some other race alone*/ P0010009 8 /*P1-9: Population of two or more races*/ P0010010 8 /*P1-10: Population of two races*/ P0010011 8 /*P1-11: White; Black or African American*/ P0010012 8 /*P1-12: White; American Indian and Alaska Native*/ P0010013 8 /*P1-13: White; Asian*/ P0010014 8 /*P1-14: White; Native Hawaiian and Other Pacific Islander*/ P0010015 8 /*P1-15: White; Some other race*/ P0010016 8 /*P1-16: Black or African American; American Indian and Alaska Native*/ P0010017 8 /*P1-17: Black or African American; Asian*/ P0010018 8 /*P1-18: Black or African American; Native Hawaiian and Other Pacific Islander*/ P0010019 8 /*P1-19: Black or African American; Some other race*/ P0010020 8 /*P1-20: American Indian and Alaska Native; Asian*/ P0010021 8 /*P1-21: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0010022 8 /*P1-22: American Indian and Alaska Native; Some other race*/ P0010023 8 /*P1-23: Asian; Native Hawaiian and Other Pacific Islander*/ P0010024 8 /*P1-24: Asian; Some other race*/ P0010025 8 /*P1-25: Native Hawaiian and Other Pacific Islander; Some other race*/ P0010026 8 /*P1-26: Population of three races*/ P0010027 8 /*P1-27: White; Black or African American; American Indian and Alaska Native*/ P0010028 8 /*P1-28: White; Black or African American; Asian*/ P0010029 8 /*P1-29: White; Black or African American; Native Hawaiian and Other Pacific Islander*/ P0010030 8 /*P1-30: White; Black or African American; Some other race*/ P0010031 8 /*P1-31: White; American Indian and Alaska Native; Asian*/ P0010032 8 /*P1-32: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0010033 8 /*P1-33: White; American Indian and Alaska Native; Some other race*/ P0010034 8 /*P1-34: White; Asian; Native Hawaiian and Other Pacific Islander*/ P0010035 8 /*P1-35: White; Asian; Some other race*/ P0010036 8 /*P1-36: White; Native Hawaiian and Other Pacific Islander; Some other race*/ P0010037 8 /*P1-37: Black or African American; American Indian and Alaska Native; Asian*/ P0010038 8 /*P1-38: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0010039 8 /*P1-39: Black or African American; American Indian and Alaska Native; Some other race*/ P0010040 8 /*P1-40: Black or African American; Asian; Native Hawaiian and Other Pacific Islander*/ P0010041 8 /*P1-41: Black or African American; Asian; Some other race*/ P0010042 8 /*P1-42: Black or African American; Native Hawaiian and Other Pacific Islander; Some other race*/ P0010043 8 /*P1-43: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0010044 8 /*P1-44: American Indian and Alaska Native; Asian; Some other race*/ P0010045 8 /*P1-45: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0010046 8 /*P1-46: Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0010047 8 /*P1-47: Population of four races*/ P0010048 8 /*P1-48: White; Black or African American; American Indian and Alaska Native; Asian*/ P0010049 8 /*P1-49: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0010050 8 /*P1-50: White; Black or African American; American Indian and Alaska Native; Some other race*/ P0010051 8 /*P1-51: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander*/ P0010052 8 /*P1-52: White; Black or African American; Asian; Some other race*/ P0010053 8 /*P1-53: White; Black or African American; Native Hawaiian and Other Pacific Islander; Some other race*/ P0010054 8 /*P1-54: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0010055 8 /*P1-55: White; American Indian and Alaska Native; Asian; Some other race*/ P0010056 8 /*P1-56: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0010057 8 /*P1-57: White; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0010058 8 /*P1-58: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0010059 8 /*P1-59: Black or African American; American Indian and Alaska Native; Asian; Some other race*/ P0010060 8 /*P1-60: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0010061 8 /*P1-61: Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0010062 8 /*P1-62: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0010063 8 /*P1-63: Population of five races*/ P0010064 8 /*P1-64: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0010065 8 /*P1-65: White; Black or African American; American Indian and Alaska Native; Asian; Some other race*/ P0010066 8 /*P1-66: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0010067 8 /*P1-67: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0010068 8 /*P1-68: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0010069 8 /*P1-69: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0010070 8 /*P1-70: Population of six races*/ P0010071 8 /*P1-71: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0020001 8 /*P2-1: Total*/ P0020002 8 /*P2-2: Hispanic or Latino*/ P0020003 8 /*P2-3: Not Hispanic or Latino*/ P0020004 8 /*P2-4: Population of one race*/ P0020005 8 /*P2-5: White alone*/ P0020006 8 /*P2-6: Black or African American alone*/ P0020007 8 /*P2-7: American Indian and Alaska Native alone*/ P0020008 8 /*P2-8: Asian alone*/ P0020009 8 /*P2-9: Native Hawaiian and Other Pacific Islander alone*/ P0020010 8 /*P2-10: Some other race alone*/ P0020011 8 /*P2-11: Population of two or more races*/ P0020012 8 /*P2-12: Population of two races*/ P0020013 8 /*P2-13: White; Black or African American*/ P0020014 8 /*P2-14: White; American Indian and Alaska Native*/ P0020015 8 /*P2-15: White; Asian*/ P0020016 8 /*P2-16: White; Native Hawaiian and Other Pacific Islander*/ P0020017 8 /*P2-17: White; Some other race*/ P0020018 8 /*P2-18: Black or African American; American Indian and Alaska Native*/ P0020019 8 /*P2-19: Black or African American; Asian*/ P0020020 8 /*P2-20: Black or African American; Native Hawaiian and Other Pacific Islander*/ P0020021 8 /*P2-21: Black or African American; Some other race*/ P0020022 8 /*P2-22: American Indian and Alaska Native; Asian*/ P0020023 8 /*P2-23: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0020024 8 /*P2-24: American Indian and Alaska Native; Some other race*/ P0020025 8 /*P2-25: Asian; Native Hawaiian and Other Pacific Islander*/ P0020026 8 /*P2-26: Asian; Some other race*/ P0020027 8 /*P2-27: Native Hawaiian and Other Pacific Islander; Some other race*/ P0020028 8 /*P2-28: Population of three races*/ P0020029 8 /*P2-29: White; Black or African American; American Indian and Alaska Native*/ P0020030 8 /*P2-30: White; Black or African American; Asian*/ P0020031 8 /*P2-31: White; Black or African American; Native Hawaiian and Other Pacific Islander*/ P0020032 8 /*P2-32: White; Black or African American; Some other race*/ P0020033 8 /*P2-33: White; American Indian and Alaska Native; Asian*/ P0020034 8 /*P2-34: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0020035 8 /*P2-35: White; American Indian and Alaska Native; Some other race*/ P0020036 8 /*P2-36: White; Asian; Native Hawaiian and Other Pacific Islander*/ P0020037 8 /*P2-37: White; Asian; Some other race*/ P0020038 8 /*P2-38: White; Native Hawaiian and Other Pacific Islander; Some other race*/ P0020039 8 /*P2-39: Black or African American; American Indian and Alaska Native; Asian*/ P0020040 8 /*P2-40: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0020041 8 /*P2-41: Black or African American; American Indian and Alaska Native; Some other race*/ P0020042 8 /*P2-42: Black or African American; Asian; Native Hawaiian and Other Pacific Islander*/ P0020043 8 /*P2-43: Black or African American; Asian; Some other race*/ P0020044 8 /*P2-44: Black or African American; Native Hawaiian and Other Pacific Islander; Some other race*/ P0020045 8 /*P2-45: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0020046 8 /*P2-46: American Indian and Alaska Native; Asian; Some other race*/ P0020047 8 /*P2-47: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0020048 8 /*P2-48: Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0020049 8 /*P2-49: Population of four races*/ P0020050 8 /*P2-50: White; Black or African American; American Indian and Alaska Native; Asian*/ P0020051 8 /*P2-51: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0020052 8 /*P2-52: White; Black or African American; American Indian and Alaska Native; Some other race*/ P0020053 8 /*P2-53: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander*/ P0020054 8 /*P2-54: White; Black or African American; Asian; Some other race*/ P0020055 8 /*P2-55: White; Black or African American; Native Hawaiian and Other Pacific Islander; Some other race*/ P0020056 8 /*P2-56: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0020057 8 /*P2-57: White; American Indian and Alaska Native; Asian; Some other race*/ P0020058 8 /*P2-58: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0020059 8 /*P2-59: White; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0020060 8 /*P2-60: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0020061 8 /*P2-61: Black or African American; American Indian and Alaska Native; Asian; Some other race*/ P0020062 8 /*P2-62: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0020063 8 /*P2-63: Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0020064 8 /*P2-64: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0020065 8 /*P2-65: Population of five races*/ P0020066 8 /*P2-66: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0020067 8 /*P2-67: White; Black or African American; American Indian and Alaska Native; Asian; Some other race*/ P0020068 8 /*P2-68: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0020069 8 /*P2-69: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0020070 8 /*P2-70: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0020071 8 /*P2-71: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0020072 8 /*P2-72: Population of six races*/ P0020073 8 /*P2-73: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/; INPUT FILEID $ STUSAB $ CHARITER $ CIFSN $ LOGRECNO $ P0010001 P0010002 P0010003 P0010004 P0010005 P0010006 P0010007 P0010008 P0010009 P0010010 P0010011 P0010012 P0010013 P0010014 P0010015 P0010016 P0010017 P0010018 P0010019 P0010020 P0010021 P0010022 P0010023 P0010024 P0010025 P0010026 P0010027 P0010028 P0010029 P0010030 P0010031 P0010032 P0010033 P0010034 P0010035 P0010036 P0010037 P0010038 P0010039 P0010040 P0010041 P0010042 P0010043 P0010044 P0010045 P0010046 P0010047 P0010048 P0010049 P0010050 P0010051 P0010052 P0010053 P0010054 P0010055 P0010056 P0010057 P0010058 P0010059 P0010060 P0010061 P0010062 P0010063 P0010064 P0010065 P0010066 P0010067 P0010068 P0010069 P0010070 P0010071 P0020001 P0020002 P0020003 P0020004 P0020005 P0020006 P0020007 P0020008 P0020009 P0020010 P0020011 P0020012 P0020013 P0020014 P0020015 P0020016 P0020017 P0020018 P0020019 P0020020 P0020021 P0020022 P0020023 P0020024 P0020025 P0020026 P0020027 P0020028 P0020029 P0020030 P0020031 P0020032 P0020033 P0020034 P0020035 P0020036 P0020037 P0020038 P0020039 P0020040 P0020041 P0020042 P0020043 P0020044 P0020045 P0020046 P0020047 P0020048 P0020049 P0020050 P0020051 P0020052 P0020053 P0020054 P0020055 P0020056 P0020057 P0020058 P0020059 P0020060 P0020061 P0020062 P0020063 P0020064 P0020065 P0020066 P0020067 P0020068 P0020069 P0020070 P0020071 P0020072 P0020073 ; run; data work.part2; infile 'N:\CommDev\Research\Research\Census Data\Census 2010\TX000022010.pl' lrecl=20000 dlm=',' dsd missover pad; /* Confirm physical location of your PL file downloads */ LENGTH FILEID $6 /*File Identification*/ STUSAB $2 /*State/US-Abbreviation (USPS)*/ CHARITER $3 /*Characteristic Iteration*/ CIFSN $2 /*Characteristic Iteration File Sequence Number*/ LOGRECNO $7 /*Logical Record Number*/ P0030001 8 /*P3-1: Total*/ P0030002 8 /*P3-2: Population of one race*/ P0030003 8 /*P3-3: White alone*/ P0030004 8 /*P3-4: Black or African American alone*/ P0030005 8 /*P3-5: American Indian and Alaska Native alone*/ P0030006 8 /*P3-6: Asian alone*/ P0030007 8 /*P3-7: Native Hawaiian and Other Pacific Islander alone*/ P0030008 8 /*P3-8: Some other race alone*/ P0030009 8 /*P3-9: Population of two or more races*/ P0030010 8 /*P3-10: Population of two races*/ P0030011 8 /*P3-11: White; Black or African American*/ P0030012 8 /*P3-12: White; American Indian and Alaska Native*/ P0030013 8 /*P3-13: White; Asian*/ P0030014 8 /*P3-14: White; Native Hawaiian and Other Pacific Islander*/ P0030015 8 /*P3-15: White; Some other race*/ P0030016 8 /*P3-16: Black or African American; American Indian and Alaska Native*/ P0030017 8 /*P3-17: Black or African American; Asian*/ P0030018 8 /*P3-18: Black or African American; Native Hawaiian and Other Pacific Islander*/ P0030019 8 /*P3-19: Black or African American; Some other race*/ P0030020 8 /*P3-20: American Indian and Alaska Native; Asian*/ P0030021 8 /*P3-21: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0030022 8 /*P3-22: American Indian and Alaska Native; Some other race*/ P0030023 8 /*P3-23: Asian; Native Hawaiian and Other Pacific Islander*/ P0030024 8 /*P3-24: Asian; Some other race*/ P0030025 8 /*P3-25: Native Hawaiian and Other Pacific Islander; Some other race*/ P0030026 8 /*P3-26: Population of three races*/ P0030027 8 /*P3-27: White; Black or African American; American Indian and Alaska Native*/ P0030028 8 /*P3-28: White; Black or African American; Asian*/ P0030029 8 /*P3-29: White; Black or African American; Native Hawaiian and Other Pacific Islander*/ P0030030 8 /*P3-30: White; Black or African American; Some other race*/ P0030031 8 /*P3-31: White; American Indian and Alaska Native; Asian*/ P0030032 8 /*P3-32: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0030033 8 /*P3-33: White; American Indian and Alaska Native; Some other race*/ P0030034 8 /*P3-34: White; Asian; Native Hawaiian and Other Pacific Islander*/ P0030035 8 /*P3-35: White; Asian; Some other race*/ P0030036 8 /*P3-36: White; Native Hawaiian and Other Pacific Islander; Some other race*/ P0030037 8 /*P3-37: Black or African American; American Indian and Alaska Native; Asian*/ P0030038 8 /*P3-38: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0030039 8 /*P3-39: Black or African American; American Indian and Alaska Native; Some other race*/ P0030040 8 /*P3-40: Black or African American; Asian; Native Hawaiian and Other Pacific Islander*/ P0030041 8 /*P3-41: Black or African American; Asian; Some other race*/ P0030042 8 /*P3-42: Black or African American; Native Hawaiian and Other Pacific Islander; Some other race*/ P0030043 8 /*P3-43: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0030044 8 /*P3-44: American Indian and Alaska Native; Asian; Some other race*/ P0030045 8 /*P3-45: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0030046 8 /*P3-46: Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0030047 8 /*P3-47: Population of four races*/ P0030048 8 /*P3-48: White; Black or African American; American Indian and Alaska Native; Asian*/ P0030049 8 /*P3-49: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0030050 8 /*P3-50: White; Black or African American; American Indian and Alaska Native; Some other race*/ P0030051 8 /*P3-51: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander*/ P0030052 8 /*P3-52: White; Black or African American; Asian; Some other race*/ P0030053 8 /*P3-53: White; Black or African American; Native Hawaiian and Other Pacific Islander; Some other race*/ P0030054 8 /*P3-54: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0030055 8 /*P3-55: White; American Indian and Alaska Native; Asian; Some other race*/ P0030056 8 /*P3-56: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0030057 8 /*P3-57: White; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0030058 8 /*P3-58: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0030059 8 /*P3-59: Black or African American; American Indian and Alaska Native; Asian; Some other race*/ P0030060 8 /*P3-60: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0030061 8 /*P3-61: Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0030062 8 /*P3-62: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0030063 8 /*P3-63: Population of five races*/ P0030064 8 /*P3-64: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0030065 8 /*P3-65: White; Black or African American; American Indian and Alaska Native; Asian; Some other race*/ P0030066 8 /*P3-66: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0030067 8 /*P3-67: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0030068 8 /*P3-68: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0030069 8 /*P3-69: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0030070 8 /*P3-70: Population of six races*/ P0030071 8 /*P3-71: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0040001 8 /*P4-1: Total*/ P0040002 8 /*P4-2: Hispanic or Latino*/ P0040003 8 /*P4-3: Not Hispanic or Latino*/ P0040004 8 /*P4-4: Population of one race*/ P0040005 8 /*P4-5: White alone*/ P0040006 8 /*P4-6: Black or African American alone*/ P0040007 8 /*P4-7: American Indian and Alaska Native alone*/ P0040008 8 /*P4-8: Asian alone*/ P0040009 8 /*P4-9: Native Hawaiian and Other Pacific Islander alone*/ P0040010 8 /*P4-10: Some other race alone*/ P0040011 8 /*P4-11: Population of two or more races*/ P0040012 8 /*P4-12: Population of two races*/ P0040013 8 /*P4-13: White; Black or African American*/ P0040014 8 /*P4-14: White; American Indian and Alaska Native*/ P0040015 8 /*P4-15: White; Asian*/ P0040016 8 /*P4-16: White; Native Hawaiian and Other Pacific Islander*/ P0040017 8 /*P4-17: White; Some other race*/ P0040018 8 /*P4-18: Black or African American; American Indian and Alaska Native*/ P0040019 8 /*P4-19: Black or African American; Asian*/ P0040020 8 /*P4-20: Black or African American; Native Hawaiian and Other Pacific Islander*/ P0040021 8 /*P4-21: Black or African American; Some other race*/ P0040022 8 /*P4-22: American Indian and Alaska Native; Asian*/ P0040023 8 /*P4-23: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0040024 8 /*P4-24: American Indian and Alaska Native; Some other race*/ P0040025 8 /*P4-25: Asian; Native Hawaiian and Other Pacific Islander*/ P0040026 8 /*P4-26: Asian; Some other race*/ P0040027 8 /*P4-27: Native Hawaiian and Other Pacific Islander; Some other race*/ P0040028 8 /*P4-28: Population of three races*/ P0040029 8 /*P4-29: White; Black or African American; American Indian and Alaska Native*/ P0040030 8 /*P4-30: White; Black or African American; Asian*/ P0040031 8 /*P4-31: White; Black or African American; Native Hawaiian and Other Pacific Islander*/ P0040032 8 /*P4-32: White; Black or African American; Some other race*/ P0040033 8 /*P4-33: White; American Indian and Alaska Native; Asian*/ P0040034 8 /*P4-34: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0040035 8 /*P4-35: White; American Indian and Alaska Native; Some other race*/ P0040036 8 /*P4-36: White; Asian; Native Hawaiian and Other Pacific Islander*/ P0040037 8 /*P4-37: White; Asian; Some other race*/ P0040038 8 /*P4-38: White; Native Hawaiian and Other Pacific Islander; Some other race*/ P0040039 8 /*P4-39: Black or African American; American Indian and Alaska Native; Asian*/ P0040040 8 /*P4-40: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0040041 8 /*P4-41: Black or African American; American Indian and Alaska Native; Some other race*/ P0040042 8 /*P4-42: Black or African American; Asian; Native Hawaiian and Other Pacific Islander*/ P0040043 8 /*P4-43: Black or African American; Asian; Some other race*/ P0040044 8 /*P4-44: Black or African American; Native Hawaiian and Other Pacific Islander; Some other race*/ P0040045 8 /*P4-45: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0040046 8 /*P4-46: American Indian and Alaska Native; Asian; Some other race*/ P0040047 8 /*P4-47: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0040048 8 /*P4-48: Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0040049 8 /*P4-49: Population of four races*/ P0040050 8 /*P4-50: White; Black or African American; American Indian and Alaska Native; Asian*/ P0040051 8 /*P4-51: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander*/ P0040052 8 /*P4-52: White; Black or African American; American Indian and Alaska Native; Some other race*/ P0040053 8 /*P4-53: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander*/ P0040054 8 /*P4-54: White; Black or African American; Asian; Some other race*/ P0040055 8 /*P4-55: White; Black or African American; Native Hawaiian and Other Pacific Islander; Some other race*/ P0040056 8 /*P4-56: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0040057 8 /*P4-57: White; American Indian and Alaska Native; Asian; Some other race*/ P0040058 8 /*P4-58: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0040059 8 /*P4-59: White; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0040060 8 /*P4-60: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0040061 8 /*P4-61: Black or African American; American Indian and Alaska Native; Asian; Some other race*/ P0040062 8 /*P4-62: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0040063 8 /*P4-63: Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0040064 8 /*P4-64: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0040065 8 /*P4-65: Population of five races*/ P0040066 8 /*P4-66: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander*/ P0040067 8 /*P4-67: White; Black or African American; American Indian and Alaska Native; Asian; Some other race*/ P0040068 8 /*P4-68: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race*/ P0040069 8 /*P4-69: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0040070 8 /*P4-70: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0040071 8 /*P4-71: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ P0040072 8 /*P4-72: Population of six races*/ P0040073 8 /*P4-73: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race*/ H0010001 8 /*H1-1: Total*/ H0010002 8 /*H1-2: Occupied*/ H0010003 8 /*H1-3: Vacant*/ ; INPUT FILEID $ STUSAB $ CHARITER $ CIFSN $ LOGRECNO $ P0030001 P0030002 P0030003 P0030004 P0030005 P0030006 P0030007 P0030008 P0030009 P0030010 P0030011 P0030012 P0030013 P0030014 P0030015 P0030016 P0030017 P0030018 P0030019 P0030020 P0030021 P0030022 P0030023 P0030024 P0030025 P0030026 P0030027 P0030028 P0030029 P0030030 P0030031 P0030032 P0030033 P0030034 P0030035 P0030036 P0030037 P0030038 P0030039 P0030040 P0030041 P0030042 P0030043 P0030044 P0030045 P0030046 P0030047 P0030048 P0030049 P0030050 P0030051 P0030052 P0030053 P0030054 P0030055 P0030056 P0030057 P0030058 P0030059 P0030060 P0030061 P0030062 P0030063 P0030064 P0030065 P0030066 P0030067 P0030068 P0030069 P0030070 P0030071 P0040001 P0040002 P0040003 P0040004 P0040005 P0040006 P0040007 P0040008 P0040009 P0040010 P0040011 P0040012 P0040013 P0040014 P0040015 P0040016 P0040017 P0040018 P0040019 P0040020 P0040021 P0040022 P0040023 P0040024 P0040025 P0040026 P0040027 P0040028 P0040029 P0040030 P0040031 P0040032 P0040033 P0040034 P0040035 P0040036 P0040037 P0040038 P0040039 P0040040 P0040041 P0040042 P0040043 P0040044 P0040045 P0040046 P0040047 P0040048 P0040049 P0040050 P0040051 P0040052 P0040053 P0040054 P0040055 P0040056 P0040057 P0040058 P0040059 P0040060 P0040061 P0040062 P0040063 P0040064 P0040065 P0040066 P0040067 P0040068 P0040069 P0040070 P0040071 P0040072 P0040073 H0010001 H0010002 H0010003 ; run; proc sort data=work.header; by logrecno; run; proc sort data=work.part1; by logrecno; run; proc sort data=work.part2; by logrecno; run; data cen2010.PL2010; merge work.header (in=in1) work.part1 (in=in2) work.part2 (in=in3); by logrecno; if not (in1 and in2 and in3) then do; if not in1 then put 'Logrecno is not in header at line ' _n_; if not in2 then put 'Logrecno is not in part1 at line ' _n_; if not in3 then put 'Logrecno is not in part2 at line ' _n_; end; /* New fields converting Area Sq Meters into Acres */ ACRELAND=round(AREALAND/4047,0.01); ACREWATR=round(AREAWATR/4047,0.01); run;