topic Re: Suppress result table of proc means, keeping the output for futher use in SAS Programming

Suppress result table of proc means, keeping the output for futher use

Astana — Thu, 10 Oct 2019 14:47:03 GMT

Dear SAS experts,

I am using the following code:

proc means data=have MEAN T;
ods output summary=summary1;

Later on I use the result: summary1 as an input in another function.

But at the same time I don't want the result table of the proc means operation itself be presented in my output file.

If I use noprint along with the proc means, then SAS doesn't see my summary1 anymore and I can not work with it later on.

What would be you kind advice?

Re: Suppress result table of proc means, keeping the output for futher use

PaigeMiller — Thu, 10 Oct 2019 14:56:55 GMT

Use PROC SUMMARY instead of PROC MEANS

Re: Suppress result table of proc means, keeping the output for futher use

Reeza — Thu, 10 Oct 2019 15:07:02 GMT

ods select none;

<proc means code>;


ods select all;

ODS SELECT/EXCLUDE can be used to suppress the output.

https://blogs.sas.com/content/iml/2015/05/26/suppress-ods.html

Re: Suppress result table of proc means, keeping the output for futher use

ballardw — Thu, 10 Oct 2019 15:08:45 GMT

ODS OUTPUT reformats tables sent to the ODS processor into data sets (crude summary). If you do not create any output to and ODS destination then ODS Output has nothing to work with.

With Proc Means you could use the basic output statement which would require listing the statistics requested on the OUTPUT statement and something to rename the output variables such as the Autoname option. But the variables will likely have different names than were created by the ODS OUTPUT and

proc means data=have MEAN T noprint;
   output out=summary1 mean= t= /autoname;
run;

though I prefer to use Proc Summary as the output data sets have different structures with defaults.

Re: Suppress result table of proc means, keeping the output for futher use

Reeza — Thu, 10 Oct 2019 15:15:10 GMT

@ballardw the STACKODS option in PROC MEANS gets you pretty close to the ODS OUTPUT option with OUT statement.

@ballardw wrote:

ODS OUTPUT reformats tables sent to the ODS processor into data sets (crude summary). If you do not create any output to and ODS destination then ODS Output has nothing to work with.

With Proc Means you could use the basic output statement which would require listing the statistics requested on the OUTPUT statement and something to rename the output variables such as the Autoname option. But the variables will likely have different names than were created by the ODS OUTPUT and
proc means data=have MEAN T noprint;
   output out=summary1 mean= t= /autoname;
run;
though I prefer to use Proc Summary as the output data sets have different structures with defaults.

Re: Suppress result table of proc means, keeping the output for futher use

Astana — Thu, 10 Oct 2019 17:21:22 GMT

If I use this option SAS still tells me that summary2 doesn't exist with an Error message. And Procedure Means is still printed.

ods select none;
        proc means data=have MEAN T ;
        ods output summary=summary2;

ods select all;
    

NOTE: There were 234 observations read from the data set 
NOTE: The PROCEDURE MEANS printed page 1.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.02 seconds
      cpu time            0.02 seconds
      

       data want;
        set summary2;
ERROR: File WORK.SUMMARY2.DATA does not exist.

Re: Suppress result table of proc means, keeping the output for futher use

Tom — Thu, 10 Oct 2019 17:31:33 GMT

I would make sure to place the global statements outside of the proc statements.

Works for me.

ods select none;
ods output summary=summary2;
proc means data=sashelp.class MEAN T ;
 var height weight;
run;
ods select all;
proc print data=summary2;
run;