topic Re: If then else if statement not working in SAS Enterprise Guide

If then else if statement not working

Deepti_virmani — Thu, 11 May 2017 10:30:47 GMT

WHATS WRONG WITH THIS IF THEN ELSE STaTEMENT ? It keeps throwing error

Data work.XX1;

27 set work.XX;

29 where INTRA_IND = 'N' ;

31 if MSG_ID = 'NO MSG'

33 then

35 RELATIONSHIP_ID = GLOBL_CUST_ID ;

37 RELATIONSHIP_NAME = CUS_NAME;

39 else

____

160

2 The SAS System 10:23 Thursday, May 11, 2017

ERROR 160-185: No matching IF-THEN clause.

41 RELATIONSHIP_ID = MSG_ID;

Re: If then else if statement not working

Astounding — Thu, 11 May 2017 10:37:26 GMT

You need a slightly different syntax with multiple "then" results:

if MSG_ID = 'NO MSG' then do;

RELATIONSHIP_ID = GLOBL_CUST_ID ;

RELATIONSHIP_NAME = CUS_NAME;

end;

else ...

Re: If then else if statement not working

RW9 — Thu, 11 May 2017 10:37:46 GMT

Its not syntactically correct, if/then else can only have one command between then and else, and no ;. To do block of code between then and else you use do; and end;, per:

data work.xx1;
  set work.xx;
  where intra_ind='N';
  if msg_id='NO MSG' then do;
    relationship_id=globl_cust_id;
    relationship_name=cus_name;
  end;
  else do;
    ...
  end;
run;