Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Creation of Public Housing from Existing Housing Units/Longitudinal Matching of Housing Units
#1
I am hoping someone can help me understand an unexpected result I am getting using the 2011 and 2013 national American Housing Survey (AHS) datasets. I was trying to figure out the share of public housing in 2013 that was converted to public housing from being private housing in 2011. I don't think this is common these days, so I was expecting it to be very small or even unobserved.

So I first created a dataset that had only the 2013 AHS public housing units and joined it with the 2011 AHS data so that I had a new data set comprised of housing units that were both public housing units in 2013 and included in the 2011 data. I used the "CONTROL" variable to join the 2011 and 2013 data and used the "HUDADMIN" variable to identify public housing. 20% of the 2013 public housing units were not identified as public housing units in 2011 (ignoring weights).

This seems way too high based on what I have read about trends in public housing. The "HUDADMIN" variable is created using HUD administrative records, so I don't think the problem can be respondent reporting errors. Any explanations for why I am getting this result would be appreciated.

The SAS code I used is below. Thanks!

-Matt


*Author: Matthew LaPenta;
*Creation Date: 07SEP17
*Description: Estimate the percentage of public housing units in the 2013 data that were not public housing units
in the 2011 data (excluding newly constructed units);
*Inputs:
ahs2013n (2013 national AHS flat file)
ahs2011n (2011 national AHS flat file);

*define input libary;
libname inputs "../inputs";

*Get 2013 data and keep only relevant variables;
data d01_2013 (keep=control Proj2013 weight2013);
set inputs.ahs2013n;
*rename weight so that it is survey year-specific;
rename weight=weight2013;

*HUDADMIN Response Codes:
1: Yes, public housing
2: Yes, someone in unit received a voucher
3: Yes, privately owned subsidized housing
4: Unit did not receive any type of government rental assistance
B or -6: Not applicable;
*Define 2013 binary variable for public housing;
if hudadmin=1 then Proj2013="Yes"; else Proj2013="No";
run;

*Get 2011 data and keep only relevant variables;
data d01_2011 (keep=control Proj2011 weight2011);
set inputs.ahs2011n;
*rename weight so that it is survey year-specific;
rename weight=weight2011;
*Note: HUDADMIN Response Codes:
1: Yes, public housing
2: Yes, someone in unit received a voucher
3: Yes, privately owned subsidized housing
4: Unit did not receive any type of government rental assistance
B or -6: Not applicable;
*Define 2011 binary variable for public housing;
if hudadmin=1 then Proj2011="Yes"; else Proj2011="No";
run;

*Perform inner join on 2011 and 2013 data, dropping housing units that are not in both samples;
proc sql;
create table d02 as select
d11.control,
proj2013,
proj2011,
weight2013
from d01_2013 d13 inner join d01_2011 d11 on d11.control=d13.control;
quit;

*Get counts and populations of units according to public housing status;
proc sql;
create table d03 as select
proj2011,
proj2013,
count(control) as count format=comma20.0,
sum(weight2013) as housingunits format=comma20.0
from d02 group by Proj2011, proj2013;
quit;

*Calculate percentages for counts and populations of units according to public housing status;
proc sql;
create table d04 as select
proj2011,
proj2013,
count/sum(count) as countpercent format=percent10.0 label="Unweighted Percentage of Housing Units",
housingunits/sum(housingunits) as HUspercent format=percent10.0 label="Weighted Percentage of Housing Units"
from d03 where proj2013="Yes";
quit;
Reply


Messages In This Thread
Creation of Public Housing from Existing Housing Units/Longitudinal Matching of Housing Units - by matthew_lapenta@abtassoc.com - 09-08-2017, 06:49 PM
Improved HUDADMIN match - by Dav Vandenbroucke - 09-15-2017, 01:04 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)