<?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: Generating meaningful summary attribute in HTML output in ODS and Base Reporting</title>
    <link>https://communities.sas.com/t5/ODS-and-Base-Reporting/Generating-meaningful-summary-attribute-in-HTML-output/m-p/491412#M21579</link>
    <description>&lt;P&gt;Hi:&lt;/P&gt;
&lt;P&gt;&amp;nbsp; My guess is that if you change or use the CONTENTS= option, you'll find out which one is in effect for summary=, as you show. Here's some code to try:&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;ods html path='c:\temp' file='tabnodes.html';&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;ods proclabel '1 ODS PROCLABEL stmt';&lt;/FONT&gt;&lt;/STRONG&gt;&lt;/FONT&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;proc tabulate data=sashelp.class &lt;FONT color="#0000FF"&gt;contents='2 PROC TAB Stmt'&lt;/FONT&gt;;&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;&amp;nbsp; class sex age;&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;&amp;nbsp; var height;&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;&amp;nbsp; table sex all,&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; age*height*mean/&lt;FONT color="#FF00FF"&gt;contents='3 Table Stmt'&lt;/FONT&gt;;&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;run;&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;ods html close;&lt;/FONT&gt;&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;My guess is that it is either #2 or #3.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;Cynthia&lt;/FONT&gt;&lt;/P&gt;</description>
    <pubDate>Thu, 30 Aug 2018 20:25:52 GMT</pubDate>
    <dc:creator>Cynthia_sas</dc:creator>
    <dc:date>2018-08-30T20:25:52Z</dc:date>
    <item>
      <title>Generating meaningful summary attribute in HTML output</title>
      <link>https://communities.sas.com/t5/ODS-and-Base-Reporting/Generating-meaningful-summary-attribute-in-HTML-output/m-p/491314#M21570</link>
      <description>&lt;P&gt;Please see the following code.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;ods tagsets.tableeditor file="&amp;amp;path\US&amp;amp;CYR1YY..htm"	
      options( 
               frozen_headers="yes"
               frozen_rowheaders="yes"
               banner_color_even="beige"
               banner_color_odd="white"
               header_bgcolor="teal"
			   header_fgcolor="white"
			   rowheader_bgcolor="lightblue"
			   gridline_color="gray"
			   header_size="12"  
               rowheader_size="12" 
			   data_size="11" 
              );
               
PROC TABULATE data=diswebtbldat NOSEPS MISSING FORMAT=comma9. FORMCHAR='              ';  

CLASS STATEFIP disyr sub1;
class sex age_d race ethnic / style={background=lightyellow}; 

tables all*(n f=5.1*pctn&amp;lt;sub1 all&amp;gt;) 
(sex all)*(pctn&amp;lt;sex all&amp;gt;)*f=5.1 
(age_d all)*(pctn&amp;lt;age_d all&amp;gt;)*f=5.1 
(race all)*(pctn&amp;lt;race all&amp;gt;)*f=5.1 
(ethnic all)*(pctn&amp;lt;ethnic all&amp;gt;)*f=5.1, 
all sub1 / rts=16 misstext='--' box=_page_ printmiss;
where disyr=&amp;amp;CYR1 and statefip NOT IN (&amp;amp;NOMOUNTCYR1);

keylabel all='Total' n='No.' pctn='%';
title1 height=11pt 'Substance Use Treatment Discharges by Primary Substance of Use,';
title2 height=11pt 'According to Sex, Age Group, Race, and Ethnicity among discharges aged 12 and older';
title3 height=11pt "Year = &amp;amp;CYR1,  UNITED STATES";

RUN;

