Hi!

I have a dataset with information on applicants to all job vacancies in an organization, for each year since 2013 to 2018. I have another dataset that gives me information on the characteristics of the staff profile for that same organization, still from 2013 to 2018. The only variables these two dataset have in common are: gender and nationality of the applicants / workers. The observations are different.

My question is: is there a way to unite these two datasets in STATA so that I can study the relationship between Y (application from a woman) and gender distribution in the organization? (e.g. if there is a correlation between how many women apply in year Y and the proportion of female workforce in the organization at year Y-1).

More in general: how can I use STATA to find matching characteristics between the applicants and those already recruited?

Thanks a lot for your help!