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.

Sarra-Matri
Obsidian | Level 7

q1.JPG

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

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
  • 1313 views
  • 0 likes
  • 2 in conversation