topic Re: Excel calculations through SAS in SAS Programming https://communities.sas.com/t5/SAS-Programming/Excel-calculations-through-SAS/m-p/103194#M21534 <HTML><HEAD></HEAD><BODY><P>Art's suggestion is right on the money, for straightforward calculations, like a difference column.</P><P>The formulas in the FIELD2 row in your "sample.xls" are just column totals, but your message seeks the total along the diagonal for the first FIELD2 cell. What plan have you for the next FIELD2 cells?</P></BODY></HTML> Fri, 24 Aug 2012 22:55:27 GMT Peter_C 2012-08-24T22:55:27Z Excel calculations through SAS https://communities.sas.com/t5/SAS-Programming/Excel-calculations-through-SAS/m-p/103192#M21532 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have an excel sheet with calculations which needs to be implemented through SAS to automate the report. Please find the attchment for the sample excel sheet. I want to get the <STRONG>field2</STRONG> values as shown in the excel template using sas code. For example field2 first value is getting generated by calculating column values i.e. (C10+D11+E12+F13+G14+H15+I16+J17+K18+L19+M20+N21). So i want to implement these calculations using sas. Can anyone suggest on this.</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 24 Aug 2012 08:52:55 GMT https://communities.sas.com/t5/SAS-Programming/Excel-calculations-through-SAS/m-p/103192#M21532 Vish33 2012-08-24T08:52:55Z Re: Excel calculations through SAS https://communities.sas.com/t5/SAS-Programming/Excel-calculations-through-SAS/m-p/103193#M21533 <HTML><HEAD></HEAD><BODY><P>It sounds like you want to embed the formula into the worksheet so that it will be active.&nbsp; This can be accomplished using the Output Delivery System, ODS.&nbsp; There have been a number of papers written on the topic.&nbsp; Try google: sas ods excel formula</P><P><BR /> </P></BODY></HTML> Fri, 24 Aug 2012 20:57:18 GMT https://communities.sas.com/t5/SAS-Programming/Excel-calculations-through-SAS/m-p/103193#M21533 ArtC 2012-08-24T20:57:18Z Re: Excel calculations through SAS https://communities.sas.com/t5/SAS-Programming/Excel-calculations-through-SAS/m-p/103194#M21534 <HTML><HEAD></HEAD><BODY><P>Art's suggestion is right on the money, for straightforward calculations, like a difference column.</P><P>The formulas in the FIELD2 row in your "sample.xls" are just column totals, but your message seeks the total along the diagonal for the first FIELD2 cell. What plan have you for the next FIELD2 cells?</P></BODY></HTML> Fri, 24 Aug 2012 22:55:27 GMT https://communities.sas.com/t5/SAS-Programming/Excel-calculations-through-SAS/m-p/103194#M21534 Peter_C 2012-08-24T22:55:27Z