Thanks a lot, I tried but  it's still not working. I think it might be due to the computational limit of my computer ... View more

Thank you for your answer, unfortunately it's still not working. Do you I any idea what the problem could be ? Thanks ... View more

Hi everyone ! I'm using the same formula on another database and I think I'm having the following probelm : THe number i cannot go higher than 1030. He writes an error message when nit is higher than 1030. Do you know about that ? Is  there a way to solve it ? Thanks The code: Data database.lsvstock3; set database.lsvstock2; Af=0; do i=0 to nit; AF = comb(nit,i)*(Pt**i)*((1-Pt)**(nit-i))*abs((i/nit)-Pt)+AF; end; run; The log error message: NOTE: Invalid argument to function COMB at line 570 column 6. NOTE: Missing values were generated as a result of performing an operation on missing values.       Each place is given by: (Number of times) at (Line):(Column).       205291 at 570:17   20144 at 570:59 NOTE: Mathematical operations could not be performed at the following places. The results of the       operations have been set to missing values.       Each place is given by: (Number of times) at (Line):(Column).       205291 at 570:6 NOTE: There were 170 observations read from the data set DATABASE.LSVSTOCK2. NOTE: The data set DATABASE.LSVSTOCK3 has 170 observations and 11 variables. NOTE: DATA statement used (Total process time):       real time           0.24 seconds       cpu time            0.21 seconds ... View more

Thanks i'll do that ... View more

Unfortunately i'm still facing an issue I can't solve; The value I otain for right is  always >1 and sometimes superhigh. In actual facts this formula always lead to a result <1. FYI: the input Pt is always around 0,5 Do you have an idea of the problem in the code ? ... View more

Thanks a lot ! YOu were right. One row had both sell and buy equal to . i deleted it and now it's working, thanks a lot ! ... View more

I did it and there actually was a problem. The fact is that n was worth '.' when there were a buy or sell =0. So I corrected it this way Proc SQL;   update lsv.left   set n=buy where sell=.;   Proc SQL;   Update lsv.left   set n=sell where buy=.; But I still have the same error message ... View more

Thank you, I corrected it and nows the log error message becomes Invalid DO loop control information, either the INITIAL or TO expression is missing or the        BY expression is missing, zero, or invalid. ... View more

I used your code and I made sure that I treat with numeric variables. I create a num variable n that is the sum of buy and sell. But it still shows the same log error Proc SQL;   alter table lsv.left   add n num label='n';   Proc SQL;   update lsv.left   set n=buy+sell;   data  lsv.right;   set lsv.left;   right=0;   do i=0 to i=n;     calc1=(fact(n) / (fact(i) * fact(n-i)));     calc2=calc1 * (i/(n)) * ((1-Pt)**(n-i)) * abs((i/(n)-Pt));     right=calc2 + right;   end; run; ... View more

Here is the log error message NOTE: Invalid argument to function FACT at line 36 column 11. NOTE: Invalid argument to function FACT at line 36 column 36. NOTE: Invalid argument to function FACT at line 36 column 11. NOTE: Invalid argument to function FACT at line 36 column 36. ... View more