Re: st: merging data sets using an interaction of demographics

[Richard Williams <Richard.A.Williams.5@nd.edu>]

At 09:40 PM 2/28/2005 -0500, you wrote:
> I have two data sets A and B. I have a variable in B that I can't observe 
> in A however each data set contains common demographics from which I can 
> create a interaction term in each data set (ie age,race,income,state) I 
> can assign unique values to each interaction and merge the two data sets 
> on this interaction therefore getting my varible of interest in set A. My 
> question is that I can't get the number of observations in my merged data 
> set to equal the number of observations in the master data set "A"(ie 
> merge 3 contains more obervations than merge 1)
You might also check out the FAQ on "Why does my merge produce a dataset 
with too many observations?"  As it suggests, use the -isid- command to 
make sure your ids really are unique.

http://www.stata.com/support/faqs/data/merge.html



-------------------------------------------
Richard Williams, Notre Dame Dept of Sociology
OFFICE: (574)631-6668, (574)631-6463
FAX:    (574)288-4373
HOME:   (574)289-5227
EMAIL:  Richard.A.Williams.5@ND.Edu
WWW (personal):    http://www.nd.edu/~rwilliam
WWW (department):    http://www.nd.edu/~soc

*
*   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/