<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: How to put a table and picture side by side in excel in ODS and Base Reporting</title>
    <link>https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-put-a-table-and-picture-side-by-side-in-excel/m-p/20132#M3743</link>
    <description>Hi:&lt;BR /&gt;
  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:&lt;BR /&gt;
[pre]&lt;BR /&gt;
Method           Support Graph Inclusion&lt;BR /&gt;
PROC IMPORT         NO&lt;BR /&gt;
SAS Excel Libname   NO&lt;BR /&gt;
ODS CSV             NO&lt;BR /&gt;
ODS HTML            YES *&lt;BR /&gt;
ODS HTMLPANEL       YES *&lt;BR /&gt;
ODS MSOFFICE2K      YES *&lt;BR /&gt;
ODS TAGSETS.EXCELXP NO&lt;BR /&gt;
 &lt;BR /&gt;
* You may find that Excel does not position the image as you want and you need to manually adjust the image position.&lt;BR /&gt;
[/pre]&lt;BR /&gt;
 &lt;BR /&gt;
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.&lt;BR /&gt;
 &lt;BR /&gt;
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.&lt;BR /&gt;
&lt;BR /&gt;
cynthia</description>
    <pubDate>Wed, 12 May 2010 14:28:34 GMT</pubDate>
    <dc:creator>Cynthia_sas</dc:creator>
    <dc:date>2010-05-12T14:28:34Z</dc:date>
    <item>
      <title>How to put a table and picture side by side in excel</title>
      <link>https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-put-a-table-and-picture-side-by-side-in-excel/m-p/20131#M3742</link>
      <description>Hi,&lt;BR /&gt;
&lt;BR /&gt;
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.&lt;BR /&gt;
&lt;BR /&gt;
Regards&lt;BR /&gt;
Sam</description>
      <pubDate>Wed, 12 May 2010 05:49:41 GMT</pubDate>
      <guid>https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-put-a-table-and-picture-side-by-side-in-excel/m-p/20131#M3742</guid>
      <dc:creator>deleted_user</dc:creator>
      <dc:date>2010-05-12T05:49:41Z</dc:date>
    </item>
    <item>
      <title>Re: How to put a table and picture side by side in excel</title>
      <link>https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-put-a-table-and-picture-side-by-side-in-excel/m-p/20132#M3743</link>
      <description>Hi:&lt;BR /&gt;
  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:&lt;BR /&gt;
[pre]&lt;BR /&gt;
Method           Support Graph Inclusion&lt;BR /&gt;
PROC IMPORT         NO&lt;BR /&gt;
SAS Excel Libname   NO&lt;BR /&gt;
ODS CSV             NO&lt;BR /&gt;
ODS HTML            YES *&lt;BR /&gt;
ODS HTMLPANEL       YES *&lt;BR /&gt;
ODS MSOFFICE2K      YES *&lt;BR /&gt;
ODS TAGSETS.EXCELXP NO&lt;BR /&gt;
 &lt;BR /&gt;
* You may find that Excel does not position the image as you want and you need to manually adjust the image position.&lt;BR /&gt;
[/pre]&lt;BR /&gt;
 &lt;BR /&gt;
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.&lt;BR /&gt;
 &lt;BR /&gt;
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.&lt;BR /&gt;
&lt;BR /&gt;
cynthia</description>
      <pubDate>Wed, 12 May 2010 14:28:34 GMT</pubDate>
      <guid>https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-put-a-table-and-picture-side-by-side-in-excel/m-p/20132#M3743</guid>
      <dc:creator>Cynthia_sas</dc:creator>
      <dc:date>2010-05-12T14:28:34Z</dc:date>
    </item>
  </channel>
</rss>

