https://communities.sas.com/t5/Mathematical-Optimization/proc-netflow-constraint/m-p/13078#M213 Since I am not that familliar with PROC NETFLOW I will just keep my comments to methods to deal with this in the traditional NA method.<BR /> <BR /> If your network is simple enough, which it sounds like it maybe [i.e. every path experiences the same loss rate] then you can "Gross Up" your demand [i.e. if you know each and every path is going to have a 3% loss and your demand is 100 then adjust your demands to [100/0.97]=103.0928 <BR /> <BR /> However, a more robust way to do it is to have each path have a dummy sink which is constrained to demand loss from the main connection, this way it doesn't matter if the rates are diffferent. The idea being each real line flows to two sinks, 97% to the real one [consumer] and 3% to the virtual one [loss]<BR /> <BR /> Just some thoughts,<BR /> <BR /> Ike Eisenhauer Thu, 24 Apr 2008 13:47:47 GMT deleted_user 2008-04-24T13:47:47Z https://communities.sas.com/t5/Mathematical-Optimization/proc-netflow-constraint/m-p/13077#M212 hi,<BR /> im using proc netflow to minimize the cost of transferring water from the source to the consumers.<BR /> example: i have 1 source passing through 3 connections to 3 consumers. with a supply of 1000 cubic meters and demand of 300 cubic meters for each consumer. Each connection is subject to a water loss with coefficient of 3%.<BR /> <BR /> supply to connection1<BR /> supply to connection2<BR /> supply to connection3<BR /> connection1 to consumer1<BR /> connection1 to consumer2<BR /> .<BR /> .<BR /> .<BR /> connection3 to consumer2<BR /> connection3 to consumer3<BR /> <BR /> how can i code the water loss constraint? like if you will deliver 100 cubic meter of water going through connection1 then you can just supply 97 cubic meter of water..how can you incorporate this in the optimization?<BR /> <BR /> thanks!!hope someone can help me..<BR /> <BR /> regards,<BR /> paeng Thu, 24 Apr 2008 07:13:42 GMT https://communities.sas.com/t5/Mathematical-Optimization/proc-netflow-constraint/m-p/13077#M212 deleted_user 2008-04-24T07:13:42Z https://communities.sas.com/t5/Mathematical-Optimization/proc-netflow-constraint/m-p/13078#M213 Since I am not that familliar with PROC NETFLOW I will just keep my comments to methods to deal with this in the traditional NA method.<BR /> <BR /> If your network is simple enough, which it sounds like it maybe [i.e. every path experiences the same loss rate] then you can "Gross Up" your demand [i.e. if you know each and every path is going to have a 3% loss and your demand is 100 then adjust your demands to [100/0.97]=103.0928 <BR /> <BR /> However, a more robust way to do it is to have each path have a dummy sink which is constrained to demand loss from the main connection, this way it doesn't matter if the rates are diffferent. The idea being each real line flows to two sinks, 97% to the real one [consumer] and 3% to the virtual one [loss]<BR /> <BR /> Just some thoughts,<BR /> <BR /> Ike Eisenhauer Thu, 24 Apr 2008 13:47:47 GMT https://communities.sas.com/t5/Mathematical-Optimization/proc-netflow-constraint/m-p/13078#M213 deleted_user 2008-04-24T13:47:47Z https://communities.sas.com/t5/Mathematical-Optimization/proc-netflow-constraint/m-p/13079#M214 Hi Ike,<BR /> <BR /> thanks for the help..can you please give me a sample code for the inclusion of the dummy sink and its constrain if its possible..im new to optimization..<BR /> <BR /> Thanks!<BR /> <BR /> Regards,<BR /> Paeng Fri, 25 Apr 2008 03:40:27 GMT https://communities.sas.com/t5/Mathematical-Optimization/proc-netflow-constraint/m-p/13079#M214 deleted_user 2008-04-25T03:40:27Z https://communities.sas.com/t5/Mathematical-Optimization/proc-netflow-constraint/m-p/13080#M215 can i use a data set to represent all the sink nodes?<BR /> thanks again.. Fri, 25 Apr 2008 04:57:08 GMT https://communities.sas.com/t5/Mathematical-Optimization/proc-netflow-constraint/m-p/13080#M215 deleted_user 2008-04-25T04:57:08Z