Thanks for the reply and support.
We found some material on following link
http://support.sas.com/rnd/base/ods/templateFAQ/excelexamples.html#multiwork
depending on the material available we were able to achieve the required result.
Am giving the script which we had written to achieve the result.
goptions reset=global gunit=pct border cback=white
colors=(black blue green red)
ftitle=swissb ftext=swiss htitle=6 htext=4;
data jobs;
length eng $5;
input eng dollars num;
datalines;
Civil 27308 73273
Aero 29844 70192
Elec 22920 89382
Mech 32816 19601
Chem 28116 25541
Petro 18444 34833
;
proc template;
define tagset tagsets.test;
parent=tagsets.phtml;
define event doc_body;
start:
put "
put " onunload=""shutdown()""";
put " bgproperties=""Fixed""" / if exist( WATERMARK );
trigger style_inline;
put ">" NL;
put "" NL;
put NL;
finish:
put "" NL;
end;
define event image;
put "
put " src=""";
put BASENAME / if !exist( NOBASE );
put URL;
put """";
putq " border=" BORDERWIDTH;
put " usemap=""#" @CLIENTMAP;
put """" NL / if exist(BORDERWIDTH,@CLIENTMAP);
putq " class=" HTMLCLASS;
putq " id=" HTMLID;
putq "alt=""this is a test""";
PUTQ "HEIGHT=400 WIDTH=500";
put ">" NL;
end;
end;
run;
ods listing close;
ods markup body='test.xls' path='c:\test' tagset=tagsets.test;
proc print data=sashelp.class;
run;
Proc gplot data=jobs;
format dollars dollar9.;
bubble dollars*eng=num / haxis=axis1;
run;
ods markup close;
ods listing;