BookmarkSubscribeRSS Feed
nitink26
Obsidian | Level 7

Hi,

 

I already opened excel file but while running below code, I am not able to refresh my pivot sheet -

data _null_;
file Excel;
put '[workbook.select("Pivot")]';
put '[error(false)]';
put '[select("A3B5")]';
put "[pivot.refresh()]";
Put '[save.as("'"&excel_file_out_lan."'")]';
put '[error(false)]';
put '[close.ALL()]';
Put "[quit()]";
run;

 

error - FATAL: Unrecoverable I/O error detected in the execution of the DATA step program. Aborted during the EXECUTION phase.

 Can someone help me? Thanks!

 

4 REPLIES 4
nitink26
Obsidian | Level 7

I forgot to mention that I tried available solutions but it didn't work for me. Thanks!

SASKiwi
PROC Star

Looks like you are trying to communicate with Excel using DDE which is no longer supported by Microsoft in the most recent versions of Office.

 

We would need to know what your complete use case is before suggesting alternative approaches.

ballardw
Super User

If this is a DDE attempt and you have not previously had DDE "working" properly you may have other software interfering with the communication channels DDE uses.

 

I had one job that was run annually that failed at DDE calls. Found out that CISCO Jabber application loaded since the last run used those channels and caused the failure. There may not be any quick fix as I had to KILL the process not shut down an active program but go into Task Manager and Kill the Jabber process to allow the program to run.

If you are having a similar issue with a different program you may have serious issues with such depending on the nature of the other program, not mention just finding which one(s) may be involved.

 

Since formal support for DDE has been non-existent for a number of years another approach may be in order.

nitink26
Obsidian | Level 7

DDE is working fine as I am able to save the Excel workbook but if I try to refresh the pivot I got the error.

is the code correct to refresh the Pivot table sheet? Thanks!

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!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 517 views
  • 0 likes
  • 3 in conversation