topic Can tagsets.excelxp output plot? in ODS and Base Reporting

Can tagsets.excelxp output plot?

GeorgeSAS — Fri, 28 Apr 2017 20:08:28 GMT

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;

SAS 9.3-windows: ods tagsets.excelxp output table and graph

GeorgeSAS — Fri, 28 Apr 2017 20:00:05 GMT

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;

Re: Can tagsets.excelxp output plot?

Reeza — Fri, 28 Apr 2017 20:29:26 GMT

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

Re: Can tagsets.excelxp output plot?

GeorgeSAS — Fri, 28 Apr 2017 21:17:50 GMT

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!

Re: Can tagsets.excelxp output plot?

Reeza — Fri, 28 Apr 2017 22:12:25 GMT

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.

Re: SAS 9.3-windows: ods tagsets.excelxp output table and graph

Cynthia_sas — Sat, 29 Apr 2017 00:20:00 GMT

Hi
By Microsoft design, Spreadsheet ML 2003 does NOT support graphic images. This form of output is what tagsets.excelxp produces. SAS and ODS cannot do what Microsoft did not put in the specification.

ODS excel produces xlsx files which are 2007 office open xml -- which does support graphic images.

Your choices are these:
1) make an html file with graphs that excel can open using ODS msoffice2k
Or
2) use ODS excel

Tagsets.excelxp will NOT have graphs....

By MICROSOFT's design.

Cynthia