https://communities.sas.com/t5/SAS-Enterprise-Guide/Matrix-Iteration/m-p/72107#M7175 Sorry, I don't know the answer (actually, I don't understand the question).<BR /> <BR /> One note to a newbee: Good forum etiquette is to just post to one forum. Thu, 17 Sep 2009 16:32:44 GMT Doc_Duke 2009-09-17T16:32:44Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Matrix-Iteration/m-p/72106#M7174 I have a matrix<BR /> <BR /> A B C Total<BR /> <BR /> D 2 1 3 7<BR /> <BR /> E 4 2 2 8<BR /> <BR /> Total 6 4 4 <BR /> <BR /> <BR /> I would like to balance the interior items against the totals.....ie without changing my totals. I used microsoft excel iteration but my two output files change either the vertical total or the horizontal totals, is there a way to balance this worksheet?<BR /> <BR /> Thanks Thu, 17 Sep 2009 16:22:42 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Matrix-Iteration/m-p/72106#M7174 deleted_user 2009-09-17T16:22:42Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Matrix-Iteration/m-p/72107#M7175 Sorry, I don't know the answer (actually, I don't understand the question).<BR /> <BR /> One note to a newbee: Good forum etiquette is to just post to one forum. Thu, 17 Sep 2009 16:32:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Matrix-Iteration/m-p/72107#M7175 Doc_Duke 2009-09-17T16:32:44Z