SAS Software for Learning Community

Welcome to the exclusive online community for all SAS learners.
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).

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

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
  • 1552 views
  • 6 likes
  • 3 in conversation