Data visualization with SAS programming

proc greplay and table?

Reply
Contributor alr
Contributor
Posts: 39

proc greplay and table?

Hi,

I’m trying to develop a Dashboard using proc greplay, SAS IntrNet z/OS version 8.2 :smileyshocked:.

The Dashboard contains 20 different graphs. I need to put some tables between the graphs. Is it possible?

A unit in my dashboard consists of a title, two graphs and a table (proc print or tabulate).

I’ve managed to generate all my graphs (using gchart) and titles (using gslide) and can just call them in my template with proc greplay but what should I do with the tables?

Is it possible to make a graph from proc print (or proc tabulate output) and then refer to this graph (which is my table) with proc greplay?

Any help is appreciated.

Super Contributor
Posts: 543

Re: proc greplay and table?

Here is a link to proc greplay and tables from proc tabulate:

http://www.nesug.org/proceedings/nesug07/ap/ap16.pdf

Very nice, it will take a bit of tweaking, but using proc printto...it is doable.

In a nutshell:

*define a filename path (open a text editor and save it as whatever;

filename whatever '&path.\whatever.txt' ;

proc printto print = whatever new;run; *tell SAS to print what is coming up in this txt file;

proc tabulate data = sashelp.class;  *silly table,for example purposes;

var age height;

class sex;

table age sex;

run;

proc printto;run;

proc gprint fileref = whatevername= 'my_table';run;

proc gplot data = sashelp.class gout = work.graphs;

    plot age*weight  / name = "age_wt";

run;quit;

proc greplay igout=work.gseg tc=sashelp.templt template=v2 nofs;

treplay 1:age_wt 2:my_table;

run;quit;

Smiley Happy

Anca.

Contributor alr
Contributor
Posts: 39

Re: proc greplay and table?

Thank you very much, I'll try Smiley Happy

SAS Employee
Posts: 963

Re: proc greplay and table?

Here's another possibility ... This one lets you create a table as an image, and then you could annotate that image onto a gslide, which would give you something you could use with greplay.

I don't have an example showing exactly that, but this example shows how to create the table image, and annotate it onto a SAS graph gplot, which should get you pointed in the right direction ...

http://robslink.com/SAS/democd56/table_image.htm

http://robslink.com/SAS/democd56/table_image_info.htm

Contributor alr
Contributor
Posts: 39

Re: proc greplay and table?

Thank you very much, I'll try Smiley Happy

Post a Question
Discussion Stats
  • 4 replies
  • 689 views
  • 0 likes
  • 3 in conversation