topic Re: Proc gchart and the data behind the graph..Please help Thank you in Statistical Procedures

Proc gchart and the data behind the graph..Please help Thank you

Kanyange — Wed, 12 Mar 2014 10:07:16 GMT

Hi,

I would like to copy the data behind the graph (the graph was generated by proc gchart). I can see the data, but I would like

To copy the data and it doesn’t seem that there is a copy option . Please see Pdf attached.

Many Thanks

proc gchart

data=EMWS19.Ids_DATA gout=WORK.PlotGRAPH IMAGEMAP=report;

title "score";

vbar score /

name = "score" description = "score"

FREQ

type=FREQ

noframe

missing

raxis=axis1 maxis=axis2;

run;

quit;

title;

goptions display;

Re: Proc gchart and the data behind the graph..Please help Thank you

RW9 — Wed, 12 Mar 2014 10:21:36 GMT

Hi,

Not sure what software that was for the PDF, however you must have the raw data there as

EMWS19.Ids_DATA

Can you not just run a proc freq on that?

Re: Proc gchart and the data behind the graph..Please help Thank you

Kanyange — Wed, 12 Mar 2014 10:29:54 GMT

The proc freq won't show me how the graph is been built, basically I want to see for each bar what's the frequency (in a table), you can double clik on the graph and see the data that has helped to create the graph but I can't copy it...basiccaly, the data will be smaller, the number of rows will be equal to the number of bars (for example 50 bars) and ecah bar will have a frequency (Volume) ...Hope I make sense...Thank you

Re: Proc gchart and the data behind the graph..Please help Thank you

RW9 — Wed, 12 Mar 2014 10:55:05 GMT

What software are you using for the graph?

proc sql;

create table want as

select distinct

SCORE,

COUNT(1) as FREQ

from EMWS19.Ids_DATA

group by SCORE;

quit;

Should be all you need to get frequency per score.

Re: Proc gchart and the data behind the graph..Please help Thank you

Kanyange — Wed, 12 Mar 2014 11:08:21 GMT

That's not what I want...I am using SAS and have run the code below...the graph is giving me a histogramm but the data used behind this histogramm
has been binned ...so I want to see how SAS has binned it..Proc freq and the slq won't give me the data behind the histogramm!! Could you please run this code, you will get a graph, and if you copy in excel and double click there is a data options, the data can be edited but you can't copy it!

proc gchart

data=EMWS19.Ids_DATA gout=WORK.PlotGRAPH IMAGEMAP=report;

title "score";

vbar score /

name = "score" description = "score"

FREQ

type=FREQ

noframe

missing

raxis=axis1 maxis=axis2;

run;

quit;

title;

goptions display

Re: Proc gchart and the data behind the graph..Please help Thank you

KenDodds — Wed, 12 Mar 2014 21:08:07 GMT

You could look at the HISTOGRAM statement in PROC UNIVARIATE. Using the OUTHISTOGRAM= generates a dataset with the midpoints, counts and percentages. I would think that SAS uses the same algorithm for histogram construction here as in GCHART, but a quick look at the help doesn't give any details (you can find a reference for the old way of doing it, still available with MIDPOINTS=OLD).

Re: Proc gchart and the data behind the graph..Please help Thank you

Reeza — Thu, 13 Mar 2014 02:57:57 GMT

Repost this in the SAS Graphics section rather than Statistical. Then one of the SAS Graphing experts will be able to help.

If you're open to using the SG Procedures (GCHART is outdated) then I believe there's a way to get the data behind the graph.

Proc Freq or Proc Univariate should work as well