topic Re: Excel Pivot Table Generated in SAS using ODS: How to create a calculated field? in Microsoft Integration with SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Excel-Pivot-Table-Generated-in-SAS-using-ODS-How-to-create-a/m-p/176095#M1507 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P>&nbsp; The most comprehensive description of the capabilities are here: <A href="http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/index.html" title="http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/index.html">Base SAS: Creating a Data Grid Like VB.NET</A> For that specific question about formulas with TAGSETS.TABLEEDITOR and pivot tables, I'd recommend that you open a track with Tech Support.</P><P>cynthia</P></BODY></HTML> Fri, 29 Aug 2014 16:21:41 GMT Cynthia_sas 2014-08-29T16:21:41Z Excel Pivot Table Generated in SAS using ODS: How to create a calculated field? https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Excel-Pivot-Table-Generated-in-SAS-using-ODS-How-to-create-a/m-p/176094#M1506 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I'm using the following documentation to build an Excel pivot table in SAS:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="http://www.sas.com/offices/NA/canada/downloads/UserGroups/CSUG-May2013/Eberhardt-PivotTables.pdf" title="http://www.sas.com/offices/NA/canada/downloads/UserGroups/CSUG-May2013/Eberhardt-PivotTables.pdf">http://www.sas.com/offices/NA/canada/downloads/UserGroups/CSUG-May2013/Eberhardt-PivotTables.pdf</A></P><P></P><P>When creating a pivot table manually (the old way) in Excel -- by entering a "formula" from within the 'Caculated Field" command --&nbsp; it is possible to create a new pivot table variable that divides one variable (the sum or average of that variable) by another variable (also the sum or average).</P><P></P><P>Does anyone know the SAS syntax to create such a calculated field?</P></BODY></HTML> Tue, 26 Aug 2014 17:30:06 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Excel-Pivot-Table-Generated-in-SAS-using-ODS-How-to-create-a/m-p/176094#M1506 robert_s 2014-08-26T17:30:06Z Re: Excel Pivot Table Generated in SAS using ODS: How to create a calculated field? https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Excel-Pivot-Table-Generated-in-SAS-using-ODS-How-to-create-a/m-p/176095#M1507 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P>&nbsp; The most comprehensive description of the capabilities are here: <A href="http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/index.html" title="http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/index.html">Base SAS: Creating a Data Grid Like VB.NET</A> For that specific question about formulas with TAGSETS.TABLEEDITOR and pivot tables, I'd recommend that you open a track with Tech Support.</P><P>cynthia</P></BODY></HTML> Fri, 29 Aug 2014 16:21:41 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Excel-Pivot-Table-Generated-in-SAS-using-ODS-How-to-create-a/m-p/176095#M1507 Cynthia_sas 2014-08-29T16:21:41Z