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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Discussion stats
  • 2 replies
  • 1176 views
  • 0 likes
  • 2 in conversation