topic Re: Proc report in ODS and Base Reporting

Proc report

Defense — Wed, 20 Dec 2017 15:33:02 GMT

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?

Re: Proc report

ballardw — Wed, 20 Dec 2017 15:45:44 GMT

@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.

Re: Proc report

Defense — Wed, 20 Dec 2017 15:57:06 GMT

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;

Re: Proc report

Defense — Wed, 20 Dec 2017 16:02:56 GMT

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

Re: Proc report

Reeza — Wed, 20 Dec 2017 16:30:25 GMT

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;