How to generate the mean value of a time series variable over a period?

[Zhang Hui]

Dear all.

I want to generate the mean value of a time series variable over a period.

My sample code is as below.

egen var1 = mean(var) if  yq >= 1979 & yq <= 2016

But I want to attain a single value of its mean instead of a series.

Thanks for any help.

[Clyde Schechter]

summ var if inrange(yq, 1979, 2016), meanonly
local result = r(mean)

display `result'

[Zhang Hui]

Thanks for Clyde's help. But how to use `result' if I want to derive an formula as below.

gen alpha1rho = (1-Lrate)*result

Thanks.

[Nick Cox]

Clyde has already signalled that. Use local macro punctuation. See [U] 18 for more.

Alternatively use a scalar:

summ var if inrange(yq, 1979, 2016), meanonly  
scalar result = r(mean)  
gen alpha1rho = (1-Lrate)*result

[Zhang Hui]

Hi Prof. Nick. Thanks for your help.