cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sanjanko
‎03-19-2019
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Solver in SAS - select rows that sum to a given value (with more t...

by Calcite | Level 5 in Mathematical Optimization, Discrete-Event Simulation, and OR
‎03-18-2019 08:53 PM
‎03-18-2019 08:53 PM
I start from this data: Volume Price Tot. cost(vol*price) 100 5 500 200 6 1200 300 7 2100 400 8 3200 500 9 4500 1000 5 5000   I need to obtain only that: Volume Price Tot. cost(vol*price) 200 6 1200 500 9 4500   I only want to select these rows. The problem is that the sum of 200 and 500 gives me 700. It's not one unique row with 700,  but the sum. I need to tell SAS that it has to select rows that sum up to a certain value. This should be done with: PROC OPTMODEL; just my code does't work. Thanks. ... View more

Re: Solver in SAS - select rows that sum to a given value (with more t...

by Calcite | Level 5 in Mathematical Optimization, Discrete-Event Simulation, and OR
‎03-18-2019 08:42 PM
‎03-18-2019 08:42 PM
I need to select the rows that sum up to Tot. Volume = 700. In this example, in order to obtain that Volume I need to select row 2 and row 5. All the others should not be selected. I am not able to do this selection of rows. In Solver Excel works, but I don't know how to reproduce it in SAS. Thanks! ... View more

Solver in SAS - select rows that sum to a given value (with more than ...

by Calcite | Level 5 in Mathematical Optimization, Discrete-Event Simulation, and OR
‎03-18-2019 07:55 PM
‎03-18-2019 07:55 PM
Small sample of data I have - for example:   Volume  Price   Tot. cost(vol*price)   100          5            500 200          6            1200 300          7             2100 400          8            3200 500          9            4500 1000        5             5000   I want to select the rows where: 1) Tot volume= 700 and 2) Tot. cost=5700. In excel I use a binary variable that I multiply with Volume and Tot. cost and, after solving, it becomes 1 if the rows is selected and 0 otherwise.   I am not able to replicate this kind of solver in SAS. Thanks for your help! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-19-2019 01:20 AM
Quick links