Hi,

I have three datasets with master data (userid, names, email addresses, salary etc) data1 (email and salary) and data2 (email, salary and demographic information)
My master data has some gaps in salary and I am trying to user data1 and data2 to fill those gaps.

My aim is to match the userid to salary but since people used multiple email addresses in data1 and data2, I am finding it hard to match them. This is easily done if I manually do it, but I would it to be able to replicate the concept/logic in future too hence stata use

This is what I want - create a possible loop or a way where with the following steps
(1) when salary is missing - the masterfile matches emailid in master data to email id in my data1, return salary information if it exists
(2) for the salary information is still missing, use masterfile email with data2 email ids to fill in the remaining salary information.

I have done this in excel already and the above results my 100 missing salary information down to 10 which am happy with.

I know how to do this in a very long way in stata i.e. create new files each time and match missing ones but i am hoping there is a loop wherein i can mention the salary to be replaced if email id doesnt match masterfile then data1 file and then data2 file.

I would appreciate your input on this or a good way of implementing this.

Thank you
Anna