Create an indicative variable

[Steven Vaccato]

Hello everyone.

I hope you can help me with a problem I am currently working on. I have a database that contains employment and university information in Ecuador. The database is in a wide format and has a unique identifier per person. The main variable is the salary in each month worked. So I have a period from 2012 to 2022, I have at least 132 salary variables (salary1, salary2, salary3, etc). Suffix 1 refers to January 2012, while suffix 132 refers to December 2022. Now I have another variable that tells me the graduation date of each person. I recently managed to create a variable called a hook-up salary that basically indicates the first salary that the person receives after graduating. Now I need to create a variable that tells me the salary in the following period, for which I want to create a variable called T1, which is the average of the 12 salaries after the down payment. I need this to be successive, that is, to create another variable called T2 that is the average of the 12 salaries after T1 and so on, at least until I reach T10 since I have resigtros since 2012. I welcome any comments

[Nick Cox]

This earlier thread seems clearer to me because there is a data example. Please don't run two or more threads on the same topic at once.

https://www.statalist.org/forums/for...ative-variable