https://communities.sas.com/t5/SAS-Procedures/Matrix-or-Iteration/m-p/72105#M20876 Seeing that the columns total is 8+7=15, and the line total is 6+4+4=14, you have no chance. Fri, 18 Sep 2009 05:05:55 GMT ChrisNZ 2009-09-18T05:05:55Z https://communities.sas.com/t5/SAS-Procedures/Matrix-or-Iteration/m-p/72104#M20875 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:21:18 GMT https://communities.sas.com/t5/SAS-Procedures/Matrix-or-Iteration/m-p/72104#M20875 deleted_user 2009-09-17T16:21:18Z https://communities.sas.com/t5/SAS-Procedures/Matrix-or-Iteration/m-p/72105#M20876 Seeing that the columns total is 8+7=15, and the line total is 6+4+4=14, you have no chance. Fri, 18 Sep 2009 05:05:55 GMT https://communities.sas.com/t5/SAS-Procedures/Matrix-or-Iteration/m-p/72105#M20876 ChrisNZ 2009-09-18T05:05:55Z