topic Re: Median Output for domain with proc surveymeans in SAS Programming

Median Output for domain with proc surveymeans

Steph_C4 — Wed, 30 Aug 2023 13:47:44 GMT

I'd like to have a sas table with the median output for domains with proc surveymeans.

If I do this for the mean it works perfect like in the exemple:

proc surveymeans data=sashelp.cars mean;

var MSRP;

domain Make;

ods output statistics=test1

domain =test2;

run;

Replacing the mean with the median i don't get any output sas tables (test1 and test2) anymore. The median results are displayed, but no sas table anymore.

I think there is another ods output command for doing that, but I can't remember it. (And haven't found it here so far)

Can someone help me out?

Cheers,

Steph

Re: Median Output for domain with proc surveymeans

ballardw — Wed, 30 Aug 2023 14:58:37 GMT

You can get a list of the output object using Ods trace. Example:(don't forget to turn off or your log gets busy)

ods trace on;
proc surveymeans data=sashelp.cars median;
  var MSRP; 
  domain Make;
run;

ods trace off;

Which shows:

Output Added:
-------------
Name:       Summary
Label:      Data Summary
Template:   Stat.SurveyMeans.Factoid
Path:       Surveymeans.Summary
-------------

Output Added:
-------------
Name:       Statistics
Label:      Statistics
Template:   Stat.SurveyMeans.Statistics
Path:       Surveymeans.Statistics
-------------

Output Added:
-------------
Name:       Quantiles
Label:      Quantiles
Template:   Stat.SurveyMeans.Quantiles
Path:       Surveymeans.Quantiles
-------------

Output Added:
-------------
Name:       DomainQuantiles
Label:      Quantiles for Make Domains
Template:   Stat.SurveyMeans.DomainQuantiles
Path:       Surveymeans.DomainAnalysis.DomainQuantiles
-------------

So it looks like you want an ODS output for Domainquantiles.

Re: Median Output for domain with proc surveymeans

Steph_C4 — Thu, 31 Aug 2023 05:55:30 GMT

Indeed, I was looking for domainquantiles! Thanks a lot for the answer and the hint.