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

Hi to all, Need kind mind about this :   Datahave : input A @@; cards; 1441.47    1465.15   1441.36   1360.16   1424.37   1387.12   1346.09   1333.36    Datawant : input A B; cards; 1441.47 1441.47 1465.15 1465.15 1441.36 1465.15 1360.16 1465.15 1424.37 1465.15 1387.12 1465.15 1346.09 1465.15 1333.36 1465.15   Where B is computed as : B= max ($A$1: A_n_) that is most greatest value of A since the first line.   Thanks. B Regards       ... View more

Hi to all,   I'm facing a problem with sas viewtable window. It does not open the data via the explorator in the work library.   I'll be very grateful if someone can help me solve this.   Best Regard         ... View more