und zur Abwechslung mal etwas proc sql 😉
Marius
data test;
input id wert;
cards;
1 3
1 5
1 7
2 1
2 2
2 3
2 4
3 5
3 5
3 5
run;
proc sql;
SELECT
id,
round
(CASE
WHEN MinVal = 0 THEN 0
WHEN mod(Neg, 2) = 1 THEN -1 * EXP(ABSMult)
ELSE EXP(ABSMult)
END)
as Mult_Wert
from(
SELECT
id,
SUM(log(ABS(ifn(wert=0, 0,wert)))) AS ABSMult,
SUM(SIGN
(CASE
WHEN wert < 0 THEN 1
ELSE 0
END)
) AS Neg,
MIN(ABS(wert)) AS MinVal
FROM
test
GROUP BY
id
) test
;
quit;
... View more
