使用宏对数据集中的列按组求和

我有一个数据集，如下所示：

 Month   Cost_Center      Account    Actual    Annual_Budget
 June     53410           Postage       13      234
 June     53420           Postage       0       432
 June     53430           Postage       48      643
 June     53440           Postage       0       917
 June     53710           Postage       92      662
 June     53410           Phone         73      267
 June     53420           Phone         103     669
 June     53430           Phone         90      763
 ...

我想首先分别对“实际”和“年度”列求和，然后创建一个变量，在其中标记全年推断的实际值是否大于“年度”列。

我有以下代码：

 Data Test; 
 set Combined;
 %All_CC; /*MACRO TO INCLUDE ALL COST CENTERS*/
 %Total_Other_Expenses;/*MACRO TO INCLUDE SPECIFIC Account Descriptions*/
 Sum_Actual = sum(Actual);
 Sum_Annual = sum(Annual_Budget);
 Run_Rate = Sum_Actual*12;
 if Run_Rate > Sum_Annual then Over_Budget_Alarm = 1;
 run; 

但是，当我运行此代码时，它不会按组求和，例如，这是我得到的输出：

 Account_Description    Sum_Actual Sum_Annual   Run_Rate  Over_Budget_Alarm
      Postage             13      234             146           
      Postage             0       432              0 
      Postage             48      643             963            1
      Postage             0       917             0
      Postage             92      662             634            1

我正在寻找将实际和年度的所有“邮资”相加的输出，只留下一行数据。

1. 使用PROC MEANS汇总数据

2. 使用数据步骤和 IF/THEN 语句来创建标志。

   proc means data=have N SUM NWAY STACKODS;
      class account;
      var amount annual_budget;
      ods output summary = summary_stats1;
      output out = summary_stats2 N = SUM= / AUTONAME;
   run;
   
   data want;
     set summary_stats;
     if sum_actual > sum_annual_budget then flag=1; 
     else flag=0;
   run;