fill missing data

[basil]

how do I fill missing data? i would like to fill missing data with its recent value. For example, 1 2 3 NA 4 5 becomes 1 2 3 3 4 5.
Are there other options for filling missing data?

[EViews Gareth]

Interpolation is the standard method (available from the proc menu). It won't do the specific one you want, though. For that you could do something like:

Code: Select all

series xfilled = @recode(x=na, x(-1), x)

where X is the series that has the missings.

[dagfinnrime]

Hi,

the following is better as it also handles cases with multiple NAs in a sequence.

Code: Select all

series xfilled = @recode(x=na, xfilled(-1), x)

Dagfinn