Total value per year by number of variables without missing observation

[Jo Lidman]

Hi,

I would like to find out the mean value by dividing the total value per year by number of variables (excluding the variables with missing observations). In my case I have around 500+ variables and wondered if there exist a simple code to obtain this information?

Kind regards,

Jo

[Carlo Lazzaro]

Jo:
welcome to this forum.
The -rowmean- function availabe from -egen- might be what you're looking for.

[Jo Lidman]

Thanks so much for your help!