BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Steph_C4
Calcite | Level 5

Hi

 

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
 
 
1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

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.

View solution in original post

2 REPLIES 2
ballardw
Super User

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.

Steph_C4
Calcite | Level 5
Indeed, I was looking for domainquantiles! Thanks a lot for the answer and the hint.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 942 views
  • 1 like
  • 2 in conversation