The SAS Output Delivery System and reporting techniques

PROC PRINT SUM values are centred

Accepted Solution Solved
Reply
Contributor
Posts: 22
Accepted Solution

PROC PRINT SUM values are centred

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 Smiley Frustrated) 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

 


Accepted Solutions
Solution
a week ago
SAS Super FREQ
Posts: 9,424

Re: PROC PRINT SUM values are centred

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

View solution in original post


All Replies
Solution
a week ago
SAS Super FREQ
Posts: 9,424

Re: PROC PRINT SUM values are centred

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

Contributor
Posts: 22

Re: PROC PRINT SUM values are centred

Posted in reply to Cynthia_sas

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 90 views
  • 0 likes
  • 2 in conversation