DATA Step, Macro, Functions and more

can I generate missing value with IFN function?

Accepted Solution Solved
Reply
Contributor
Posts: 60
Accepted Solution

can I generate missing value with IFN function?

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


Accepted Solutions
Solution
‎04-02-2012 09:58 AM
PROC Star
Posts: 7,363

can I generate missing value with IFN function?

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

View solution in original post


All Replies
Solution
‎04-02-2012 09:58 AM
PROC Star
Posts: 7,363

can I generate missing value with IFN function?

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

Contributor
Posts: 60

can I generate missing value with IFN function?

Wow, yes, I works.

Many Thanks!!!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 247 views
  • 0 likes
  • 2 in conversation