Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Re: Replacing Address Information in Panel Data Set


From   Matthew Krauchunas <[email protected]>
To   [email protected]
Subject   st: Re: Replacing Address Information in Panel Data Set
Date   Mon, 12 Jul 2010 22:16:43 -0400

> Hello,
>
> I have panel data with consists of a facility number unique to each address, facility name, city, state, and zip code.  I took that information, collapsed it, performed an outsheet, had all of the addresses verified/corrected via an address verification program, insheeted the results back into Stata, and saved it under a new file name.  My challenge now is how to put my master file back together with the addresses that were just corrected.  Any ideas?
>
> Thank you!
> Matt
>
>
> Master panel data file:
>
> oshpd_fac_no    year    facility_name    street_address    city    zip_code
> 206010734    2002    EMMANUEL COMVALESCENT HOSPITAL  ALAMEDA    508 WESTLINE DRIVE    ALAMEDA    91011
> 206010734    2003    EMMANUEL CONVALESCENT HOSPITAL  ALAMEDA    508 WESTLINE DRIVE    ALAMEDA    91011
> 206010734    2004    EMMANUEL CONVELESCENT HOSPITALALAMEDA    EMMANUEL CONVALESCENT HOSPITAL    508 WESTLINE DRIVE    91011
> 206010734    2006    EMMANUEL CONVALESCENT HOSPITALALAMEDA    508 WESTLINE DRIVE    ALAMEDA    91011
> 206010734    2007    CROWN BAY NURSING AND REHAB    508 WESTLINE DRIVE    ALAMEDA    91342
> 206010734    2008    CROWN BAY NURSING AND REHAB    508 WESTLINE DRIVE    ALAMEDA    91105
> 206010744    2002    ASHBY CARE CENTER    2270 ASHBY AVENUE    BERKELEY    94115
> 206010744    2003    ASHBY CARE CENTER    2270 ASHBY AVENUE    BERKELEY    96264
> 206010744    2004    ASHBY CARE CENTER    2270 ASHBY AVENUE    BERKELEY    92626
> 206010744    2006    ASHBY CARE CENTER    2270 ASHBY AVENUE    BERKELEY    90801
> 206010744    2007    ASHBY CARE CENTER    2270 ASHBY AVENUE    BERKELEY    94705
> 206010744    2008    ASHBY CARE CENTER    2270 ASHBY AVENUE    BERKELEY    94705
>
>
>
> Address corrected file:
> oshpd_fac_no facility_name street_address city state zip_code
> 206010734 CROWN BAY NURSING AND REHAB 508 WESTLINE DRIVE ALAMEDA CA 94501-5847
> 206010744 ASHBY CARE CENTER 2270 ASHBY AVENUE BERKELEY CA 94705-1935

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index