AHS: RE: Table C-14 Mortgage Characteristics

AHS: RE: Table C-14 Mortgage Characteristics

Reply to Douglas White’s post of August 30 (I’ve been on vacation).

UNPBAL, PMT, AND VALUE are all topcoded, which may be part of your problem. I note that the topcodes spreadsheet is not on the Census web site. I’ll try to get that fixed. I can email it to anyone who wants it.

In the PUF, DATE holds the date of interview in MMDDYYYY format. You can parse that to construct DATEY. However, I’d be surprised if they weren’t all 2013.

Dav Vandenbroucke
Senior Economist
U.S. Department of Housing & Urban Development
451 7th Street SW, Room 8222
Washington, DC 20410

Email david.a.vandenbroucke@hud.gov
Phone 202-402-5890

---

From: AHS [mailto:ahs@huduser.gov]
Sent: Tue, Aug 30, 2016 at 12:16 PM EDT
Subject: AHS: Table C-14 Mortgage Characteristics

I’m trying to reproduce table C-14. I see that we need to do certain recodes for the public data. In the following recode for years remaining, what vale should be used for DATEY?

/* RECODE for RYMORT - Remaining Years Mortgaged */ 

if STATUS eq "1" then do;
   if 1 <= MCNT <=7 and CANVAR ne "1" and CANVR2 ne "1" then do;
      if MCNT eq 1 then do;
         if MATBUY eq '1' then RYMORT = TERM - (DATEY - WHNGET);
         if MATBUY eq '2' then RYMORT = TERM - (DATEY - YRMOR);
      end;
      if 2 <= MCNT <=7 then do;
         if MATBUY eq '1' then RYMORT1 = TERM - (DATEY - WHNGET);
         if MATBUY eq '2' then RYMORT1 = TERM - (DATEY - YRMOR);
         if MATBY2 eq '1' then RYMORT2 = TERM2 - (DATEY - WHNGET);
         if MATBY2 eq '2' then RYMORT2 = TERM2 - (DATEY - YRMOR2);
         if RYMORT1 ge RYMORT2 then RYMORT = RYMORT1;
         if RYMORT1 lt RYMORT2 then RYMORT = RYMORT2;
         if RYMORT lt 0 then RYMORT = 0;
      end;
   end;
end; 

I have also used the following recodes, but when calculating monthly payment and current total as percent of value, my numbers are off. Does the top coding issue affect these numbers, or is there a weight besides wgtmetro that we should be using? 

/* RECODE for PMTT - MORT38 - Monthly Mortgage Payment */ 

   if MCNT ge 1 then do;
      PMTT = sum(PMT,PMT2,PMT3,PMT4,.);
      end;

/* RECODE for UNPBALT - Total Outstanding Principal */

   if MCNT ge 1 then do;
      UNPBALT = sum(UNPBAL,UNPBAL2,UNPBAL3,UNPBAL4,.);
   end;

/* RECODE for CLPEVA - Total Loan as Percent of Value */

   if 1 <= MCNT <=7 then do;
      CLPEVAR=.;
      if UNPBALT ne . then CLPEVAR = (UNPBALT/VALUE)*100;
        if VALUE lt 10000 then CLPEVAR = .;
   end;
   CLPEVA=round(CLPEVAR,1);

Thanks,

Douglas White