<?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 how to insert custom contents in HTMLPANEL markup in ODS and Base Reporting</title>
    <link>https://communities.sas.com/t5/ODS-and-Base-Reporting/how-to-insert-custom-contents-in-HTMLPANEL-markup/m-p/75497#M8575</link>
    <description>Hi, &lt;BR /&gt;
&lt;BR /&gt;
I am using the HTMLPANEL markup and i would like to populate one of the cells with a simple put statement (not with a proc). &lt;BR /&gt;
&lt;BR /&gt;
Here is my idea : &lt;BR /&gt;
ods tagsets.htmlpanel event=row_panel(start);&lt;BR /&gt;
ods tagsets.htmlpanel event=column_panel(start);&lt;BR /&gt;
&lt;BR /&gt;
data _null_ ; &lt;BR /&gt;
	file print ; &lt;BR /&gt;
	put "&lt;IMG src="https://communities.sas.com/mygraph.gif" /&gt;" ;&lt;BR /&gt;
run; &lt;BR /&gt;
&lt;BR /&gt;
&lt;BR /&gt;
goptions xpixels=240 ypixels=240; &lt;BR /&gt;
proc gchart data=sashelp.class;&lt;BR /&gt;
    pie age / sumvar=weight;&lt;BR /&gt;
run;&lt;BR /&gt;
quit;&lt;BR /&gt;
&lt;BR /&gt;
ods tagsets.htmlpanel event=column_panel(finish);&lt;BR /&gt;
&lt;BR /&gt;
it works but the data _null_ generate an ugly formated cell ... is there a way to prevent it ?&lt;BR /&gt;
&lt;BR /&gt;
BR,&lt;BR /&gt;
&lt;BR /&gt;
Greg</description>
    <pubDate>Wed, 25 Feb 2009 16:19:18 GMT</pubDate>
    <dc:creator>deleted_user</dc:creator>
    <dc:date>2009-02-25T16:19:18Z</dc:date>
    <item>
      <title>how to insert custom contents in HTMLPANEL markup</title>
      <link>https://communities.sas.com/t5/ODS-and-Base-Reporting/how-to-insert-custom-contents-in-HTMLPANEL-markup/m-p/75497#M8575</link>
      <description>Hi, &lt;BR /&gt;
&lt;BR /&gt;
I am using the HTMLPANEL markup and i would like to populate one of the cells with a simple put statement (not with a proc). &lt;BR /&gt;
&lt;BR /&gt;
Here is my idea : &lt;BR /&gt;
ods tagsets.htmlpanel event=row_panel(start);&lt;BR /&gt;
ods tagsets.htmlpanel event=column_panel(start);&lt;BR /&gt;
&lt;BR /&gt;
data _null_ ; &lt;BR /&gt;
	file print ; &lt;BR /&gt;
	put "&lt;IMG src="https://communities.sas.com/mygraph.gif" /&gt;" ;&lt;BR /&gt;
run; &lt;BR /&gt;
&lt;BR /&gt;
&lt;BR /&gt;
goptions xpixels=240 ypixels=240; &lt;BR /&gt;
proc gchart data=sashelp.class;&lt;BR /&gt;
    pie age / sumvar=weight;&lt;BR /&gt;
run;&lt;BR /&gt;
quit;&lt;BR /&gt;
&lt;BR /&gt;
ods tagsets.htmlpanel event=column_panel(finish);&lt;BR /&gt;
&lt;BR /&gt;
it works but the data _null_ generate an ugly formated cell ... is there a way to prevent it ?&lt;BR /&gt;
&lt;BR /&gt;
BR,&lt;BR /&gt;
&lt;BR /&gt;
Greg</description>
      <pubDate>Wed, 25 Feb 2009 16:19:18 GMT</pubDate>
      <guid>https://communities.sas.com/t5/ODS-and-Base-Reporting/how-to-insert-custom-contents-in-HTMLPANEL-markup/m-p/75497#M8575</guid>
      <dc:creator>deleted_user</dc:creator>
      <dc:date>2009-02-25T16:19:18Z</dc:date>
    </item>
    <item>
      <title>Re: how to insert custom contents in HTMLPANEL markup</title>
      <link>https://communities.sas.com/t5/ODS-and-Base-Reporting/how-to-insert-custom-contents-in-HTMLPANEL-markup/m-p/75498#M8576</link>
      <description>The contents of the PUT statement appear as an icon in the post.  Were you trying to put string data into the cell?&lt;BR /&gt;
