@hua wrote:
Yes! I got it!
BTW, Can I just have the output dataset without printing the results (the tables) on screen?
When I use "NOPRINT" option, I could not get the results, both dataset and print out tables.
Thanks for your patience!
I'm not sure of all the technicalities of when the viewable output for tables is compiled and made available to the ods system but the was SAS has implemented this feature means that if you don't display a table you get the results for many of the tables. Of course this does still beat the old way we had to do for some of the output. We used to send the output to a file and then parse the text file created for things that weren't available directly in output data sets.
Not idea but you can close all of the ODS destinations but one, sending the print output to something other than the results window and then reactive the results window.
ods _all_ close;
ods listing file="d:\junk.txt";
proc sort data=sashelp.class out=work.class;
by sex;
run;
proc corr data=work.class kendall;
var height;
with weight;
by sex;
ods output Kendallcorr= work.mywanteddata;
run;
ods listing close;
ods html;
There may be slicker ways but this doesn't send anything to the results window.
... View more