How to create top up logic in SAS MA

[keiwo]

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

[JamesAnderson · Accepted solution]

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

[keiwo]

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