topic Re: Proc report keeps running even after outputting all the resulst in ODS and Base Reporting

Proc report keeps running even after outputting all the resulst

mgorripati — Sun, 09 Apr 2017 17:34:02 GMT

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.

Thanks,

Re: Proc report keeps running even after outputting all the resulst

Reeza — Sun, 09 Apr 2017 18:21:42 GMT

You have to show your code that keeps looping. What version of EG are you using? Do any of your PROCS need a QUIT?

Re: Proc report keeps running even after outputting all the resulst

mgorripati — Tue, 11 Apr 2017 14:40:49 GMT

Hi Reeza,

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.

Re: Proc report keeps running even after outputting all the resulst

Cynthia_sas — Tue, 11 Apr 2017 01:36:53 GMT

Hi:
Many of your options, such as HEADLINE, HEADSKIP, are LISTING only options and are completely ignored by TAGSETS.EXCELXP.

You do not have data for anyone to test your code with and it's not clear to me what the logic of your macro program is. For help with your issue, your best bet is to work with SAS Tech Support.

I have a few debugging suggestions -- simplify the code and test each piece separately. Make sure that your macro loop is executing only the correct number of times. It doesn't appear that anything in your PROC REPORTs would be causing issues, but depending on how many times your macro loop is executing, you could be generating code that has issues running.

cynthia

Re: Proc report keeps running even after outputting all the resulst

mgorripati — Tue, 11 Apr 2017 13:28:44 GMT

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.