Hi everyone,

Was looking for a solution to the following problem.

I have a panel data that has some missing values as shown below.

Code:
Year  HoustId MedSalary
2002 1   .
2002 1   .
2002 1   .
2002 1   .
2002 1   .
2002 1   .
2002 1   .
2002 1   .
2002 1   23
2002 1   23
2002 1   23
2002 1   23
How can I replace the missing values with the actual group values that has the result data as shown below?
Code:
Year  HoustId MedSalary
2002 1   23
2002 1   23
2002 1   23
2002 1   23
2002 1   23
2002 1   23
2002 1   23
2002 1   23
2002 1   23
2002 1   23
2002 1   23
2002 1   23
The data is sorted by Year, HousetId.

In short, I need the entire (Year HoustId) to have the same non-missing (actual) MedSalary.

Thanks in advance,

J