how to deal with two datasets

[Ludovica Del Pasqua]

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!

[Bruce Weaver]

Hello Ludovica. It would be helpful if you used -dataex- to provide some small sample datasets, as suggested in the FAQ. Nevertheless, it sounds like you need the -merge- command, likely a 1:m merge, with one observation per organization in the file with staff profile info, and many observations per company in the other file with info on applicants. Type -help merge- in the Command window. There are also many resources online. Here are a few of them:

• https://www.stata.com/manuals/u22.pdf
• https://www.ssc.wisc.edu/sscc/pubs/sfr-combine.htm
• https://stats.idre.ucla.edu/stata/mo...ombining-data/

HTH.