topic proc means output dataset missing nmiss result in SAS Programming

proc means output dataset missing nmiss result

newboy1218 — Wed, 16 Oct 2019 19:13:20 GMT

Hi, I am trying to use proc means to see what is the missing rate for some variables in my dataset. I used the following code to generate an output dataset. However, I did not see "nmiss" column in my output. I somehow saw it when I opt-out the "noprint" option, and saw it in my output page. Does anyone know how I can make it appears in my output dataset too?

proc means data = infile n mean nmiss min max std nway; 
	class month;
	var a b c d; 
	output out = outfile;
run;

Re: proc means output dataset missing nmiss result

noling — Wed, 16 Oct 2019 19:17:58 GMT

https://communities.sas.com/t5/General-SAS-Programming/Proc-means-output-out-statements/td-p/115741

Specify the statistics that you want in the output statement.

proc means data=yourinputdata youroptions ;
your class statement ;
your var statement ;
OUTPUT OUT=youroutputdataset NMISS= N= MEAN= MIN= MAX=;
run;

Re: proc means output dataset missing nmiss result

novinosrin — Wed, 16 Oct 2019 19:20:39 GMT

Try ODS Output

Example:

ods output summary=_stat_;
proc means data = sashelp.class n mean nmiss min max std nway; 
	class sex;
	var _numeric_; 
run;

Re: proc means output dataset missing nmiss result

novinosrin — Wed, 16 Oct 2019 19:26:38 GMT

And @newboy1218 For your example, you could use

ods output summary=outfile;
proc means data = infile n mean nmiss min max std nway stackodsoutput; 
	class month;
	var a b c d; 
run;

Re: proc means output dataset missing nmiss result

newboy1218 — Wed, 16 Oct 2019 19:32:46 GMT

Thank you it works!