dummy variable for percentiles

[OBADA ALMAJALI]

Hello Everyone,

Could anyone help me to generate dummy variable equals one if some variable has values exceeds the 90th percentiles within its industry

[Mike Lacy]

You gave us no description of the format of your data. So, I'll guess that you have an industry variable, in which case something like the following would work:

bysort industry: egen above90 = pctile(YourVariableName), p(90)
replace above90 = (YourVariableName > above90)