BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
keiwo
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
JamesAnderson
SAS Employee
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

View solution in original post

2 REPLIES 2
JamesAnderson
SAS Employee
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
Obsidian | Level 7
Thanks James...much appreciated for the quick turn around. the code works and the explanation was clear and concise.
How to improve email deliverability

SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 445 views
  • 1 like
  • 2 in conversation