Hello, I am pretty new to SAS but I hve to maintain some older programs. Now I am stuck with a problem. I have a program that does this: PROC MEANS NOPRINT; VAR AMOUNT AVG1 AVG2; BY OBJNAME; OUTPUT OUT=WORK.SUMM1 SUM(AMOUNT) = AMOUNT MEAN(AVG1 AVG2) = AVG1 AVG2 ; Sadly the input data of AVG1 and AVG2 is not an average at all but the cumulated data, so to get real averages at the end I would have to do sum up AVG1 and AVG2 for each OBJNAME and divide it by AMOUNT. If I do PROC MEANS NOPRINT; VAR AMOUNT AVG1 AVG2; BY OBJNAME; OUTPUT OUT=WORK.SUMM1 SUM(AMOUNT) = AMOUNT SUM(AVG1 AVG2) = AVG1 AVG2 ; it looks nice but I still need the division, my idea was putting in something like AVG1= AVG1/AMOUNT but I didn't find a way how this could work. Maybe someone van give me a hint how to do this?
... View more