topic PROC SQL Case Statement in SAS Programming

PROC SQL Case Statement

KC_16 — Mon, 11 Nov 2019 10:29:56 GMT

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?

Re: PROC SQL Case Statement

PeterClemmensen — Mon, 11 Nov 2019 10:40:12 GMT

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?

Re: PROC SQL Case Statement

KC_16 — Mon, 11 Nov 2019 10:42:13 GMT

Thank you, I have changed to 'ne'.

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

Re: PROC SQL Case Statement

PeterClemmensen — Mon, 11 Nov 2019 11:13:37 GMT

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