Desktop productivity for business analysts and programmers

EG Crashes When Multiple XML Files Created

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 87
Accepted Solution

EG Crashes When Multiple XML Files Created

Hi all,

I've been tasked with moving a group of analysts over to EG to save money on Base SAS licenses. What I've been doing is taking SAS programs and converting them to use in EG. What I'm finding is that if EG is asked to create a large number of XML files via the ExcelXP tagset it crashes. Sometimes it just freezes during a proc report other times I get a SAS.exe has stopped working.

I've tried a number of approaches and nothing so far has worked. What I've tried is:

  1. Adding NOSOURCE and NONOTES to options
  2. Adding ODS NORESULTS
  3. Not opening my Base SAS which uses RSASUSER before running the program

Does anyone have any other suggestions that I could try? The same code works without any issue whatsoever in Base SAS.

Very frustrating!

cheers

Steve


Accepted Solutions
Solution
‎06-10-2013 09:03 AM
Community Manager
Posts: 2,693

Re: EG Crashes When Multiple XML Files Created

Even if you add ODS NORESULTS to your program, SAS Enterprise Guide is still generating some ODS statements that might have an effect.

Try this: while in the program editor, click the Properties icon (upper right side of the toolbar on top of the program window).  In the Properties window, select the Results tab.  Select the Customize option, and clear all of the results types checkboxes.  This tells EG to not open any ODS destinations while running the program -- except for those that you declare within your own code.

codeprop.png

Chris

View solution in original post


All Replies
SAS Super FREQ
Posts: 8,719

Re: EG Crashes When Multiple XML Files Created

Hi:

This sounds like an issue for Tech Support. They can look at your code and test with the same version of SAS and EG that you use. They will probably need to look at your logs. Especially with the SAS.EXE not working message.

cynthia

Solution
‎06-10-2013 09:03 AM
Community Manager
Posts: 2,693

Re: EG Crashes When Multiple XML Files Created

Even if you add ODS NORESULTS to your program, SAS Enterprise Guide is still generating some ODS statements that might have an effect.

Try this: while in the program editor, click the Properties icon (upper right side of the toolbar on top of the program window).  In the Properties window, select the Results tab.  Select the Customize option, and clear all of the results types checkboxes.  This tells EG to not open any ODS destinations while running the program -- except for those that you declare within your own code.

codeprop.png

Chris

Frequent Contributor
Posts: 87

Re: EG Crashes When Multiple XML Files Created

Hi Chris,

That seems to have fixed it which is strange as I'd turned everything off under Tools > Options. I'll do some more testing but it handled the amount I threw at it the other day when it crashed. Thanks to both yourself and Cynthia, much appreciated.

cheers

Steve

New Contributor
Posts: 3

Re: EG Crashes When Multiple XML Files Created

Hi,

I am having this same problem with SAS itselft. the program seems to execute but SAS hangs up when creating the xml file.

Does anyone have any advice as to how to fix this?

It is very frustrating!!

Best,

Michelle

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 358 views
  • 3 likes
  • 4 in conversation