Online File

How to use this page

---

Rick Aster: Professional SAS Programming Shortcuts: Contents

Chapter 49
Program
Percent of BY group total

---

PROC SUMMARY DATA=WORK.FUNDS;
   BY FUND;
   VAR VALUE;
   OUTPUT SUM=FUNDTOTAL OUT=WORK.TOTALS;
RUN;
DATA WORK.BALANCE;
   MERGE WORK.FUNDS WORK.TOTALS (KEEP=FUND FUNDTOTAL);
   BY FUND;
   SHARE = VALUE/FUNDTOTAL*100;
RUN;