Dear,

Greetings. I like to calculate mean of each quantile on each date and take the output into a format like excel because I need to process data further. I have used the following code

by mdate , sort : tabstat TotalReturnperShareasofMon , statistics( mean ) by(quant)

to get mean of each quantile on each date where mdate = monthly date, TotalReturnperShareasofMon is the variables which is to be averaged for each quant group. When I use the above command the output is generated in Results window and output is too large that it cannot be seen or handled efficiently. I shared a screenshot of my data in attachment. I would like to know what is the efficient way to calculate mean of each quantile on each date and get output in tabular format like:

mdate quant mean

Thank you very much! Array