Excel Pivot Table Generated in SAS using ODS: How to create a calculated field?

[robert_s]

Hi Everyone,

I'm using the following documentation to build an Excel pivot table in SAS:

          http://www.sas.com/offices/NA/canada/downloads/UserGroups/CSUG-May2013/Eberhardt-PivotTables.pdf

When creating a pivot table manually (the old way) in Excel -- by entering a "formula" from within the 'Caculated Field" command --  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).

Does anyone know the SAS syntax to create such a calculated field?

[Cynthia_sas]

Hi:

  The most comprehensive description of the capabilities are here: Base SAS: Creating a Data Grid Like VB.NET For that specific question about formulas with TAGSETS.TABLEEDITOR and pivot tables, I'd recommend that you open a track with Tech Support.

cynthia