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/