04-02-2012 09:48 AM
I am trying to generate missing value with "IFN" function, like this,
create table E0 as
ifn(missing(A.sales)+missing(B.sales)+missing(C.sales)=0,std(A.Sales,B.sales,C.sales),"") as std
from firmchar.CAL_Earnings as A
left join firmchar.CAL_Earnings as B on A.stkcd=B.stkcd and A.year=B.year+1
left join firmchar.CAL_Earnings as C on A.stkcd=C.stkcd and A.year=C.year+2;
Well, it seems generating missing value with IFN function is NOT allowed.
Yet I do not want calucalte standard error if any one of three variables is missing. So, is there any way to solve this? say, some similar alternative functions.
Need further help from the community? Please ask a new question.