*-------------------------------------------------------------------------* | SAS DATA DEFINITION STATEMENTS FOR ICPSR 9972 | | | | ARSON MEASUREMENT, ANALYSIS AND PREVENTION IN MASSACHUSETTS | | 1983-1985 | | | | | *-------------------------------------------------------------------------; * SAS DATA, INFILE, INPUT STATEMENTS; DATA bostfire; INFILE "da9972.bostfire" LRECL=61; INPUT FNAME $ 1-3 TRACT 13-19 .2 FDID $ 20-24 BTN 43-45 BAN 46-47 RTN 48-49 RAN 50-51 SAN 52-52 TAN 53-53 AAN 54-55 CTN 56-58 CAN 59-61; * SAS LABEL STATEMENT; LABEL FNAME = "Boston data file" TRACT = "Census tract" FDID = "Fire Department ID" BTN = "Structural-building fires" BAN = "Structural arson fires" RTN = "Residential-building fires" RAN = "Residential arson fires" SAN = "Single units arson fires" TAN = "One and two unit arson fires" AAN = "Apartment arson fires" CTN = "Car fires (CF)" CAN = "Car arson fires (CA)"; run; proc means data=bostfire; run; *-------------------------------------------------------------* } SAS DATA DEFINITION STATEMENTS FOR ICPSR 9972 | | | | ARSON MEASUREMENT, ANALYSIS AND PREVENTION IN MASSACHUSETTS | | 1983-1985 | | | | PART 3: BOSTON CENSUS TRACT DATA | *--------------------------------------------------------------; DATA macensus; INFILE "da9972.macensus" LRECL=623; INPUT FNAME $ 1-3 IDN 4-10 .2 TRACT 13-19 .2 NPERSONS 25-29 PCTFAM1P 106-111 .2 PCTWF1P 112-117 .2 PCTBF1P 118-123 .2 LFP 124-128 .2 LFPM 129-134 .2 LFPF 135-139 .2 LFPW 140-144 .2 LFPB 145-150 .2 LFPWM 151-156 .2 LFPWF 157-162 .2 LFPBM 163-168 .2 LFPBF 169-174 .2 PUN1T4WK 175-179 .2 PUN5T14W 180-185 .2 PUN15WKS 186-191 .2 UR 192-196 .2 URM 197-201 .2 URF 202-206 .2 URW 207-211 .2 URWM 212-216 .2 URWF 217-222 .2 URB 223-228 .2 URBM 229-234 .2 URBF 235-240 .2 NUMTHU 241-244 NUMHHLDS 245-248 NUMYRUN 249-252 NUMOCC 253-256 NUMVAC 257-260 PCTVAC 261-265 .2 BLDGL4FL 266-269 BLDG4FLR 270-273 PCTG4FLR 274-279 .2 PCNTNKIT 280-285 .2 PCNTNBAT 286-290 .2 PCNTNPLG 291-295 .2 PTLPOVL 296-300 .2 PTWLPOVL 301-305 .2 PTBLPOVL 306-311 .2 TOTPPROM 312-316 .2 NUMTBLDG 317-323 .2 NUM1BLDG 324-327 NUM2BLDG 328-333 .1 NUMOBLDG 334-340 .2 NUMVBLDG 341-346 .2 PCTVBLDG 347-351 .2 NUMRBLDG 352-357 .2 TOCCHU 358-361 TOCCRU 362-365 PCTBLT79 366-370 .2 PCTBLT75 371-375 .2 PCTBLT70 376-380 .2 PCTBLT60 381-385 .2 PCTBLT50 386-390 .2 PCTBLT40 391-395 .2 PCTBLT39 396-400 .2 AVEBLT 401-405 .2 PCTOCC79 406-410 .2 PCTOCC75 411-415 .2 PCTOCC70 416-420 .2 PCTOCC60 421-425 .2 PCTOCC50 426-430 .2 PCTOCC49 431-435 .2 AVEOCC 436-440 .2 PTEN75 441-445 .2 PCTGAS 446-450 .2 PCTELEC 451-455 .2 PCTOIL 456-461 .2 NUMWCAR 462-465 PCNTWCAR 466-471 .2 NUMCARS 472-478 .2 CARSPERP 479-483 .2 VACSALE 484-485 VACRENT 486-488 NUMRENTU 489-492 PCTRENTU 493-498 .2 PCTRNTV 499-503 .2 PCTSALE 504-508 .2 MDNINC 509-513 AVEINC 514-521 .2 NWH 522-525 NBL 526-529 PCTWH 530-535 .2 PCTBL 536-540 .2 PCTSP 541-545 .2 PGT1PPRM 546-550 .2 MDNWMORT 551-553 MDNNMORT 554-556 MEANRENT 557-562 .2 PCT0709 563-566 .2 PCT1013 567-571 .2 PCT1415 572-576 .2 PCT1617 577-581 .2 PCT1819 582-586 .2 PCT0709M 587-590 .2 PCT1013M 591-594 .2 PCT1415M 595-598 .2 PCT1617M 599-603 .2 PCT1819M 604-608 .2 PCT1019M 609-613 .2 DENSITY1 614-619 .2 DENSITY2 620-623 .2; * SAS LABEL STATEMENT; LABEL FNAME = "Census tract file" IDN = "ID" TRACT = "Census tract" NPERSONS = "Number of persons" PCTFAM1P = "Pct families with 1 parent" PCTWF1P = "Pct white families with 1 parent" PCTBF1P = "Pct black families with 1 parent" LFP = "Labor force participation rate" LFPM = "Male labor force participation" LFPF = "Female labor force participation" LFPW = "White labor force participation" LFPB = "Black labor force participation" LFPWM = "White male labor force participation" LFPWF = "White female labor force participation" LFPBM = "Black male labor force participation" LFPBF = "Black female labor participation" PUN1T4WK = "Pct unemployed 1-4 weeks" PUN5T14W = "Pct unemployed 5-14 weels" PUN15WKS = "Pct unemployed 15+ weeks" UR = "Unemployment rate" URM = "Male unemployment rate" URF = "Female unemployment rate" URW = "White unemployment rate" URWM = "White male unemployment rate" URWF = "White female unemployment rate" URB = "Black unemployment rate" URBM = "Black male unemployment rate" URBF = "Black female unemployment rate" NUMTHU = "Total number housing units" NUMHHLDS = "Number households" NUMYRUN = "Number yr-rnd housing units" NUMOCC = "Occupied housing" NUMVAC = "Vacant housing units" PCTVAC = "Pct vacant housing units" BLDGL4FL = "Buildings under 4 floors" BLDG4FLR = "Buildings 4+ floors" PCTG4FLR = "Pct buildings 4+ floors" PCNTNKIT = "Pct housing units without complete kitchen" PCNTNBAT = "Pct rental units without complete bath" PCNTNPLG = "Pct housing units without complete plumbing" PTLPOVL = "Pct persons below poverty" PTWLPOVL = "Pct whites below poverty" PTBLPOVL = "Pct blacks below poverty" TOTPPROM = "2 Persons per 100 rooms" NUMTBLDG = "Total number of residential buildings" NUM1BLDG = "Number of single unit buildings" NUM2BLDG = "Number of one and two unit buildings" NUMOBLDG = "Occupied residential buildings" NUMVBLDG = "Vacant residential buildings" PCTVBLDG = "Pct vacant buildings" NUMRBLDG = "Number rental buildings" TOCCHU = "Occupied housing units" TOCCRU = "Occupied rental units" PCTBLT79 = "Pct yr housing units since 1979" PCTBLT75 = "Pct yr housing units 1975-1978" PCTBLT70 = "Pct yr housing units 1970-1974" PCTBLT60 = "Pct yr housing units 1960-1969" PCTBLT50 = "Pct yr housing units 1950-1959" PCTBLT40 = "Pct yr housing units 1940-1949" PCTBLT39 = "Pct yr housing units pre-1940" AVEBLT = "Average age yr housing units" PCTOCC79 = "Pct units occupied since 1979" PCTOCC75 = "Pct units occupied 1975-1978" PCTOCC70 = "Pct units occupied 1970-1974" PCTOCC60 = "Pct units occupied 1960-1969" PCTOCC50 = "Pct units occupied 1950-1959" PCTOCC49 = "Pct units occupied 1940-1949" AVEOCC = "Average occupancy tenure" PTEN75 = "Pct occ tenure since 1975" PCTGAS = "Pct occupied units with gas" PCTELEC = "Pct occupied units with electricity" PCTOIL = "Pct occupied units with oil" NUMWCAR = "Number occupied with car" PCNTWCAR = "Pct occupied units with car" NUMCARS = "Number of cars" CARSPERP = "Cars per 100 population" VACSALE = "Vacant housing units for sale" VACRENT = "Vacant housing units for rent" NUMRENTU = "Number occupied tental units" PCTRENTU = "Pct occupied units rented" PCTRNTV = "Pct rental units vacant" PCTSALE = "Pct owned units for sale" MDNINC = "Median income" AVEINC = "Mean income" NWH = "Number whites" NBL = "Number blacks" PCTWH = "Pct white" PCTBL = "Pct black" PCTSP = "Pct spanish origin" PGT1PPRM = "Pct units with > 1 person per room" MDNWMORT = "Median owner monthly cost with mortgage" MDNNMORT = "Median owner monthly cost no mortgage" MEANRENT = "Mean monthly rent" PCT0709 = "Pct aged 7-9" PCT1013 = "Pct aged 10-13" PCT1415 = "Pct aged 14-15" PCT1617 = "Pct aged 16-17" PCT1819 = "Pct aged 18-19" PCT0709M = "Pct aged 7-9 and male" PCT1013M = "Pct aged 10-13 and male" PCT1415M = "Pct aged 14-15 and male" PCT1617M = "Pct aged 16-17 and male" PCT1819M = "Pct aged 18-19 and male" PCT1019M = "Pct aged 10-19 male" DENSITY1 = "Persons per building" DENSITY2 = "Units per building"; run; proc means data=macensus; title "Massachusetts Census Data"; run; /*One-to-One merge, but only for cases that are in the bostfire data set*/ proc sort data=bostfire; by tract; run; proc sort data=macensus; by tract; run; data bostfire_census; merge bostfire(in=a) macensus(in=b); by tract; if a; array v(*) _numeric_; do i = 1 to dim(v); if v(i) = -9 then v(i) = .; end; drop i; run; proc contents data=bostfire_census varnum; run; proc means data=bostfire_census; run;