03-14-2013 10:09 PM
I was wondering if there is a way to create Pivot tables/chart using Mainframe SAS ODS? If so, can someone point to a learning guide or a tutorial?
I searched and keep seeing Pivot is not supported as one of the output formats in Mainframe SAS 9.2 version. Does 9.3 support it? Thanks for your time and help.
03-14-2013 10:33 PM
What are you looking at where you see that Pivot tables are not supported? Do you mean using the Enterprise BI server and the SAS Add-in for Microsoft Office or do you mean that you are using TAGSETS.TABLEEDITOR on the mainframe?
03-14-2013 10:50 PM
I wanted to know if it is possible to create Pivot Table from Mainframe SAS v9.3. If so, how?
I have a pivot tablein .xls file that has 2 pivot tables and 2 pivot charts that were created using Microsoft Excel manually. It needs to be automated. I was wondering if it is possible to do that entirely in mainframe SAS and then put the excel file over to some specified location.
03-15-2013 12:34 AM
03-15-2013 06:42 PM
Perhaps another option is to write the source data for your pivot table to Excel, and (maybe) you could use Excel automation to create the pivot table within Excel?