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

I need help adding a constraint to the below model that restricts the sum of "buy" for even numbered adwords to be at most 10.

proc optmodel;
set ADWORDS = 1..100;
num cost_per_click{ADWORDS} = ranuni(123);
num clicks{ADWORDS} = ranuni(567);
num conversions{ADWORDS} = ranuni(789);
num revperconversion=10;
var buy{ADWORDS} >=0;
max effectiveness =sum{a in ADWORDS}((revperconversion*conversions[a])-(clicks[a]*cost_per_click[a]))*buy[a];
con buyAtMost50: sum{a in ADWORDS}buy[a]<=50;
solve;
Quit;

1 ACCEPTED SOLUTION

Accepted Solutions
RobPratt
SAS Super FREQ

Here are two ways:

con buyAtMost10even: sum {a in ADWORDS: mod(a,2) = 0} buy[a] <= 10;
con buyAtMost10even: sum {a in 2..100 by 2} buy[a] <= 10;

View solution in original post

2 REPLIES 2
RobPratt
SAS Super FREQ

Here are two ways:

con buyAtMost10even: sum {a in ADWORDS: mod(a,2) = 0} buy[a] <= 10;
con buyAtMost10even: sum {a in 2..100 by 2} buy[a] <= 10;
SAScowboy
Fluorite | Level 6
Thank you so much. I’m still learning.

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register now

Discussion stats
  • 2 replies
  • 771 views
  • 3 likes
  • 2 in conversation