Hi all, I had four conditions to be passed on status variable. If customer don`t have service 01 then customer should have a status "Other" If customer last 6m sales is blank customer should have status "Call BACK" If customer dont last 9m sales and in last 6m sales is blank customer should have a status "Gone" If customer had sales in the last 6 m and last 9 m then customer should have a status "Active" I tried to replicate these condition to SAS but at the moment ,I had only the status "others" that work fine and the status "call back" is passed on to my all customers even though some of them should have a status "gone" or "active". Below is my attempt to code the conditions : if (Service ^= "01") then status = "Others"; else if (Service = "01") and ('last 6m sales' <= '0') and ('last 9m sales' <= '0') then Status = "Gone"; else if (Service = "01") and ('last 6m sales' <= '0') then Status = "Call Back"; run; Here you can see what the output should be. Customer Service Sales last 6 Sales last 9 Status A O1 2 Call Back B O2 3 2 Others c O1 1 1 Active d O1 Gone The only thing I can see it that instead to type <=0 as a condition it should be about looking for missing values? Thanks in advance.
... View more