Discussion:
SASTip 131 - Putting multiple graphs & tables on an HTML page
(too old to reply)
Phil Mason
2005-05-19 15:18:59 UTC
Permalink
Raw Message
Daily Tip 131
19/05/2005 15:58:00


Putting multiple graphs & tables on an HTML page


The guys at SAS have produced a wonderful new tagset (thanks Eric!) called
the HTML Panel tagset. This will be available in SAS 9.2, but can be
downloaded and used now from this page
http://support.sas.com/rnd/base/topics/odsmarkup/htmlpanel.html, which also
describes how to use it.

The tagset lets you do pretty much anything that you can do with the normal
ODS HTML destination, except you can break your page up into rows and
columns. So you could have 2 graphs at the top, followed by a table, then
perhaps 3 columns with graphs in each, etc. Just use your imagination.

The following code gives you a bit of an idea what can be done with this
tagset. It starts with 4 columns of bar charts, over 3 rows. Then it has a
report. And finally 5 columns of pie charts over 2 rows.

Note: before you can use this tagset you need to download it and run the
proc template code in SAS to define it.


Sample Program


%let panelcolumns = 4;

%let panelborder = 4;

ods tagsets.htmlpanel file="C:\bypanel2.html" gpath='c:\'
options(doc='help');

goptions device=java xpixels=320 ypixels=240;

title1 'Product Reports' ;

footnote1 ;

proc summary data=sashelp.shoes nway ;

class region product ;

var stores sales inventory returns ;

output out=sum sum= mean= /autolabel autoname ;

run ;

proc gchart data=sum ;

by region ;

vbar product / sumvar=sales_sum pattid=midpoint discrete ;

run;

quit;

proc summary data=sashelp.shoes nway ;

class region subsidiary ;

var stores sales inventory returns ;

output out=sum sum= mean= /autolabel autoname ;

run ;

%let panelcolumns = 5;

%let panelborder = 1;

ods tagsets.htmlpanel ;

title 'Summary data' ;

proc print data=sum ;

run ;

title 'Subsidiary Reports' ;

%let panelcolumns = 5;

%let panelborder = 1;

ods tagsets.htmlpanel ;

goptions dev=java xpixels=160 ypixels=120;

proc gchart data=sum ;

by region ;

pie subsidiary / sumvar=sales_sum discrete ;

run;

quit;

ods _all_ close;


Output


See it here . http://www.woodstreet.org.uk/files/panel_demo.html

Tested under SAS 9.1.3 & Windows XP Professional


Wood Street Consultants Ltd.
***@woodstreet.org.uk

www.woodstreet.org.uk <http://www.woodstreet.org.uk/>
n***@gmail.com
2017-11-27 03:41:16 UTC
Permalink
Raw Message
Post by Phil Mason
Daily Tip 131
19/05/2005 15:58:00
Putting multiple graphs & tables on an HTML page
The guys at SAS have produced a wonderful new tagset (thanks Eric!) called
the HTML Panel tagset. This will be available in SAS 9.2, but can be
downloaded and used now from this page
http://support.sas.com/rnd/base/topics/odsmarkup/htmlpanel.html, which also
describes how to use it.
The tagset lets you do pretty much anything that you can do with the normal
ODS HTML destination, except you can break your page up into rows and
columns. So you could have 2 graphs at the top, followed by a table, then
perhaps 3 columns with graphs in each, etc. Just use your imagination.
The following code gives you a bit of an idea what can be done with this
tagset. It starts with 4 columns of bar charts, over 3 rows. Then it has a
report. And finally 5 columns of pie charts over 2 rows.
Note: before you can use this tagset you need to download it and run the
proc template code in SAS to define it.
Sample Program
%let panelcolumns = 4;
%let panelborder = 4;
ods tagsets.htmlpanel file="C:\bypanel2.html" gpath='c:\'
options(doc='help');
goptions device=java xpixels=320 ypixels=240;
title1 'Product Reports' ;
footnote1 ;
proc summary data=sashelp.shoes nway ;
class region product ;
var stores sales inventory returns ;
output out=sum sum= mean= /autolabel autoname ;
run ;
proc gchart data=sum ;
by region ;
vbar product / sumvar=sales_sum pattid=midpoint discrete ;
run;
quit;
proc summary data=sashelp.shoes nway ;
class region subsidiary ;
var stores sales inventory returns ;
output out=sum sum= mean= /autolabel autoname ;
run ;
%let panelcolumns = 5;
%let panelborder = 1;
ods tagsets.htmlpanel ;
title 'Summary data' ;
proc print data=sum ;
run ;
title 'Subsidiary Reports' ;
%let panelcolumns = 5;
%let panelborder = 1;
ods tagsets.htmlpanel ;
goptions dev=java xpixels=160 ypixels=120;
proc gchart data=sum ;
by region ;
pie subsidiary / sumvar=sales_sum discrete ;
run;
quit;
ods _all_ close;
Output
See it here . http://www.woodstreet.org.uk/files/panel_demo.html
Tested under SAS 9.1.3 & Windows XP Professional
Wood Street Consultants Ltd.
www.woodstreet.org.uk <http://www.woodstreet.org.uk/>
Daily Tip 131
19/05/2005 15:58:00
Putting multiple graphs & tables on an HTML page
The guys at SAS have produced a wonderful new tagset (thanks Eric!) called
the HTML Panel tagset. This will be available in SAS 9.2, but can be
downloaded and used now from this page
http://support.sas.com/rnd/base/topics/odsmarkup/htmlpanel.html, which also
describes how to use it.
The tagset lets you do pretty much anything that you can do with the normal
ODS HTML destination, except you can break your page up into rows and
columns. So you could have 2 graphs at the top, followed by a table, then
perhaps 3 columns with graphs in each, etc. Just use your imagination.
The following code gives you a bit of an idea what can be done with this
tagset. It starts with 4 columns of bar charts, over 3 rows. Then it has a
report. And finally 5 columns of pie charts over 2 rows.
Note: before you can use this tagset you need to download it and run the
proc template code in SAS to define it.
Sample Program
%let panelcolumns = 4;
%let panelborder = 4;
ods tagsets.htmlpanel file="C:\bypanel2.html" gpath='c:\'
options(doc='help');
goptions device=java xpixels=320 ypixels=240;
title1 'Product Reports' ;
footnote1 ;
proc summary data=sashelp.shoes nway ;
class region product ;
var stores sales inventory returns ;
output out=sum sum= mean= /autolabel autoname ;
run ;
proc gchart data=sum ;
by region ;
vbar product / sumvar=sales_sum pattid=midpoint discrete ;
run;
quit;
proc summary data=sashelp.shoes nway ;
class region subsidiary ;
var stores sales inventory returns ;
output out=sum sum= mean= /autolabel autoname ;
run ;
%let panelcolumns = 5;
%let panelborder = 1;
ods tagsets.htmlpanel ;
title 'Summary data' ;
proc print data=sum ;
run ;
title 'Subsidiary Reports' ;
%let panelcolumns = 5;
%let panelborder = 1;
ods tagsets.htmlpanel ;
goptions dev=java xpixels=160 ypixels=120;
proc gchart data=sum ;
by region ;
pie subsidiary / sumvar=sales_sum discrete ;
run;
quit;
ods _all_ close;
Output
See it here . http://www.woodstreet.org.uk/files/panel_demo.html
Tested under SAS 9.1.3 & Windows XP Professional
Wood Street Consultants Ltd.
www.woodstreet.org.uk <http://www.woodstreet.org.uk/>
Loading...