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.)

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Discussion stats
  • 2 replies
  • 1587 views
  • 0 likes
  • 2 in conversation