Features: |
|
Data set: | TOTALS |
Sample library member: | GONDDCW1 |
goptions reset=all device=gif transparency noborder;
data totals; length Dept $ 7 Site $ 8; input Dept Site Quarter Sales; datalines; Repairs Sydney 1 5592.82 Repairs Atlanta 1 9210.21 Tools Sydney 1 1775.74 Tools Atlanta 1 2424.19 Tools Paris 1 5914.25 Parts Atlanta 2 11595.07 Parts Paris 2 9558.29 Repairs Sydney 2 5505.31 Repairs Paris 2 7538.56 Tools Atlanta 2 1903.99 Tools Paris 2 7868.34 Parts Sydney 3 8437.96 Parts Paris 3 6789.85 Tools Atlanta 3 3048.52 Tools Paris 3 9017.96 Parts Sydney 4 6065.57 Parts Atlanta 4 9388.51 Parts Paris 4 8509.08 Repairs Atlanta 4 2088.30 Repairs Paris 4 5530.37 ;
data newtotal; set totals; length sitedrill $40; if site="Atlanta" then sitedrill="HREF='report_deptsales.html#IDX1'"; else if site="Paris" then sitedrill="HREF='report_deptsales.html#IDX2'"; if site="Sydney" then sitedrill="HREF='report_deptsales.html#IDX3'"; run;
ods html body="report_body.html" nogtitle;
title1 "Total Sales for All Sites"; footnote1 j=l "click on bars" j=r "REPORT3D ";
pattern color=cyan;
axis1 order=(0 to 80000 by 20000) minor=(number=1) label=none; axis2 label=none offset=(9,9);
proc gchart data=newtotal; format sales dollar8.; vbar3d site / discrete width=15 sumvar=sales inside=sum html=sitedrill coutline=black cframe=blue maxis=axis2 raxis=axis1 name="report3d "; run; quit;
proc sort data=newtotal; by site dept quarter; run; quit;
ods html body="report_deptsales.html" ;
goptions reset=footnote;
options nobyline; title1 "Sales Report for #byval(site)";
ods listing;
proc report data=newtotal nowindows; by site; column site dept quarter sales; define site / noprint group; define dept / display group; define quarter / display group; define sales / display sum format=dollar8.; compute after site; dept="Total"; endcomp; break after site / summarize style=rowheader page; run; quit;
data totals; length Dept $ 7 Site $ 8; input Dept Site Quarter Sales; datalines; Repairs Sydney 1 5592.82 Repairs Atlanta 1 9210.21 Tools Sydney 1 1775.74 Tools Atlanta 1 2424.19 Tools Paris 1 5914.25 Parts Atlanta 2 11595.07 Parts Paris 2 9558.29 Repairs Sydney 2 5505.31 Repairs Paris 2 7538.56 Tools Atlanta 2 1903.99 Tools Paris 2 7868.34 Parts Sydney 3 8437.96 Parts Paris 3 6789.85 Tools Atlanta 3 3048.52 Tools Paris 3 9017.96 Parts Sydney 4 6065.57 Parts Atlanta 4 9388.51 Parts Paris 4 8509.08 Repairs Atlanta 4 2088.30 Repairs Paris 4 5530.37 ;
data newtotal; set totals; length sitedrill $40; if site="Atlanta" then sitedrill="HREF='report_deptsales.html#IDX1'"; else if site="Paris" then sitedrill="HREF='report_deptsales.html#IDX2'"; if site="Sydney" then sitedrill="HREF='report_deptsales.html#IDX3'"; run;
proc gchart data=newtotal; format sales dollar8.; vbar3d site / discrete width=15 sumvar=sales inside=sum html=sitedrill coutline=black cframe=blue maxis=axis2 raxis=axis1 name="report3d "; run; quit;
proc report data=newtotal nowindows; by site; column site dept quarter sales; define site / noprint group; define dept / display group; define quarter / display group; define sales / display sum format=dollar8.; compute after site; dept="Total"; endcomp; break after site / summarize style=rowheader page; run; quit;
if site="Atlanta" then sitedrill="HREF='report_deptsales.html#IDX1'";
Atlanta
.
report_deptsales.html#IDX1
.
This target consists of a filename and an anchor. The file, report_deptsales.html
,
is generated by the PROC REPORT step. IDX1
is
the anchor that identifies the section of the file that contains the
report for the first BY group, Atlanta
.
html=sitedrill
gqcke00k_map
.
The map is stored in report_body.html
. (ODS
generates unique map names each time you run the program, so the next
time this program runs, the map name will be different): <MAP NAME="gqcke00k_map"> <AREA SHAPE="POLY" HREF="report_deptsales.html#IDX3" COORDS="423,409,423,242,510,242,510,409" > <AREA SHAPE="POLY" HREF="report_deptsales.html#IDX2" COORDS="314,409,314,139,401,139,401,409" > <AREA SHAPE="POLY" HREF="report_deptsales.html#IDX1" COORDS="205,409,205,199,292,199,292,409" > </MAP>
report_body.html
:
<IMG SRC="report3d.gif" USEMAP="#gqcke00k_map">