Thanks for your quick reply. I have now tried using the drill down graph in HTML instead of Excel. Below is my draft code. The issue is chk1.hmtl file has no graph when we open whereas study.html got generated successfully. Note that I have created the "studydrill" variable in the gdata dataset studydrill='href="xxxxxx.html"'. goptions gunit = pct xpixels = 850 ypixels = 1050 device=gif transparency noborder ; filename odsout "xyz/abc"; /* open the html destination for ODS output */ ods html body='chk1.html' path = odsout gpath="xyz/abc"; ods listing close; axis1 split = "/" ; axis2 label=("Number of " j=l " Issues"); proc gchart data=gdata; vbar _name_/sumvar = col1 subgroup = study inside = sum space = 10 width = 10 coutline=black autoref clipref raxis = axis2 maxis = axis1 html=studydrill; run; /* open a body file for report */ /* on central sales */ ods html body='study.html' path=odsout; title1 Issue Details'; proc print data=gdata noobs; var study dbl _label_ col1; run; ods excel close; /* close the html destination */ ods html close; ods graphics off; goptions reset=goptions;
... View more