Hi all,
I have a dataset with different months. Each account number shows 1,2,3, etc which indicates the number of letters send to those accounts. I want to try to find the total number of letters send in each month. Basically, I want to get the sum like in March the total letter send is 2, in May it is 6. I tried the code mention below and it shows me for 1 month but when I try to add all months, its goes in not responding.
Proc sql;
select sum(FEBvols)
from No_Letter;
quit;
JANvols |
FEBvols |
MARvols |
APRvols |
MAYvols |
0 |
0 |
2 |
2 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
5 |