Dear Stata Forum,
let's say I have state level employment data of 50 states for the years 2000 and 2020, and I want to determine the growth in the number of employed workers in all 49 states from 2000 to 2020 except the state of Washington normalized by the number of employed people in the state of Washington in 2000. I would like to do this for all states leaving out the state in the numerator I normalize with in the denominator. Basically, average growth in employment in states (-i) over 20 years normalized by initial employment numbers in state (i).
My data is in long format:
State.....................Year............Empl
i.............................2000..........
i.............................2020..........
j.............................2000..........
j.............................2020..........
k............................2000..........
k............................2020..........
I am not sure how I could code this and would once again highly appreciate your help.

Thank you very much,
Best wishes,
Nico