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
Amethyst | Level 16

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

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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