topic Unable to get PivotFields property of Pivot Table class in ODS and Base Reporting

Unable to get PivotFields property of Pivot Table class

Sasbythebook16 — Wed, 08 Jun 2016 17:46:35 GMT

options noxsync noxwait;
/* reference the tagset from support.sas.com */
Filename tpl url
"http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/tableeditor.tpl";

/* insert the tagset into the search path for ODS templates */
Ods path(Prepend) work.templat(update);
%include tpl;

ods tagsets.tableeditor file="C:\**\temp.html"
options(addfield="Calc1 = value1/value5"
auto_excel="yes"
excel_open="yes"
sheet_name="Data"
pivot_sheet_name="sheetname"
pivotdata="value1, value2, value3, value4, value5, Calc1"
pivotdata_caption="Value 1, Value 2, Value 3, Value 4, Value 5, Calculation 1"
pivotdata_stats="sum, sum, sum, sum, sum, sum"
pivotrow="category1, category2"
pivot_format="light1"
pivotdata_toColumns="yes"
pivotdata_fmt="#,##0~ #,##0~ #,##0~ #,##0~ #,##0~0.00%"
)
;

proc print data=sumtable1; run;

ods tagsets.tableeditor close;

After running this code, I receive an error:

Unable to get PivotFields property of Pivot Table class

Please advise.

Re: Unable to get PivotFields property of Pivot Table class

Chevell_sas — Tue, 14 Jun 2016 21:02:19 GMT

Make sure that the table header names in the source worksheet and HTML table match the fields Value1-Value5 that you have included with the PivotData= option. For instance, make sure that you don't have them displayed with labels and use the actual column names in the option. The table headers should match the values specified in the Pivotdata= option.

Hi , Can you find a solution for this? Thank you in advan...

Thomas10 — Sun, 23 Feb 2020 20:17:17 GMT

Hi , Can you find a solution for this? Thank you in advance. Regards