&lt;BR /&gt;
Thanks!&lt;BR /&gt;
DanH</description>
      <pubDate>Thu, 26 Feb 2009 15:12:40 GMT</pubDate>
      <guid>https://communities.sas.com/t5/ODS-and-Base-Reporting/how-to-insert-custom-contents-in-HTMLPANEL-markup/m-p/75498#M8576</guid>
      <dc:creator>DanH_sas</dc:creator>
      <dc:date>2009-02-26T15:12:40Z</dc:date>
    </item>
    <item>
      <title>Re: how to insert custom contents in HTMLPANEL markup</title>
      <link>https://communities.sas.com/t5/ODS-and-Base-Reporting/how-to-insert-custom-contents-in-HTMLPANEL-markup/m-p/75499#M8577</link>
      <description>Hi:&lt;BR /&gt;
  Do you want to just write text with your PUT statement. There are 2 different ways to write text so that it doesn't look "ugly" -- what you're seeing is the "batch" form of output when you use the "older" FILE PRINT insstead of the "newer" FILE PRINT ODS. The two methods are:&lt;BR /&gt;
-- use FILE PRINT ODS (which puts the text into a table)&lt;BR /&gt;
-- create a SAS dataset with your TEXT and then use PROC REPORT or PROC PRINT and turn off the interior table lines with STYLE overrides&lt;BR /&gt;
 &lt;BR /&gt;
  There is a third method, but it involves using the experimental interface between the Data Step and ODS and is described here:&lt;BR /&gt;
&lt;A href="http://www2.sas.com/proceedings/sugi28/022-28.pdf" target="_blank"&gt;http://www2.sas.com/proceedings/sugi28/022-28.pdf&lt;/A&gt;&lt;BR /&gt;
&lt;A href="http://support.sas.com/rnd/base/datastep/dsobject/" target="_blank"&gt;http://support.sas.com/rnd/base/datastep/dsobject/&lt;/A&gt;&lt;BR /&gt;
&lt;BR /&gt;
  At any rate, the program below illustrates the first two methods with HTMLPANEL.&lt;BR /&gt;
           &lt;BR /&gt;
cynthia&lt;BR /&gt;
[pre]&lt;BR /&gt;
ODS tagsets.htmlpanel nogtitle style=sasweb &lt;BR /&gt;
    path='c:\temp\' (url=none)&lt;BR /&gt;
    body="Jabberwocky.html" &lt;BR /&gt;
      options( panelcolumns='2' doc='help'&lt;BR /&gt;
               panelborder='2'&lt;BR /&gt;
               panelrows='2'&lt;BR /&gt;
               embedded_titles='Yes'&lt;BR /&gt;
               bylabels='no');&lt;BR /&gt;
                          &lt;BR /&gt;
   ods escapechar='^';&lt;BR /&gt;
                  &lt;BR /&gt;
   ODS tagsets.htmlpanel event=row_panel(start);&lt;BR /&gt;
           &lt;BR /&gt;
goptions device=actximg;&lt;BR /&gt;
&lt;BR /&gt;
proc gchart data=sashelp.shoes;&lt;BR /&gt;
where region in ('Asia', 'Canada', 'Pacific');&lt;BR /&gt;
  title 'Casual Shoes';&lt;BR /&gt;
  where also product contains 'Casual';&lt;BR /&gt;
  vbar region / sumvar=sales type=mean name='csl';&lt;BR /&gt;
run;&lt;BR /&gt;
quit;&lt;BR /&gt;
run;&lt;BR /&gt;
                  &lt;BR /&gt;
