The SAS Output Delivery System and reporting techniques

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

Reply
N/A
Posts: 0

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

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
SAS Super FREQ
Posts: 8,866

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

Posted in reply to deleted_user
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
Ask a Question
Discussion stats
  • 1 reply
  • 332 views
  • 0 likes
  • 2 in conversation