<?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: Values needed to be printed only in MB in SAS Procedures</title>
    <link>https://communities.sas.com/t5/SAS-Procedures/Values-needed-to-be-printed-only-in-MB/m-p/167045#M43272</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Create your own format, 1024 bytes in 1kb and 1024kb is 1MB&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So your initial value divided by 1024*1024 then format either manually or via custom format.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;want=cat(put(value/(1024**2), 8.2 -l), "MB");&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 12 Nov 2014 03:26:09 GMT</pubDate>
    <dc:creator>Reeza</dc:creator>
    <dc:date>2014-11-12T03:26:09Z</dc:date>
    <item>
      <title>Values needed to be printed only in MB</title>
      <link>https://communities.sas.com/t5/SAS-Procedures/Values-needed-to-be-printed-only-in-MB/m-p/167044#M43271</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I have values in bytes which are being read and then using the MGBYTES. format or SIZEKMG. format printed now problem is there are some small values being calculated in Bytes/KB while others are large enough to make GB however requirement is irrespective of Bytes/KB&amp;nbsp; or GB have them printed only in the "MB" format...so for example below ...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="1" cellpadding="7" cellspacing="1" class="table" frame="box" jive-data-cell="{&amp;quot;color&amp;quot;:&amp;quot;#575757&amp;quot;,&amp;quot;textAlign&amp;quot;:&amp;quot;left&amp;quot;,&amp;quot;padding&amp;quot;:&amp;quot;NaN&amp;quot;,&amp;quot;backgroundColor&amp;quot;:&amp;quot;transparent&amp;quot;,&amp;quot;fontFamily&amp;quot;:&amp;quot;arial,helvetica,sans-serif&amp;quot;}" jive-data-header="{&amp;quot;color&amp;quot;:&amp;quot;#FFFFFF&amp;quot;,&amp;quot;backgroundColor&amp;quot;:&amp;quot;#6690BC&amp;quot;,&amp;quot;textAlign&amp;quot;:&amp;quot;center&amp;quot;,&amp;quot;padding&amp;quot;:&amp;quot;2&amp;quot;}" rules="groups" summary="Procedure Report: Detailed and/or summarized report"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD class="r data"&gt;1316M&lt;/TD&gt;&lt;TD class="r data"&gt;1&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="c data"&gt; &lt;/TD&gt;&lt;TD class="r data"&gt;0:00&lt;/TD&gt;&lt;TD class="l data"&gt;&lt;/TD&gt;&lt;TD class="l data"&gt;&lt;/TD&gt;&lt;TD class="l data"&gt;&lt;/TD&gt;&lt;TD class="r data" title="'There Is No Restriction for the Maximum Throughput'"&gt;No Limit&lt;/TD&gt;&lt;TD class="r data"&gt;296K&lt;/TD&gt;&lt;TD class="r data"&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="c data"&gt; &lt;/TD&gt;&lt;TD class="r data"&gt;0:30&lt;/TD&gt;&lt;TD class="l data"&gt;????????&lt;/TD&gt;&lt;TD class="l data"&gt;&lt;/TD&gt;&lt;TD class="l data"&gt;&lt;/TD&gt;&lt;TD class="r data"&gt;3200M&lt;/TD&gt;&lt;TD class="r data"&gt;27G&lt;/TD&gt;&lt;TD class="r data"&gt;31&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="c data"&gt; &lt;/TD&gt;&lt;TD class="r data"&gt;0:45&lt;/TD&gt;&lt;TD class="l data"&gt;&lt;/TD&gt;&lt;TD class="l data"&gt;&lt;/TD&gt;&lt;TD class="l data"&gt;&lt;/TD&gt;&lt;TD class="r data" title="'There Is No Restriction for the Maximum Throughput'"&gt;No Limit&lt;/TD&gt;&lt;TD class="r data"&gt;1129M&lt;/TD&gt;&lt;TD class="r data"&gt;1&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="c data"&gt; &lt;/TD&gt;&lt;TD class="r data"&gt;0:45&lt;/TD&gt;&lt;TD class="l data"&gt;&lt;/TD&gt;&lt;TD class="l data"&gt;bbbbbbb&lt;/TD&gt;&lt;TD class="l data"&gt;&amp;nbsp; ffsfgsdfg&lt;/TD&gt;&lt;TD class="r data"&gt;300M&lt;/TD&gt;&lt;TD class="r data"&gt;30G&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Anybody got idea how do i make sure these all only printed in MB so for example 0:00 value 296K should be printed as 0.28MB while 27GB should be printed as 27567MB ...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;These all values are initially in bytes... &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 12 Nov 2014 03:08:01 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Procedures/Values-needed-to-be-printed-only-in-MB/m-p/167044#M43271</guid>
      <dc:creator>rkumar23</dc:creator>
      <dc:date>2014-11-12T03:08:01Z</dc:date>
    </item>
    <item>
      <title>Re: Values needed to be printed only in MB</title>
      <link>https://communities.sas.com/t5/SAS-Procedures/Values-needed-to-be-printed-only-in-MB/m-p/167045#M43272</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Create your own format, 1024 bytes in 1kb and 1024kb is 1MB&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So your initial value divided by 1024*1024 then format either manually or via custom format.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;want=cat(put(value/(1024**2), 8.2 -l), "MB");&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 12 Nov 2014 03:26:09 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Procedures/Values-needed-to-be-printed-only-in-MB/m-p/167045#M43272</guid>
      <dc:creator>Reeza</dc:creator>
      <dc:date>2014-11-12T03:26:09Z</dc:date>
    </item>
  </channel>
</rss>

