Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Phil Clayton <philclayton@internode.on.net> |
| To | statalist@hsphsun2.harvard.edu |
| Subject | Re: st: Post codes to locality |
| Date | Mon, 23 Apr 2012 15:48:55 -0400 |
How about: merge m:1 postcode using lookupfile, keep(match master) Phil On 23/04/2012, at 3:41 PM, Paul O'Brien wrote: > Thanks Kit, > > But I get the error message: variable postcode does not uniquely identify observations in the master data > > Many of our patients share the same post code. > > Paul > > On 23 Apr 2012, at 12:28, Christopher Baum wrote: > >> <> >> I have a clinical database with postcodes of patients and want to convert the post codes to locality (LSOA). I have a file with corresponding post codes/locality, but there are over 1m post codes in England and around 35,000 localities. >> >> An gen .. if ... command takes for ever. >> >> Is there a simper way? >> >> >> http://www.stata.com/support/faqs/data/characteristics.html >> >> >> Kit Baum | Boston College Economics & DIW Berlin | http://ideas.repec.org/e/pba1.html >> An Introduction to Stata Programming | http://www.stata-press.com/books/isp.html >> An Introduction to Modern Econometrics Using Stata | http://www.stata-press.com/books/imeus.html >> >> >> * >> * 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/ > > ------------------------------- > Dr Paul O'Brien > Raymede Clinic > Westside Contraception and Sexual Health Services > Central London Community Healthcare > Exmoor St > London > W10 6DZ > UK > +44 (0)20 8962 4450 > > > > > > > > > > > > * > * 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/ * * 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/