IF Statements Problem with Precedence

JediApprentice — Tue, 20 Sep 2016 14:07:52 GMT

I'm having an issue with if statements in terms of which if statement takes precedence when the similar conditions are met. Let me explain. This is my data:

data MACID;
  input ApprovedPriceType $ 'GER Pharm'n $ Instate $ Code_MAC $;
datalines;
MAC2501A CVS MACHZ .
MAC5251A CVS MACHZ MAC01
MACCHPCO CVS MACHZ MAC02
MACCHPME CVS MACHZ MACMEDCARE
MACHZ CVS MACJX .
MACIA CVS MACJX MAC01
MACNC CVS MACJX MACMEDCARE
;

And this is my code:

data MACLIST;
  set MACID;
if ApprovedPriceType in('MAC5251A','MACCHPCO','MACHZ','MACNC') then MAC_List=ApprovedPriceType;
if 'GER Pharm'n='CVS' and Instate='MACHZ' and Code_MAC='MAC02' then MAC_List='MAC02';
if 'GER Pharm'n = 'CVS' and Instate = 'MACHZ' and Code_MAC='MAC01' then MAC_List='MAC2501A1J';
run;

What I'm trying to do with the first if statement is make it have precedence over any proceeding if statement. So, for example, if the ApprovedPriceType is 'MACCHPCO', I want the MAC_List to be 'MACCHPCO'. The trouble is, once it hits the second if, which matches the conditions of the 'MACCHPCO' line in the data, I get 'MAC02' as the MAC_List. Why is this? I tried flipping the lines and it still didn't work. How can I fix this? Thank you for your help.

Re: IF Statements Problem with Precedence

Loko — Tue, 20 Sep 2016 14:15:11 GMT

Hello,

Use else if for the 2nd and third statement.

topic IF Statements Problem with Precedence in SAS Programming

IF Statements Problem with Precedence

Re: IF Statements Problem with Precedence