Modify a variable

[mpsc19]

Sorry for my english. Im using Eviews 7.
The image shows a single individual in four periods of time, where the variable "anedhijos" shows the years of education of that individual and the variable "anedpadres" shows the years of education of that individual's father. As can be seen in these two variables, it is not logical that in one quarter the individual has zero years of education and in the following quarter he has eight years of education. This is an error of the data, and what I'm looking for is some way that with a function you can make these zeros correct and put the number that corresponds in all periods, that is, for example,
that in all the quarters for the variable "anedhijos" appear the number 8. Can it be done? Thanks.

[EViews Gareth]

Have all individuals finished education during all periods in the sample?

[mpsc19]

According to what I understood from your question, yes, those years of education are those that are complete, if you are studying at that time to have, for example, nine years of education, the variable will only be eight years because they are the years that has completed

[EViews Gareth]

Code: Select all

anedhijos = @maxsby(anedhijos, @crossid)

[mpsc19]

Thanks!!