Can tagsets.excelxp output plot?
ods listing close;
ods tagsets.excelxp file='c:\temp\aaa123.xls' ;
proc sgplot data=sashelp.class;
scatter x=height y=weight / group=sex;
run;
ods tagsets.excelxp close;
ods listing;
run;
Hello,
How to output excel table with graph with ods tagsets.excelxp? I can't get the graph.I use SAS 9.3
Thanks
ods listing close;
ods tagsets.excelxp file='c:\temp\abc66.xls' ;
ods tagsets.excelxp options(sheet_interval="none");
ods tagsets.excelxp options( embedded_titles='yes' embedded_footnotes='yes' );
title 'Where is my graph?';
style=statistical;
proc sql;
select * from sashelp.class
quit;
proc sgplot data=sashelp.class;
title 'sashelp--class';
scatter x=height y=weight / group=sex;
run;
ods tagsets.excelxp close;
ods listing;
run;
No, it cannot. You can use ODS HTML if you want graphs but that doesn't easily support multiple sheets.
PS You posted the same question twice, but they appear identical so I'm merging them into a single thread.
Here's a demo from SAS page on many of the features:
https://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html
Almost every feature of ODS TAGSETS is listed here as well as a link to the paper with the page reference to find example code. The papers at the end of this page would be the key references on learning how to use ODS TAGSETS efficiently.
https://vasug.files.wordpress.com/2011/07/excelxppaperindex.pdf
Official list of options available:
http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_help.html
Hello Reeza,
ExcelXP Tagset is good at doing arrange sheets like its name. I can use ExcelXP Tagset print outputs in one single page which other ods can't do.
But ExcelXP Tagset can't generate graph like ods msoffice2k.
ods _all_ close;
ods msoffice2k path='c:\temp' (url=none)
gpath='c:\temp' (url=none)
file='open_with_Excel8.xls'
style=seaside;
title 'A scatter plot';
proc print data=sashelp.class;
run;
title 'ODS GRAPHICS';
proc sgplot data=sashelp.class;
title 'sashelp--class';
scatter x=height y=weight / group=sex;
run;
ods msoffice2k close;
also ExcelXP Tagset can't print output start at a user defined cell(have to use ods excel,there is a new option --"start_at",but you must have SAS 9.4).
Thanks!
Thanks, I am aware of the limitations but it's good to know that SAS has addressed most of these in the latest versions. The first version of 9.3 was initially released in 2011 - in other words it's equivalent to using Office 2010. Its good, but the newer versions are better.
9.4 has been available since 2013 so a while now, especially in terms of software.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.