PROC PRINT SUM values are centred

[lethcons]

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

[Cynthia_sas · Accepted solution]

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

[lethcons]

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