DATA Step, Macro, Functions and more

no mode median calculated by proc means

Reply
Regular Contributor
Posts: 201

no mode median calculated by proc means

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?

Super User
Posts: 22,844

Re: no mode median calculated by proc means

Posted in reply to csetzkorn

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;
Ask a Question
Discussion stats
  • 1 reply
  • 136 views
  • 2 likes
  • 2 in conversation