topic Re: Case when using AND in SAS Programming

Case when using AND

David_Billa — Thu, 19 Dec 2019 09:31:16 GMT

Re: Case when using AND

Kurt_Bremser — Thu, 12 Dec 2019 11:29:31 GMT

Which type is value?

Re: Case when using AND

David_Billa — Thu, 12 Dec 2019 11:33:49 GMT

Character

Re: Case when using AND

Kurt_Bremser — Thu, 12 Dec 2019 11:37:41 GMT

Then this should work:

data have;
input flg :$1. in_flow :$3. out_flow :$3. value $;
datalines;
N OUT XX 1
N XX IN 2
Y OUT XX 3
Y XX IN 4
X X X 5
;

proc sql;
create table want as
select
  have.*,
  CASE  
    WHEN FLG =  'N' and UPCASE (IN_FLOW)  =  'OUT' THEN (input(VALUE, BEST32.) * (-1))  
    when FLG =  'Y' and UPCASE (OUT_FLOW)  =  'IN' THEN (input(VALUE, BEST32.) * (-1))  
    ELSE (input(VALUE, BEST32.))  
  END as AMT
from have;
quit;

Note that, in the CASE clause, every THEN needs a WHEN.

Re: Case when using AND

FreelanceReinh — Thu, 12 Dec 2019 12:36:07 GMT

Here's an equivalent alternative definition of AMT:

(-1)**(flg='N' & upcase(in_flow)='OUT' | flg='Y' & upcase(out_flow)='IN')*input(value,32.) as AMT