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

["Michael Blasnik" <michael.blasnik@verizon.net>]

I'm not sure I understand.  If ssn is the only common variable, how do you 
determine which records match?  If you do have the accident date info in 
both files, then it's a simple merge in Stata -- you can merge on multiple 
variables (see whelp merge)

use accidentdata
sort ssn accidentdate
merge ssn accidentdate using costdata

(assuming you've already sorted the costdata)

Michael Blasnik
michael.blasnik@verizon.net

----- Original Message ----- 
From: "Robin Newberry" <wnewber@CLEMSON.EDU>
To: <statalist@hsphsun2.harvard.edu>
Sent: Monday, April 25, 2005 10:43 AM
Subject: st: How to merge 2 datasets using 2 unique variables



> 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?.
> --
> Robin
> --------------------------------------------------------------
> W. Robert Newberry, IV CIH, CHMM
> Chief Environmental Health and Safety Officer
> Clemson University
*
*   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/