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.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


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