Freq Graph representation & STAT

[irinnew]

Hi Experts,

I have a long file with two columns. One of the columns is a program’s name and another one is a number of members applied. One of the analyses purposes is to estimate which program is the best. The number of members applied is one of the criteria taken into account.

I created 3 tiers (small, medium, large) in order to divide the data into meaningful groups
I created 3 levels within each tier (Small-small, medium-small, large-small; medium-small, medium-medium, medium-large; large-small, large-medium, large-large). I calculate the score :

if 1<= NUM <= 200 then score =1;

ELSE if 201 <= NUM <= 300 then score =2;

ELSE if 301<=NUM <= 400 then score =3;

After that I did a PROC FREQ:
proc freq data=evaluate;
tables score;
title "Freq of score ";
run;

Actually I have :

Score, freq, percent as the result…
------------------------------------------------------------------------

1.Now I need to represent the result graphically. I mean…one axis is Score and another is Percent/freq. My understanding is that I should create a table/dataset in order to be able to use PROC GPLOT...Am I right? How can I create a table based on PROC FREQ output?

2.I am new is SAS|STAT….

I am just wondering what other/alternative proposals can be done towards the evaluation I described at the very beginning? Is there any absolutely alternative approach?

Thank You very much in advance!

Irin

 

[klaz2002]

Why not use the 'out=yourdsname' option on the OUTPUT statement in proc freq. See sas docs (

http://v8doc.sas.com/sashtml)

for more info.
Klaz

 

[ChrisW75]

You shouldn't need to do the proc freq first. Just use the dataset with the scores in it as the input to the proc gplot. GPLOT will calculate all the stats for you.

 

[irinnew]

Thank You! This is very true!

 

[ChrisW75]

No worries, I'm a big fan of doing as little work as possible