帮朋友求助一个sas的问题-经管之家官网！

免费学术公开课,扫码加入

Can I seek your help on SAS PROC MEAN?

What I need is I want to first find the average for each stock for each period.

Then I want to average the stock's turnover average for each period.

As an example, I first need to know stock's 1 turnover average for 2000 Q1.

= (54+34+64+12)/4

= 41

Then I need to know stock's 2 turnover average for 2000 Q1.

= (31+42+52+53)/4

= 44.5

Then I need to find the simple average of all the stock's turnover for 2000 Q1.

= (41+44.5) / 2

= 42.75

Ultimately, I want to find out the 42.75 for each time period.

Right now the way I'm doing it is the following.

proc means no print data = turnover maxdec = 9;

output out = turnover1;

class date share;

variable turnover;

run;

Then I will get something like this

2000Q1 1 41

2 44.5

Then to find the simple average of all the stock's average turnover for 2000Q1, I will manually find the average by adding 41 to 44.5 and then divide it by 2.

However, this is incredibly time consuming because I have around 1000 stocks for each time period. If I sum it up manually and then divide it by the number of stocks.

So, may I ask if you have any simpler methods to help me obtain my final answer?

Thank you so much

「经管之家」APP：经管人学习、答疑、交友，就上经管之家！
免流量费下载资料----在经管之家app可以下载论坛上的所有资源，并且不额外收取下载高峰期的论坛币。
涵盖所有经管领域的优秀内容----覆盖经济、管理、金融投资、计量统计、数据分析、国贸、财会等专业的学习宝库，各类资料应有尽有。
来自五湖四海的经管达人----已经有上千万的经管人来到这里，你可以找到任何学科方向、有共同话题的朋友。
经管之家（原人大经济论坛），跨越高校的围墙，带你走进经管知识的新世界。
扫描下方二维码下载并注册APP