BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
GreggB
Pyrite | Level 9

I have about 20,000 records.  SAS 9.4  listing output seems to be creating an index for each TNumber and it takes forever to clear the output window.  This was not the case in 9.2. Is there a way to quickly clear the output window?

 

proc sort data=one;

by tnumber;

run;

proc print data=one;

by tnumber;

run;

1 ACCEPTED SOLUTION

Accepted Solutions
FreelanceReinh
Jade | Level 19

@GreggB: Thanks for pointing this out. I've just replicated the issue. It really takes very long, regardless of which method I use to clear the output window (Ctrl-N, Ctrl-E, menu, line command, button, via Results). The large number of BY groups causes the issue, not just the number of observations.

 

I was about to recommend PROC PRINTTO as a workaround, when I discovered the following trick:

  1. Close the Output window
  2. Delete the entry corresponding to the long output in the Results window
  3. Re-open the Output window (possibly the long output will still be there, strangely enough)
  4. Clear the Output window by any of the standard methods mentioned above

Does this work for you?

 

@PGStats: Thanks for mentioning Ctrl-N. I only knew Ctrl-E (from the good old KEYS window).

View solution in original post

4 REPLIES 4
PGStats
Opal | Level 21

Why would you want to write 20 000 records to the Output window? When I happen to send something to the Outout window by error, I use Ctrl-N to clear the window. 

PG
Reeza
Super User
Are you using HTML in 9.4 vs using Listing in 9.2?
You can change the settings in your options to implement a change permanently or use the code below to change for a specific project. You could also limit the listing to a specific amount using OBS=.
ODS HTML CLOSE;
ODS LISTING;
proc print data=one (OBS=100);
by tnumber;
run;
FreelanceReinh
Jade | Level 19

@GreggB: Thanks for pointing this out. I've just replicated the issue. It really takes very long, regardless of which method I use to clear the output window (Ctrl-N, Ctrl-E, menu, line command, button, via Results). The large number of BY groups causes the issue, not just the number of observations.

 

I was about to recommend PROC PRINTTO as a workaround, when I discovered the following trick:

  1. Close the Output window
  2. Delete the entry corresponding to the long output in the Results window
  3. Re-open the Output window (possibly the long output will still be there, strangely enough)
  4. Clear the Output window by any of the standard methods mentioned above

Does this work for you?

 

@PGStats: Thanks for mentioning Ctrl-N. I only knew Ctrl-E (from the good old KEYS window).

GreggB
Pyrite | Level 9
Thanks!

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

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

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1958 views
  • 0 likes
  • 4 in conversation