08-26-2014 01:30 PM
I'm using the following documentation to build an Excel pivot table in SAS:
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?
08-29-2014 12:21 PM
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.