Hi everyone,

I have three variables - ProductCode, Year and PRODY. (Sample given below)
ProductCode Year PRODY
71819 1999 1919863
64177 1999 2748230
77235 1999 3112791
67312 1999 776620.1
65612 1999 1052488
65143 1999 749028.6
65793 1999 1.10E+07
66339 1999 956410.3
72699 1999 1304371
67572 1999 899837.8
6536 1999 866434.2
67951 1999 870799.5
69971 1999 811334.1
72129 1999 1266765
77281 1999 1373298
67313 1999 776620
65331 1999 639118.8
69992 1999 2275954
77612 1999 422485.3
64241 1999 1323535
74493 1999 1686471
73749 1999 945558.8
6132 1999 2163151
6121 1999 550991.6
64152 1999 1894206
69121 1999 2945978
77819 1999 2820504
6253 1999 767438.7
77635 1999 864361.1
69952 1999 1342595
77835 1999 806428.9
65312 1999 1438052
I want to create a new variable that shows the percentile based on PRODY values and by year. Can anyone help me with it?

Thank you in advance!

Sincerely,
Neha