Hi all,

I am wishing to calculate the average of the 80th percentile (variable name p80) of household income distribution in a given geographical unit (variable name geo) in the year t (variable name year with years 2001-2014) and the prior two years (t-1 and t-2).

Currently I have p80 values for all geographical units for each year. There are duplicates in the p80 variable observations as this income distribution percentile cut off is assigned to individuals in the same geographical unit reported in the same year.

After many attempts, I am struggling to find a way to formulate this in stata.

Any help would be appreciated, thanks in advance.

Rachel

I am wishing to calculate the average of the 80th percentile (variable name p80) of household income distribution in a given geographical unit (variable name geo) in the year t (variable name year with years 2001-2014) and the prior two years (t-1 and t-2).

Currently I have p80 values for all geographical units for each year. There are duplicates in the p80 variable observations as this income distribution percentile cut off is assigned to individuals in the same geographical unit reported in the same year.

After many attempts, I am struggling to find a way to formulate this in stata.

Any help would be appreciated, thanks in advance.

Rachel

## Comment