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;
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?
Replace 'Paid Search)' --> 'Paid Search')
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.