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

[Astana]

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?

[PaigeMiller]

Use PROC SUMMARY instead of PROC MEANS

[Reeza]

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

[Astana]

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.

[Tom · Accepted solution]

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;

[ballardw]

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.

[Reeza]

@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.

---