https://communities.sas.com/t5/SAS-Enterprise-Guide/Multiple-two-data-table-matrics-multiplying/m-p/39627#M4738 Hi.<BR /> <BR /> How can I multiply two tables easily? <BR /> (e.g. 3x4 table multiply with 4x1 table to become 3x1 tables) <BR /> <BR /> <B>Table 1 </B> <BR /> A B C D<BR /> 0 1 0 1<BR /> 1 0 1 0<BR /> 1 1 1 1<BR /> <BR /> <B>Table 2</B><BR /> a 12 <BR /> b 3 <BR /> c 5<BR /> d 7<BR /> <BR /> <U>Output</U> = A*a +B*b +C*c+D*d <BR /> A B C D Output<BR /> 0 1 0 1 10<BR /> 1 0 1 0 17<BR /> 1 1 1 1 27 Tue, 02 Jun 2009 00:36:44 GMT JChan10 2009-06-02T00:36:44Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Multiple-two-data-table-matrics-multiplying/m-p/39627#M4738 Hi.<BR /> <BR /> How can I multiply two tables easily? <BR /> (e.g. 3x4 table multiply with 4x1 table to become 3x1 tables) <BR /> <BR /> <B>Table 1 </B> <BR /> A B C D<BR /> 0 1 0 1<BR /> 1 0 1 0<BR /> 1 1 1 1<BR /> <BR /> <B>Table 2</B><BR /> a 12 <BR /> b 3 <BR /> c 5<BR /> d 7<BR /> <BR /> <U>Output</U> = A*a +B*b +C*c+D*d <BR /> A B C D Output<BR /> 0 1 0 1 10<BR /> 1 0 1 0 17<BR /> 1 1 1 1 27 Tue, 02 Jun 2009 00:36:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Multiple-two-data-table-matrics-multiplying/m-p/39627#M4738 JChan10 2009-06-02T00:36:44Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Multiple-two-data-table-matrics-multiplying/m-p/39628#M4739 That's reasonably easy to do in IML, but it is not what EGuide was designed for. Check out the SAS/IML Studio in 9.2 . Tue, 02 Jun 2009 17:31:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Multiple-two-data-table-matrics-multiplying/m-p/39628#M4739 Doc_Duke 2009-06-02T17:31:15Z