Skip to main content

Re: file flattening program for Stata

HUD.GOV HUDUser.gov
eList
AHS

The latest version of STATA - version 8 - has a new command that reads in the SAS transport files that the AHS also comes in and converts them into STATA files. The command is "fdause" then the path to the file, or you can do it by choosing File - Import - SAS XPT from the pull down menus. If you are a STATA user and not a SAS user, this is much easier than working with the seven ASCII files. The other advantage is it keeps all the variable names and descriptions that come with the SAS download. It doesn't however rectangularize the person-level data like the ASCII files do, but if you're primary interest is just with the units and householders (and not other persons in the household), then this method works great.

Rachel Drew
Research Assistant
Joint Center for Housing Studies
617.495.9296
rdrew@gsd.harvard.edu

At 03:31 PM 1/9/2004, you wrote:
From: American Housing Survey (AHS) ListServ <ahs@huduser.gov>

Richard Levy www.nmhc.org) asks:

>>Has anyone developed a Stata program that merges the seven or so AHS files
into one flat file? <<

I'd love to have a copy for the user-supplied programs library on our web site.

Dav Vandenbroucke
Economist
U.S. Dept. HUD
david_a._vandenbroucke@hud.gov
202-708-1060 ext. 5890

- - - - - - - - - - - - - - - - - - - - - - - - -
This message was forwarded to you by the Listserv ahs@huduser.gov because
you had expressed an interest.
To stop receiving these messages send an email to ahs@huduser.gov
with "unsubscribe" as the SUBJECT of your message.
To reply to all members of the list address your reply to ahs@huduser.gov.
Message archives are at https://www.huduser.gov/portal/elist/archive.html
For help send an email to helpdesk@huduser.gov