How to put a table and picture side by side in excel

[deleted_user]

Hi,

I would like to dispaly a table and 2 images generated by SAS/Graph side by side in excel. kindly suggest me a better way in doing it.

Regards
Sam

[Cynthia_sas]

Hi:
What method have you already tried??? When you create output for Excel, from SAS, your choices (and their support for inclusion of SAS/GRAPH images) are:
[pre]
Method Support Graph Inclusion
PROC IMPORT NO
SAS Excel Libname NO
ODS CSV NO
ODS HTML YES *
ODS HTMLPANEL YES *
ODS MSOFFICE2K YES *
ODS TAGSETS.EXCELXP NO

* You may find that Excel does not position the image as you want and you need to manually adjust the image position.
[/pre]

As you can see, only the HTML-based destinations support the use of SAS/GRAPH -- but when Excel opens and renders the HTML file, I sometimes see that it will overlap the top of the graph onto the bottom of the table -- in other words, Excel does not use the same placement as I would see in a browser and frequently, I have to manually adjust any image placement in the file.

Depending on what method you've already tried, you may find that the way you are getting output now is the best that you can do with HTML and Microsoft Excel files. If you have not tried HTML-based methods, then how Excel treats the SAS/GRAPH image may be OK with you.

cynthia