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?
... View more