BookmarkSubscribeRSS Feed
Nikita9
Calcite | Level 5
I am writing to inquire on how to generate descriptive statistics summary in SAS Explore and Visualize, for SAS Viya for Learners 4 version. Statistics summary such as mean, media, variance, standard deviation, quartiles for all qualitative data in a chosen database
2 REPLIES 2
Vj_Govindarajan
SAS Employee

I don't know if what you are asking is possible in Explore and Visualize but here is how I do it in SAS Studio (Develop Code and Flows) quite easily.

 

Example: I have a CAS table called hmeq in the CASlib called public. The code below creates all the stats for numeric columns.

 

proc mdsummary data=public.hmeq;
    output out=casuser.hmeq_summ;
run;

 

Output:

Vj_Govindarajan_0-1740159487816.png

Hope this helps.

Vj

tom_grant
SAS Super FREQ

You can also go to Discover Information Assets (Information Catalog) - search for your data table & run the analysis (if it has not already been run).  After the analysis has completed, go to the Column Analysis tab - you get all the summary statistics (& a lot more).

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 2 replies
  • 1883 views
  • 6 likes
  • 3 in conversation