Re: AHS: S-04C Recodes

Re: AHS: S-04C Recodes

Mr. White:

1. The variables ending in digits are from the survey instrument. They were collapsed into the "WB..." variables for the public use file. You can see how they fit into the instrument by downloading the 2013 AHS Items Booklet from http://www.census.gov/programs-surveys/ahs/tech-documentation/def-errors-changes.html.

2. The public transit supplement was administered to only half of the AHS sample. You need to weight your tabulations with SPLITWGT1 instead of WGTGEOMETRO.

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: Monday, August 22, 2016 12:33 PM
To: Vandenbroucke, David A
Subject: AHS: S-04C Recodes

Using the AHS_2103_Table_Specifications excel file, they give the following recodes for Public Transportation:

|/* RECODES for Public Transportation Module */
|
|WBBIKEWALK = 'B';
|WBGROCER = 'B';
|WBSERVIC = 'B';
|WBRETAIL = 'B';
|WBENTMNT = 'B';
|WBHEALTH = 'B';
|WBBANK = 'B';
|WBWKSCHL = 'B';
|WBSIDEWALK = 'B';
|
|if status = '1' then do;
|
|if bikewalk1 = '1' then WBBIKEWALK = bikewalk2;
|else if bikewalk1 = '2' then WBBIKEWALK = '4';
|else WBBIKEWALK = bikewalk1;
|
|if wbgrocer1 = '1' then WBGROCER = wbgrocer2;
|else if wbgrocer1 = '2' then WBGROCER = '4';
|else WBGROCER = wbgrocer1;
|
|if wbservic1 = '1' then WBSERVIC = wbservic2;
|else if wbservice1 = '2' then WBSERVIC = '4';
|else WBSERVIC = wbservic1;
|
|if wbretail1 = '1' then WBRETAIL = wbretail2;
|else if wbretail1 = '2' then WBRETAIL = '4';
|else WBRETAIL=wbretail1;
|
|if wbentmnt1 = '1' then WBENTMNT = wbentmnt2;
|else if wbentmnt1 = '2' then WBENTMNT = '4';
|else WBENTMNT = wbentmnt1;
|
|if wbhealth1 = '1' then WBHEALTH = wbhealth2;
|else if wbhealth1 = '2' then WBHEALTH = '4';
|else WBHEALTH = wbhealth1;
|
|if wbbank1 = '1' then WBBANK = wbbank2;
|else if wbbank1 = '2' then WBBANK = '4';
|else WBBANK = wbbank1;
|
|if wbwkschl1 = '1' then WBWKSCHL = wbwkschl2;
|else if wbwkschl1 = '2' then WBWKSCHL = '4';
|else WBWKSCHL = wbwkschl1;
|
|if sidewlk = '1' then WBSIDEWALK = sidewlklt;
|else WBSIDEWALK = sidewlk;
|
|end; /* of status check */
|

However, it appears that none of the variables with a number after then actually exists, bikewalk1, wbgrocer1, etc. Can anyone explain how to use this recode, or is this a difference between the public and private AHS data.

Also, in trying to reproduce the number of households that use public transportation for Jacksonville, FL I believe you should use the following code:

if STATUS eq 1 and PTPUBTRN = '1 then public=”Yes”;

but if you then weight this by wgtmetro, you get 21.7 thousand households that use public transportation while the American FactFinder table reports 44.2 thousand. Again any help in explain what I am doing wrong is appreciated.

Thanks,
Douglas White