Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: How to merge 2 datasets using 2 unique variables


From   Ulrich Kohler <[email protected]>
To   [email protected]
Subject   Re: st: How to merge 2 datasets using 2 unique variables
Date   Tue, 26 Apr 2005 15:30:14 +0200

Robin Newberry wrote:
> Folks,
>
> I've 2 datasets I need to merge (one with accident data and one with
> cost data), but the one "unique" variable they have in common (Social
> Security Number) won't work since there are multiple occurrences of
> the same individual. What I need to do is merge on two variables -
> like SSN and accident date - but I can't figure out how to do this in
> Stata. Is there a way, or do I need to merge the datasets outside of
> Stata (in Excel, for example) and import them?.

Sounds like

. sort ssn accdate
. merge ssn accdate using myfile

regards
uli

-- 
[email protected]
+49 (030) 25491-361


*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index