Dear friends, I would like to ask you for help on a problem, hopefully someone can help me.

I have two sets of information, in one case is a household survey with detailed personal information, in another, I have information on purchases of people (identified by an id) the only information available is salary, age and sex.

In the set of people's purchasing information, I would like to add other details, such as years of education, number of children, characteristics of their home and internet use. But they are found in the household survey, not in this set of purchasing information.

My idea is to search within the household survey for the person with the same salary, age and sex as the person in the purchasing information set. I would like to use some sort of comparison rule, in case this is fulfilled, assign the characteristics of that person located in the household survey to the person in the purchasing information set.

Does anyone have any idea how to do this in stata?

Best regards