title 'Comment';&lt;BR /&gt;
data _null_;&lt;BR /&gt;
  length Jabberwocky $1000;&lt;BR /&gt;
  file print ods;&lt;BR /&gt;
  Jabberwocky = 'Twas brillig and the slithy toves';&lt;BR /&gt;
  put _ods_;&lt;BR /&gt;
  Jabberwocky = 'Did gyre and gimble in the wabe';&lt;BR /&gt;
  put _ods_;&lt;BR /&gt;
  Jabberwocky = 'All mimsy were the borogroves';&lt;BR /&gt;
  put _ods_;&lt;BR /&gt;
  Jabberwocky = 'And the mome raths outgrabe';&lt;BR /&gt;
  put _ods_;&lt;BR /&gt;
  Jabberwocky = '--- by Lewis Carroll';&lt;BR /&gt;
  put _ods_;&lt;BR /&gt;
run;&lt;BR /&gt;
                   &lt;BR /&gt;
   ODS tagsets.htmlpanel event=row_panel(finish);&lt;BR /&gt;
             &lt;BR /&gt;
   ODS tagsets.htmlpanel event=row_panel(start);&lt;BR /&gt;
&lt;BR /&gt;
                   &lt;BR /&gt;
proc gchart data=sashelp.shoes;&lt;BR /&gt;
where region in ('Asia', 'Canada', 'Pacific');&lt;BR /&gt;
  title 'Shoes for Women';&lt;BR /&gt;
  where also product contains 'Women';&lt;BR /&gt;
  vbar region / sumvar=sales type=mean name='fem';&lt;BR /&gt;
run;&lt;BR /&gt;
quit;&lt;BR /&gt;
run;&lt;BR /&gt;
&lt;BR /&gt;
                         &lt;BR /&gt;
data Jabber;&lt;BR /&gt;
  length Jabberwocky $1000;&lt;BR /&gt;
  Jabberwocky = 'Twas brillig and the slithy toves';&lt;BR /&gt;
  lineord = 1; output;&lt;BR /&gt;
  Jabberwocky = 'Did gyre and gimble in the wabe';&lt;BR /&gt;
  lineord = 2; output;&lt;BR /&gt;
  Jabberwocky = 'All mimsy were the borogroves';&lt;BR /&gt;
  lineord = 3; output;&lt;BR /&gt;
  Jabberwocky = 'And the mome raths outgrabe';&lt;BR /&gt;
  lineord = 4; output;&lt;BR /&gt;
  Jabberwocky = '--- by Lewis Carroll';&lt;BR /&gt;
  lineord = 5; output;&lt;BR /&gt;
  Jabberwocky = ' ';&lt;BR /&gt;
  lineord = 6; output;&lt;BR /&gt;
  Jabberwocky = 'Really, the most sensible ^n shoes for people ^n are shoes with '||&lt;BR /&gt;
                'very good ^n arch support ^n and sturdy heels. More stuff. More stuff. '||&lt;BR /&gt;
                'more and more and more. Twinkle twinkle little star. Supercalifragilisticexpealidocious '||&lt;BR /&gt;
                'is a favorite word of my favorite nanny.';&lt;BR /&gt;
  lineord=7; output; &lt;BR /&gt;
run;&lt;BR /&gt;
              &lt;BR /&gt;
proc report data=Jabber nowd noheader&lt;BR /&gt;
  style(report)={rules=none frame=void cellspacing=0 cellpadding=0};&lt;BR /&gt;
  title 'Jabberwocky';&lt;BR /&gt;
  column lineord Jabberwocky;&lt;BR /&gt;
  define lineord / order noprint;&lt;BR /&gt;
  define Jabberwocky / style(column)={just=left font_weight=bold} ;&lt;BR /&gt;
run;&lt;BR /&gt;
         &lt;BR /&gt;
   ODS tagsets.htmlpanel event=row_panel(finish);&lt;BR /&gt;
           &lt;BR /&gt;
ODS tagsets.htmlpanel close;&lt;BR /&gt;
&lt;BR /&gt;
[/pre]</description>
      <pubDate>Fri, 27 Feb 2009 17:35:44 GMT</pubDate>
      <guid>https://communities.sas.com/t5/ODS-and-Base-Reporting/how-to-insert-custom-contents-in-HTMLPANEL-markup/m-p/75499#M8577</guid>
      <dc:creator>Cynthia_sas</dc:creator>
      <dc:date>2009-02-27T17:35:44Z</dc:date>
    </item>
  </channel>
</rss>

