topic Re: How to create top up logic in SAS MA in SAS Customer Intelligence

How to create top up logic in SAS MA

keiwo — Wed, 25 Mar 2020 18:43:41 GMT

Greetings SASCI colleagues,

Objective: aim to get 1200 + 5% Control = 1300 leads per execution run

Priority 1: use all available volume from the XYZ model

Priority 2: if XYZ volume is not enough then fill with those customers who are mapped to another scoring model.

How would I implement this logic in SAS MA ? I was thinking priority node...

Thanks in advance

Re: How to create top up logic in SAS MA

JamesAnderson — Wed, 25 Mar 2020 22:23:05 GMT

Hi Keiwo,
What you are after is a "Prioritised Limit" - unfortunately there isn't a standard node in CI Studio that does this. However with a few lines of code you can implement this in a Process node. Attach the input cells you need to the Process Node (if you are on 6.4 or higher then the Process node has a tab in the UI called Input Nodes which allows you to control the order, prior versions the order in which you attach the nodes is important and set the order they are processed). Then you can use the following code (plus other statement as needed for an MA STP or Code Node):
%let limit = 1300;
data &outtable;
set &INPUTTABLELIST;
if _N_ =< &limit;
run;
If you create an STP for this you can provide the limit as a user prompt and be flexible about the limit rather than setting it in code.
Regards
James

Re: How to create top up logic in SAS MA

keiwo — Thu, 26 Mar 2020 12:21:51 GMT

Thanks James...much appreciated for the quick turn around. the code works and the explanation was clear and concise.