BookmarkSubscribeRSS Feed
user24feb
Barite | Level 11

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;

2 REPLIES 2
JuanS_OCS
Azurite | Level 17

- Do you have installed Internet Explorer?

- Is Internet Explorer your default web browser?

- Which program are you making use now? Guide, SAS Base, SAS Studio...

user24feb
Barite | Level 11

- Do you have installed Internet Explorer?  --> Yes, I have.

- Is Internet Explorer your default web browser? --> Yes.

- Which program are you making use now? Guide, SAS Base, SAS Studio... --> I run the SAS program from the Enterprise Guide and the html opens in the Internet Explorer.

(If "I.E" is the abbreviation of Internet Explorer, the message does not make sense.)