Dear all, As SAS don't have a prod() function acting like sum() function, could anyone give an idea about how to achieve this ? I have the variables VAR1, TIME, VALUE and I want to get the variable VAR_WANT. I know that I could use exp(sum(log())), but I can't because I have null and non positive raw values. Thanks in advance. VAR1 TIME VALUE VAR_WANT
F1 0 v1 = .5 v1*v2*v3*v4 = 0.5*0*0.7*1
F1 1 v2 = 0 v2*v3*v4 = 0*0.7*1
F1 2 v3 = .7 v3*v4 = 0.7*1
F1 3 v4 = 1 v4 = 1
F2 0 w1 = 1.3 w1*w2*w3 = 1.3*(-0.94)*0.4
F2 1 w2 = -.94 w2*w3 = (-0.94)*0.4
F2 2 w3 = .4 w3 = .4
... View more