topic Re: frequencies and average in the same graph in Graphics Programming

frequencies and average in the same graph

nancya — Mon, 14 Jan 2019 17:12:48 GMT

I am new to using SAS and have been trying to figure out how to diplay both frequency and average in the same graph plot.

here is a sample data and what I like the graph to display

policy No Group 1 Retention Rate

1 SUV 2%

2 Truck 4%

3 Truck 4%

4 SUV 2%

5 Hatch Back 3%

Now I want a bar graph to display the no of polices in group 1 - graph will show SUV Truck Hatch Back and the frequency of polices.

And I want a line graph to show the the average retention rates in group 1. And I want both the bar and line graph in the same graph (with different axis ,ofcourse)

PS I use SAS Sybase, if that makes a difference,

Re: frequencies and average in the same graph

Reeza — Mon, 14 Jan 2019 17:15:35 GMT

Create a data set with the summarized data, then it's easy to create this using SGPLOT.
It's one of the documentation examples: https://documentation.sas.com/?docsetId=grstatproc&docsetTarget=n1mp0swy0atvzun1oeqlkrg8d89o.htm&docsetVersion=3.1&locale=en

Re: frequencies and average in the same graph

nancya — Mon, 14 Jan 2019 17:20:22 GMT

Thanks for the quick reply. can i use sg plot if I don't have ODS installed?

Re: frequencies and average in the same graph

Reeza — Mon, 14 Jan 2019 17:34:25 GMT

ODS is part of Base SAS. What makes you think you don't have that installed?

@nancya wrote:

Thanks for the quick reply. can i use sg plot if I don't have ODS installed?

Re: frequencies and average in the same graph

PeterClemmensen — Mon, 14 Jan 2019 19:15:58 GMT

Calculate the desired statistics and use VBARPARM and SERIES Statements in PROC SGPLOT. The VBAR and SERIES statements are not allowed to overlay.