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?
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?
Thank you, I have changed to 'ne'.
The data is blank, no values in there so technically missing data.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.