Exclude the Client in a campaign once it already received communication 5x.

[otepalborida]

Hi SAS Community,

Good day!

I have some logical scenario needed, i want to count then exclude the clients in the sms campaigns once they already received sms communication five times already (x5) within the span of their offer validity.

Here are the tables and columns where the communication is being saved, just in case 

CI_CONTACT_HISTORY

- CUID

- CONTACT_DT

- CONTACT_HISTORY_STATUS

SMS_OUTPUT_LOAD

- CUID

- PROCESSED_DT

Thank you.

Regards,

Otep

[Kurt_Bremser]

Counting item can easily be done in SQL:

proc sql;
create table exclude as
  select
    cuid,
    count(*) as count
  from ci_contact_history
  group by cuid
  having calculated count > 4
;
quit;

For more detailed code, supply example data in usable form (data steps with datalines), and the expected result from that.

[otepalborida]

Hi @Kurt_Bremser , do you have an example wherein the logic can be used in the campaign diagram in SAS Customer Intelligence Studio.

[Kurt_Bremser]

No, we don't use that. I am a pure coder.