Dear all,


i'm trying to compute the level of education to occupation mismatch for the individuals in my dataset. (I am working Marsh CPS Data from 2017 and 2018).
the idea is to take the mode of education for a particular occupation, hence the most common level of education and then take a standard deviation above and a standard deviation below that level and consider those individuals either overeducated or undereducated. the thing is, i don't know how to compute the mode for both these variables, they need to be somehow combined, and this eludes my stata skills. So one task, I think, would be combining these two Datasets and then measuring the mean. Would you happen to have an idea of how to go about this?
Thank you very much in advance.


Lukas