topic PROC PRINT SUM values are centred in ODS and Base Reporting

PROC PRINT SUM values are centred

lethcons — Tue, 07 Aug 2018 14:55:29 GMT

When I run this code (SAS 9.4M5)

data a;
kkkkkkkkk='A';
xxxxxxxxx=1;
yyyyyyyyy=2;
output;
kkkkkkkkk='B';
xxxxxxxxx=11;
yyyyyyyyy=22;
output;  
run;

ods html close; 
ods html file="<path>\Report.html" style=meadow;

proc print data=a noobs;
var kkkkkkkkk xxxxxxxxx yyyyyyyyy;
sum xxxxxxxxx yyyyyyyyy;
run;

ods html close;

The output in the SAS Results window is as expected, but in Report.docx (attached, contains the output Report.html but cannot attach .html file here ) you will see the SUM figures are centred. This doesn't happen if I use style=default. I can't find any way of getting the SUM values right-justified. Can anyone please advise?

Many thanks.

-Howard

Re: PROC PRINT SUM values are centred

Cynthia_sas — Tue, 07 Aug 2018 15:27:30 GMT

Hi:

You need to add a STYLE override to your PROC PRINT statement:

proc print data=a noobs
style(grandtotal)={just=r};
var kkkkkkkkk xxxxxxxxx yyyyyyyyy;
sum xxxxxxxxx yyyyyyyyy;
run;

Then you'll right justify the grand total from the SUM statement. Here's a paper that discusses style overrides with PRINT, REPORT and TABULATE: http://support.sas.com/resources/papers/proceedings13/366-2013.pdf .

Cynthia

Re: PROC PRINT SUM values are centred

lethcons — Tue, 07 Aug 2018 15:33:28 GMT

Perfect Cynhia, thanks! I had tried playing with that but I must have had it in the wrong place.