Desktop productivity for business analysts and programmers

Conditional IF/Contains or IF/Find

Reply
Contributor
Posts: 47

Conditional IF/Contains or IF/Find

Hello, 

 

I've got some code where I'm checking for mutliple conditions to be met, and assigning a variable value depending on the conditions. However something in my syntax is off. Could anyone give me a tip? 

 

Data First_Channel_Defined;
Set Adobe_MB;
IF First_Channel = "ESHOP" AND FIND(S_CMP_Channel,'Paid Search)' AND FIND(Tracking_Code,'-b-') THEN First_Chnl_Mod ='PS_BRANDED';
ELSE IF First_Channel = "ESHOP" AND FIND(S_CMP_Channel,'Paid Search)' AND FIND(Tracking_Code,'-nb-') THEN First_Chnl_Mod ='PS_NONBRANDED';
ELSE IF First_Channel = "ESHOP" AND S_CMP_Channel = "" AND Matchtype IN ('MS','MU') THEN First_Chnl_Mod = 'CATALOG';
ELSE IF First_Channel ="ESHOP" AND S_CMP_Channel = "" THEN First_Channel_Mod = 'NO_SOURCE';
ELSE IF First_Channel = "ESHOP" THEN First_Channel_Mod = S_CMP_Channel;
ELSE IF Matchtype IN ('MS','MU') THEN First_Channel_Mod = "CATALOG";
ELSE First_Channel_Mod = "NO_SOURCE";

RUN;

Grand Advisor
Posts: 17,332

Re: Conditional IF/Contains or IF/Find

1. What makes you think something is wrong?

2. In your code you have both First_Chnl_Mod (first 3 IF's) and First_Channel_Mod (last 3 IF's), is this correct?

 

 

Respected Advisor
Posts: 4,606

Re: Conditional IF/Contains or IF/Find

Replace 'Paid Search)'  --> 'Paid Search')

PG
Ask a Question
Discussion stats
  • 2 replies
  • 194 views
  • 0 likes
  • 3 in conversation