Conditional IF/Contains or IF/Find

GalacticAbacus — Sun, 22 May 2016 03:06:33 GMT

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;

Re: Conditional IF/Contains or IF/Find

Reeza — Sun, 22 May 2016 03:17:52 GMT

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?

Re: Conditional IF/Contains or IF/Find

PGStats — Sun, 22 May 2016 04:32:33 GMT

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

topic Re: Conditional IF/Contains or IF/Find in SAS Enterprise Guide

Conditional IF/Contains or IF/Find

Re: Conditional IF/Contains or IF/Find

Re: Conditional IF/Contains or IF/Find