ods tagsets.tableeditor close;&lt;/CODE&gt;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In my HTML output this generates a summary attribute of Procedure Tabulate: Table 1, as seen below.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;&amp;lt;table &lt;/SPAN&gt;&lt;SPAN class="html-attribute-name"&gt;id&lt;/SPAN&gt;&lt;SPAN&gt;="&lt;/SPAN&gt;&lt;SPAN class="html-attribute-value"&gt;id1&lt;/SPAN&gt;&lt;SPAN&gt;" &lt;/SPAN&gt;&lt;SPAN class="html-attribute-name"&gt;class&lt;/SPAN&gt;&lt;SPAN&gt;="&lt;/SPAN&gt;&lt;SPAN class="html-attribute-value"&gt;table&lt;/SPAN&gt;&lt;SPAN&gt;" &lt;/SPAN&gt;&lt;SPAN class="html-attribute-name"&gt;cellspacing&lt;/SPAN&gt;&lt;SPAN&gt;="&lt;/SPAN&gt;&lt;SPAN class="html-attribute-value"&gt;1&lt;/SPAN&gt;&lt;SPAN&gt;" &lt;/SPAN&gt;&lt;SPAN class="html-attribute-name"&gt;cellpadding&lt;/SPAN&gt;&lt;SPAN&gt;="&lt;/SPAN&gt;&lt;SPAN class="html-attribute-value"&gt;7&lt;/SPAN&gt;&lt;SPAN&gt;" &lt;/SPAN&gt;&lt;SPAN class="html-attribute-name"&gt;rules&lt;/SPAN&gt;&lt;SPAN&gt;="&lt;/SPAN&gt;&lt;SPAN class="html-attribute-value"&gt;groups&lt;/SPAN&gt;&lt;SPAN&gt;" &lt;/SPAN&gt;&lt;SPAN class="html-attribute-name"&gt;frame&lt;/SPAN&gt;&lt;SPAN&gt;="&lt;/SPAN&gt;&lt;SPAN class="html-attribute-value"&gt;box&lt;/SPAN&gt;&lt;SPAN&gt;" &lt;/SPAN&gt;&lt;SPAN class="html-attribute-name"&gt;summary&lt;/SPAN&gt;&lt;SPAN&gt;="&lt;/SPAN&gt;&lt;SPAN class="html-attribute-value"&gt;Procedure Tabulate: Table 1&lt;/SPAN&gt;&lt;SPAN&gt;"&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;I need to change the summary attribute to meaningfully describe the table, but I am unsure how to do this in SAS.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Thanks.&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 30 Aug 2018 15:56:03 GMT</pubDate>
      <guid>https://communities.sas.com/t5/ODS-and-Base-Reporting/Generating-meaningful-summary-attribute-in-HTML-output/m-p/491314#M21570</guid>
      <dc:creator>martyvd</dc:creator>
      <dc:date>2018-08-30T15:56:03Z</dc:date>
    </item>
    <item>
      <title>Re: Generating meaningful summary attribute in HTML output</title>
      <link>https://communities.sas.com/t5/ODS-and-Base-Reporting/Generating-meaningful-summary-attribute-in-HTML-output/m-p/491412#M21579</link>
      <description>&lt;P&gt;Hi:&lt;/P&gt;
&lt;P&gt;&amp;nbsp; My guess is that if you change or use the CONTENTS= option, you'll find out which one is in effect for summary=, as you show. Here's some code to try:&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;ods html path='c:\temp' file='tabnodes.html';&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;ods proclabel '1 ODS PROCLABEL stmt';&lt;/FONT&gt;&lt;/STRONG&gt;&lt;/FONT&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;proc tabulate data=sashelp.class &lt;FONT color="#0000FF"&gt;contents='2 PROC TAB Stmt'&lt;/FONT&gt;;&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;&amp;nbsp; class sex age;&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;&amp;nbsp; var height;&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;&amp;nbsp; table sex all,&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; age*height*mean/&lt;FONT color="#FF00FF"&gt;contents='3 Table Stmt'&lt;/FONT&gt;;&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;run;&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;ods html close;&lt;/FONT&gt;&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;My guess is that it is either #2 or #3.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;Cynthia&lt;/FONT&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 30 Aug 2018 20:25:52 GMT</pubDate>
      <guid>https://communities.sas.com/t5/ODS-and-Base-Reporting/Generating-meaningful-summary-attribute-in-HTML-output/m-p/491412#M21579</guid>
      <dc:creator>Cynthia_sas</dc:creator>
      <dc:date>2018-08-30T20:25:52Z</dc:date>
    </item>
  </channel>
</rss>

