no mode median calculated by proc means

csetzkorn — Tue, 10 Oct 2017 15:01:17 GMT

I am using this:

proc means
	data=TestIn mean mode median min max n stddev;
      var X Y;
	output out=TestOut;
run;

I know that the mode and median is 'calculable'. Unfortunately, TestOut does not contain the median nor mode. Any ideas?

Re: no mode median calculated by proc means

Reeza — Tue, 10 Oct 2017 15:09:35 GMT

If you want the statistics in the OUTPUT data set you need to list them in the OUTPUT statement. The variables listed in the PROC MEANS control what's displayed, not what's saved to a data set.

Or you can switch to using the ODS table.

proc means data=sashelp.cars mean mode median min max n std stackODS;
	var mpg:;
	output out=want mean= mode= median= min= max= n= std= /autoname;
	ods table summary=want_better;
run;

topic Re: no mode median calculated by proc means in SAS Programming

no mode median calculated by proc means

Re: no mode median calculated by proc means