How to control size of ODS graphs output to Excel?

[EC27556]

Hi, when i run the below code (without the /width=1000px; code, the ZoomedTreePlot output HTML is too small to contain all info - sas basically misses info from the graph it cannot fit in.

By including the /width=1000px; code it increases the size of the HTML image in the results tab, however it does not do the same for graphs that are exported to Excel - namely they are missing info because they are too small.

If there any way of also increasing the size of graphs output to Excel so they do not miss information when they are exported?

ods excel file="/test.xlsx";
ods graphics on / width=1000px;
ods select ZoomedTreePlot NodeTable VarImportance;

proc hpsplit 
/*HPSplit Code*/
run;

ods excel close;

[Reeza]

ods graphics on / height=4 in width=5in;

What happens when you specify the height/width in inches? 

And what version of SAS are you using? 9.4M5?

[EC27556]

No luck with this. Using 8.3.

[Cynthia_sas]

Hi:

  SAS version 8.3 is very old. Enterprise Guide 8.3 is just an interface to SAS. My guess is that you are running SAS on a server and using EG 8.3 as the front end interface to SAS. My guess is that you are probably running on SAS 9.4, but not sure about what Maintenance release of 9.4.

  I would not specify graph sizes in Pixels. I would stick with inches or CM (depending on where you're located). But it's going to come down to the image that's produced by HPSPLIT and whether it can be sized the way you want. Also unknown is the device you're using for creating your output. Do you see any messages in the log about graphics devices being changed or messages about size?

  If you continue to have issues, I would recommend working with Tech Support. They can test using either fake data or your data on HPSPLIT and see whether they can help you come up with a solution.

Cynthia

[PaigeMiller]

It is my experience that it is hard to fit the output from PROC HPSPLIT into a window and still be able to read the text. Just the nature of this particular graphics output.