PROC SQL Case Statement

[KC_16]

Hi,

I have the following Case Statement but it doesn't seem to be working as I get the same output for each row ('Exclude') and I think it's due to not understanding 'NULL'. 

case when Curr_Order <> 'null ' and Prev_Order = 'Null' then 'Include' else 'Exclude' end as Order_test

Any idea how I could resolve this please? 

[PeterClemmensen]

1) Use ne instead of <>. <> returns the smallest of two arguments. See this

data _null_;
    a= 1 <> 10;
    put a;

    b=1 >< 10;
    put b;
run;

2) Does your data contain the string 'Null'/'null' or are you talking about missing values?

[KC_16]

Thank you, I have changed to 'ne'. 

The data is blank, no values in there so technically missing data. 

[PeterClemmensen · Accepted solution]

ok. Either use blanks instead of 'Null' then or use the Missing Function