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
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
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
Perfect Cynhia, thanks! I had tried playing with that but I must have had it in the wrong place.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.