04-09-2017 11:47 AM - edited 04-09-2017 01:34 PM
My dataset has 2000 accounts , I am readig all the accounts into macro variable and looping PROC REPORT code through each account to generate an xml report(ExcelXp Tagset).
The code generates all the output files in 15 minutes for all the accounts in my dataset , But my code in Eneterprise guide shows as Still Running and it keeps running for 30 more minutes and pops up a message saying
"the results are too large and could take a long time and a large amount of systems resources " ,
After I choose No the program will be running forever as Collecting..
How can i stop the process as soon as it generates the output files ? how do I stop the SAS Program from adding the results ?
After reading some sugesttions here I did below settings:
1) Writing Log file to directoty by using proc printto
2) Have unchecked options to not include the results to my project . Tools->Options->results -> results general .
Even after tyring the above options , there seems to be no change in the program behavior.
Can someone guide me here , Any sugesstions are much appreciated.
04-09-2017 02:21 PM
You have to show your code that keeps looping. What version of EG are you using? Do any of your PROCS need a QUIT?
04-10-2017 12:32 PM - edited 04-11-2017 10:40 AM
Thanks for responding. I am using EG 6.1 .
The program generates all the output files in 15mins ,After that it keeps running for ~30 mins and After 30 Mins the below message will be displayed
"The results are large (79567804 bytes) and could take a long time and a large amount of system resources to add to the project. Do you want to continue adding the results to the project?"
I choose NO , and the program will be Running Forver with status "Collecting " and eventually EG stops responding after ~45 mins.
I have choosen not add any results to the project from Tools->Options-> Results-> Results General
Why will it ask me to choose to add or not add results to the project even after making the selection above. It is annoying and looks like a bug in SAS.
04-10-2017 09:36 PM
04-11-2017 09:28 AM
I have spent sometime troubleshooting the code . I have truncated some of my final data records to test for multiple scenarios with different number of loops.
By incresing the number of loops SAS EG is taking lot of time collecting the results after the code execution is finished. I do not see a way to stop it from taking forever on Collecting Status.
I found it useful to use %abort return just before the end of my macro . It may not be appropriate to do it , but for now it saves me from waiting forever for SAS EG to complete Collecting the results.