BookmarkSubscribeRSS Feed
Calcite | Level 5

When I connected to Hosted SAS using RDP, the program contains two parts, data step and proc report.
Recenty, the procedure for proc report is failed, it encounted with the "error: An exception has been encountered" and SAS is suspended, the final rtf is cutted.


Sometime I run this program is ok and the final rtf is complete, but recently it does not work. However, I didn't cnage any code in this program ever. Now it is still failed when I run this program, even though I run many times. It means I cannot get incomplete output in rtf file as before.

I am wondering if anyone has the same issue?



Super User

You could run into memory problems depending on the size of the input data. Or your environment (available memory etc) is different between runs (other processes might have used up RAM/disk space that you need)

Calcite | Level 5

Sometimes the input dataset maybe only few raws, it also encounted this problem. But the same program is work before just need to run more times. I am not sure if it is possible due to the memory setting is different between runs because I have no idea how to check...we run on the server via RDP....

Diamond | Level 26 RW9
Diamond | Level 26

Sounds like you need to speak with your IT helpdesk/Hosting provider.  Without information about what your setup is, what code you are running etc. its near on impossible to diagnose.  Could be anything from network connectivity, your code generating vast amounts of log/output, host running out of storage space, bad installation etc.

Calcite | Level 5

Thanks for the advise. You mentioned about "your code generating vast amounts of log/output, host running out of storage space,..."

where or how can I identify the situation is possible caused by running out space or meomry? Because I spoke with our IT, they thought it maybe caused by program code bug in proc report...

Diamond | Level 26 RW9
Diamond | Level 26

What SAS are you running?  There should be a log/output somewhere, Base SAS generall has the results window and the log, I don't use EG so not sure.  When most SAS installs start up they are allocated a temporary area, thats probably a good area to start with, though check where your output is being directed, i.e. if you have an ods rtf file="..." for instance, then look in that directory.

Calcite | Level 5

I used hsted SAS EG, usually we redirect our log file into specific folder, but I've tried to delete all log files and run again, it still failed.
The code related to proc report as below:


proc report data=TFL.xxxxx missing nowd headline spacing=1 split='~' formchar(2)="__" 

     style(report)={just=left outputwidth=100%}

     style(header)=[asis=on just=left];  

    column ("&span" trtarm  pagenum  siteid c1 subjid c2 c3 c4 astdt aendt c5 c6 c7 c8 c9 c10 c11 c12 c13);

      define trtarm/ order noprint;

      define  pagenum  / order noprint order= internal;

      define siteid/order noprint order=data;

        define c1    / display   left "Site" flow  order=data group

           style(column)={cellwidth=0.12 in just=  left  asis=on};  

      define subjid/order noprint order=data;

      define C2   / display    left "Subject~ID" flow  order=data group

           style(column)={cellwidth=0.1 in just=  left  asis=on};  


      define astdt/order noprint order=data;

      define aendt/order noprint order=data;


break after  pagenum  / page;


                compute before  pagenum  ;

                line @1 "Treatment group = "   trtarm $35. ;



compute after _page_/left;                                                                                                                                                                                                                   

    line @1 "&&f_t13&num._1.";                                                                                                           

     line @1 "&&f_t13&num._2."; 

   line @1 "&&f_t13&num._3."; 




      where trtarm in ("ABC","DEF"); 






SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.

Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!

Submit your idea!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg



Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 3 in conversation