frequencies and average in the same graph

[nancya]

Hi

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,

[Reeza]

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&doc...

[nancya]

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

[Reeza]

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?

---

[PeterClemmensen]

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