can I generate missing value with IFN function?

rpg163 — Mon, 02 Apr 2012 13:48:19 GMT

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!!!

can I generate missing value with IFN function?

art297 — Mon, 02 Apr 2012 13:58:30 GMT

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

can I generate missing value with IFN function?

rpg163 — Mon, 02 Apr 2012 14:04:08 GMT

Wow, yes, I works.

Many Thanks!!!

topic can I generate missing value with IFN function? in SAS Programming

can I generate missing value with IFN function?

can I generate missing value with IFN function?

can I generate missing value with IFN function?