Hello,
I'm getting this message "Export features supported on I.E only" and an empty Excel-sheet when I try to create a pivot table. Could you please tell me what it means?
Data Sales;
Input product_line $ product_category $ quarter profit year;
Datalines;
A MM 1 24545 2001
A MM 2 25899 2001
B MM 4 999 2001
B MM 3 5786 2001
A NN 1 10000 2001
A NN 2 20000 2001
A MM 1 34232 2002
B NN 2 3212 2002
;
Run;
ODS Tagsets.Tableeditor File='C:\Users\MyName\Desktop\myreport.html' Options (
Pivotrow='product_line,product_category'
Pivotcol='quarter'
Pivotdata='profit'
Pivotpage='year'
Pivot_Subtotal='no'
Pivot_Grandtotal='no');
Proc Print Data=Sales; Run;
ODS Tagsets.Tableeditor Close;