topic Re: EG Crashes When Multiple XML Files Created in SAS Enterprise Guide

EG Crashes When Multiple XML Files Created

SteveNZ — Sun, 09 Jun 2013 21:50:11 GMT

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:

Adding NOSOURCE and NONOTES to options
Adding ODS NORESULTS
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

Re: EG Crashes When Multiple XML Files Created

Cynthia_sas — Mon, 10 Jun 2013 05:32:02 GMT

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

Re: EG Crashes When Multiple XML Files Created

ChrisHemedinger — Mon, 10 Jun 2013 13:03:16 GMT

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

Re: EG Crashes When Multiple XML Files Created

SteveNZ — Wed, 12 Jun 2013 00:52:09 GMT

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

Re: EG Crashes When Multiple XML Files Created

mbusa — Wed, 04 Dec 2013 14:50:31 GMT

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