Hello,
I have merged data from two survey rounds which contains multiple files at the household, individual, eligible women levels. I am trying to merge the eligible women dataset with 50,000 observations with the household file that has 80,000 observations. I understand that each observation from eligible women dataset has a corresponding household ID but each household does not necessarily have an eligible woman.
I used 1:m command to merge my datasets with Household as the master and Eligible Women as the using set. However, it does not seem to work.
Can anyone please help me with this?
Thanks.
I have merged data from two survey rounds which contains multiple files at the household, individual, eligible women levels. I am trying to merge the eligible women dataset with 50,000 observations with the household file that has 80,000 observations. I understand that each observation from eligible women dataset has a corresponding household ID but each household does not necessarily have an eligible woman.
I used 1:m command to merge my datasets with Household as the master and Eligible Women as the using set. However, it does not seem to work.
Can anyone please help me with this?
Thanks.
