topic Re: How Can I Make Header Justified Left Partially by Using PROC REPORT? in ODS and Base Reporting

How Can I Make Header Justified Left Partially by Using PROC REPORT?

KentaMURANAKA — Tue, 04 Jun 2019 01:43:08 GMT

Hi, there:

I would like to make only part of headers ("AAAAA" in my example) justified left by using PROC REPORT.

I tried to use inline formatting, but my following code does not generate what I want, remains unchanged (center justified, in default?).

data test;
    length column1-column3 $200.;
    column1="aaaaa"; column2="bbbbb"; column3="ccccc"; output;
run;
ods rtf file="PleaseSpecifyYourOwnFolder\test.rtf";
proc report data=test nowindows;
    column ("(*ESC*){style[fontfamily='Times New Roman' just=left]AAAAA}" column1 ("BBBBB" column2) ("CCCCC" column3));
    define column1 / display;
    define column2 / display;
    define column3 / display;
run;
quit;
ods rtf close;

I have no idea. Please help me.

Thank you in advance.

Re: How Can I Make Header Justified Left Partially by Using PROC REPORT?

heffo — Tue, 04 Jun 2019 03:16:29 GMT

Try style(header)={just=l} on the proc report line:

proc report data=test nowindows style(header)={just=l};
    column ("(*ESC*){style[fontfamily='Times New Roman' just=left]AAAAA}" column1 ("BBBBB" column2) ("CCCCC" column3));
    define column1 / display;
    define column2 / display;
    define column3 / display;
run;

Re: How Can I Make Header Justified Left Partially by Using PROC REPORT?

KentaMURANAKA — Tue, 04 Jun 2019 04:00:29 GMT

Hi, heffo-san:

Your code works.

Thank you.

I have one more question.

I think, your code's style(header)=xx effects overall headers, but result is not (only for top header "AAAAA").

I misunderstand? Any reference info is welcome.

Thank you in advance.

Re: How Can I Make Header Justified Left Partially by Using PROC REPORT?

KentaMURANAKA — Tue, 04 Jun 2019 04:17:46 GMT

Hi, heffo-san, All:

Sorry, but one problem,

Following your code, almost all headers, "AAAAA"~"CCCCC" are left justified.

I want lower headers, "BBBBB" & "CCCCC" to remain unchanged (i.e., center justified).

Please help me. Thank you in advance.

Re: How Can I Make Header Justified Left Partially by Using PROC REPORT?

heffo — Wed, 05 Jun 2019 00:49:37 GMT

Could this work:

ods escapechar='^';
ods rtf file="\\FMAWPDFP02\Home$\henrik.forsell\test2.rtf";
proc report data=test nowindows style(header)={just=l};
	column ('aaaaa' column1 ('^S={just=c} bbbb' column2) ('^S={just=c} cccc' column3));
    define column1 / display;
    define column2 / display;
    define column3 / display;
run;
quit;
ods rtf close;

Re: How Can I Make Header Justified Left Partially by Using PROC REPORT?

KentaMURANAKA — Thu, 06 Jun 2019 11:58:12 GMT

heffo-san:

Thanks a lot!!