Dear Statalisters,

I am currently working on a university project and am struggeling to build a variable for "male" and "female" occupations. I am using Stata Version 14.2, and I am working with the german dataset NEPs and the ISCO coded occupation variable. Specifically I would like to create a variable indicating whether an individual works in a primarily male or female connotated occupation. I define an occupation as "female" if 70% or more working in this occupation are female and "male" if 30% or less are female.
The occupation variable is p731904_g3, the sex variable is named psex.

I typed

tab p731904_g3 psex, row

to get the row percentage of each occupation, but I am clueless on how to create the variable I need and don't know how to pursue. Thoughts and help are very welcome.
Thank you!