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:
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
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
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
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
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
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
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!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: