can I generate missing value with IFN function?

[rpg163]

Hi,

I am trying to generate missing value with "IFN" function, like this,

proc sql;

    create table E0 as

    select    A.stkcd,

            A.year,

            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;

quit;

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.

Many THX!!!

[art297 · Accepted solution]

Just use . rather than " " to indicate the missing value result.

[rpg163]

Wow, yes, I works.

Many Thanks!!!