BookmarkSubscribeRSS Feed
Sarra-Matri
Obsidian | Level 7

how can i do summary statistics (average, maximum, minimum) of values
from a specific  table.and create a graphic representation of the previous result.

4 REPLIES 4
ballardw
Super User

What kind of graph?

 

Proc summary/means will create summary statistics and create a data set that maybe can be graphed but it depends on the type of graph that you want.

 

Best would be to provide an example data set or use one of the data sets in the SASHELP library and then describe what you want.

 

The type of graph is important as that will lead to how the input data needs to be structured.

Consider that Proc SGPLOT can create 27 different types of plots, with some variations for some of those, and that most of these can be overlayed to create additional interpretations we really need to know.

Or you can look here for some examples of different graphs, the data and code to make them: https://support.sas.com/en/knowledge-base/graph-samples-gallery.html

Start by looking at SGPLOT and SGPANEL. Much more complicated graphs can be made with SGRENDER and the Graphic Template Language.

Sarra-Matri
Obsidian | Level 7
This is the table , i want to do summary statistics (mean/ min/max) of
column value then create a graph
ballardw
Super User

Nothing shows as a "table". Best is a data step to indicate the starting data.

 

And still have not described what type of graph.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 491 views
  • 0 likes
  • 2 in conversation