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-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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