EG Crashes When Multiple XML Files Created

[SteveNZ]

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

[Cynthia_sas]

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

[ChrisHemedinger · Accepted solution]

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.

Chris

[SteveNZ]

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

[mbusa]

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