How to calculate the monthly average from daily data?

[Biswa bhusan]

I have daily data from 03-01-1994 to 29-12-1995. The first column is date and the second column is my observation. I want to estimate the monthly average for each month, then, i want to export the results into excel. So please suggest me the Stata code. I have attached the data file here.

[Nate Tillern]

You can try:

gen Month_Year = substr(date, 4, .)
drop if Month_Year == ""

bysort Month_Year: egen Monthly_Avg = mean(y)

This would give identical observations for Monthly_Avg for each day of the same month, but each observation should be the montly average of y.

[Biswa bhusan]

Dear Nate Tillern, Thank you