SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

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

Reply
Senior User
Posts: 1

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

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?

SAS Super FREQ
Posts: 8,718

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

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

Ask a Question
Discussion stats
  • 1 reply
  • 830 views
  • 0 likes
  • 2 in conversation