Proc report

[Defense]

I am using proc report to generate report then output with ODS RTF. In the expected report (attached) column “Location” include four rows. We expect row1” Total # of Participants in the country” be align left, while other rows (City1, City2 and City3) to be on CENTER.

Question:

Is there any way to align some rows left and some rows center in one column using proc report?

[ballardw]

---

@Defense wrote:

I am using proc report to generate report then output with ODS RTF. In the expected report (attached) column “Location” include four rows. We expect row1” Total # of Participants in the country” be align left, while other rows (City1, City2 and City3) to be on CENTER.

Question:

Is there any way to align some rows left and some rows center in one column using proc report?

---

Show the code for proc report and reference which elements need which alignment. Style overrides can be specified for each element and even conditionally with a little work. But guessing which variable and what not is kind of problematic.

[Defense]

ods rtf file="&outdir\Table1.rtf";

title1 'Table XX';

title2 'Members by Country and City ';

proc report data=table NOWD;

column Location All;

define Location /"Location" style=[cellwidth=1 in font =("Arial",8) just=c];

define All /display "All" style=[cellwidth=1 in font =("Arial",8) just=c];

run;

ods rtf close;

[Reeza]

This shows how to colour the cells but the STYLE can also include the alignment/justification. 

This is know as conditional formatting.

http://support.sas.com/kb/23/353.html

---

@Defense wrote:

ods rtf file="&outdir\Table1.rtf";

title1 'Table XX';

title2 'Members by Country and City ';

proc report data=table NOWD;

column Location All;

define Location /"Location" style=[cellwidth=1 in font =("Arial",8) just=c];

define All /display "All" style=[cellwidth=1 in font =("Arial",8) just=c];

run;

ods rtf close;

---

[Defense]

Thanks. Code has been posted. Variable "Location" row 1 need to alignment to left, while row2-4 need to be alignment to center
Thanks