<?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: Proc Report won't justify column data in SAS Procedures</title>
    <link>https://communities.sas.com/t5/SAS-Procedures/Proc-Report-won-t-justify-column-data/m-p/384664#M65684</link>
    <description>&lt;P&gt;Can you provide a data step that will create 5 to 10 rows of data that we test code against?&lt;/P&gt;</description>
    <pubDate>Tue, 01 Aug 2017 15:54:23 GMT</pubDate>
    <dc:creator>ballardw</dc:creator>
    <dc:date>2017-08-01T15:54:23Z</dc:date>
    <item>
      <title>Proc Report won't justify column data</title>
      <link>https://communities.sas.com/t5/SAS-Procedures/Proc-Report-won-t-justify-column-data/m-p/384465#M65652</link>
      <description>&lt;P&gt;My code (below) will not justify the data. &amp;nbsp;I have want numerical fields to be right justified and the column center justified.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;When I define right justify for certain columns, it's all left justified. &amp;nbsp;&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;options papersize=legal orientation=landscape nodate nonumber;
ods html;
proc report data=d.profapp2&amp;nbsp;
style(report)=[cellspacing=.05 borderwidth=.001 bordercolor=grey bordertopcolor=grey borderleftcolor=grey&amp;nbsp;
fontfamily=Arial fontsize=2 cellheight=.05 background=white] split='*'
;


column mvint units prinamt mnthpmtequiv pmtterm apr fico custom monthlyinc timeataddress timeonjob housepay franch new ;

define mvint / right style(column)= [just=right fontweight=bold bordertopcolor=grey borderbottomcolor=grey borderrightcolor=grey borderleftcolor=grey
fontfamily=Arial fontsize=2];&amp;nbsp;
define units / right style(column)= [width=5 bordertopcolor=grey borderbottomcolor=grey borderrightcolor=grey borderleftcolor=grey
fontfamily=Arial fontsize=2];&amp;nbsp;
define prinamt / right style(column)= [ width=12 bordertopcolor=grey borderbottomcolor=grey borderrightcolor=grey borderleftcolor=grey
fontfamily=Arial fontsize=2];&amp;nbsp;
define mnthpmtequiv / right style(column)= [width=7 bordertopcolor=grey borderbottomcolor=grey borderrightcolor=grey borderleftcolor=grey
fontfamily=Arial fontsize=2 ];&amp;nbsp;
define pmtterm / right style(column)= [width=7 bordertopcolor=grey borderbottomcolor=grey borderrightcolor=grey borderleftcolor=grey
fontfamily=Arial fontsize=2];&amp;nbsp;
define apr / right style(column)= [width=7 bordertopcolor=grey borderbottomcolor=grey borderrightcolor=grey borderleftcolor=grey
fontfamily=Arial fontsize=2];&amp;nbsp;
define fico / right style(column)= [width=7 bordertopcolor=grey borderbottomcolor=grey borderrightcolor=grey borderleftcolor=grey
fontfamily=Arial fontsize=2];&amp;nbsp;
define custom / right style(column)= [width=7 bordertopcolor=grey borderbottomcolor=grey borderrightcolor=grey borderleftcolor=grey
fontfamily=Arial fontsize=2];&amp;nbsp;
define monthlyinc/ right style(column)= [ width=7 bordertopcolor=grey borderbottomcolor=grey borderrightcolor=grey borderleftcolor=grey
fontfamily=Arial fontsize=2];&amp;nbsp;
define timeataddress/ right style(column)= [width=7 bordertopcolor=grey borderbottomcolor=grey borderrightcolor=grey borderleftcolor=grey
fontfamily=Arial fontsize=2];&amp;nbsp;
define timeonjob/ right style(column)= [width=7 bordertopcolor=grey borderbottomcolor=grey borderrightcolor=grey borderleftcolor=grey
fontfamily=Arial fontsize=2];&amp;nbsp;
define housepay/ right style(column)= [ width=7 bordertopcolor=grey borderbottomcolor=grey borderrightcolor=grey borderleftcolor=grey
fontfamily=Arial fontsize=2];&amp;nbsp;
define franch/ right style(column)= [width=7 bordertopcolor=grey borderbottomcolor=grey borderrightcolor=grey borderleftcolor=grey
fontfamily=Arial fontsize=2];&amp;nbsp;
define new/ style(column)= [ width=7 just=right bordertopcolor=grey borderbottomcolor=grey borderrightcolor=grey borderleftcolor=grey
fontfamily=Arial fontsize=2] ;&amp;nbsp;

run;
ods html close;&lt;/CODE&gt;&lt;/PRE&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ods html output" style="width: 498px;"&gt;&lt;img src="https://communities.sas.com/t5/image/serverpage/image-id/14255i8414A46872487E7F/image-size/large?v=v2&amp;amp;px=999" role="button" title="data.jpg" alt="ods html output" /&gt;&lt;span class="lia-inline-image-caption" onclick="event.preventDefault();"&gt;ods html output&lt;/span&gt;&lt;/span&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The attached image shows how it outputs&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 31 Jul 2017 22:57:15 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Procedures/Proc-Report-won-t-justify-column-data/m-p/384465#M65652</guid>
      <dc:creator>dapstat</dc:creator>
      <dc:date>2017-07-31T22:57:15Z</dc:date>
    </item>
    <item>
      <title>Re: Proc Report won't justify column data</title>
      <link>https://communities.sas.com/t5/SAS-Procedures/Proc-Report-won-t-justify-column-data/m-p/384664#M65684</link>
      <description>&lt;P&gt;Can you provide a data step that will create 5 to 10 rows of data that we test code against?&lt;/P&gt;</description>
      <pubDate>Tue, 01 Aug 2017 15:54:23 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Procedures/Proc-Report-won-t-justify-column-data/m-p/384664#M65684</guid>
      <dc:creator>ballardw</dc:creator>
      <dc:date>2017-08-01T15:54:23Z</dc:date>
    </item>
  </channel>
</rss>

