topic Re: Aligning Line total to the right in ODS and Base Reporting

Aligning Line total to the right

Q1983 — Tue, 01 Dec 2015 17:16:37 GMT

proc report data=post_deploy_3 nowd;

columns SALE_REP_NM acct_exec_nm THRD_PARTY_ORIG_NM THRD_PARTY_ORIG_CD Total_Count;

define SALE_REP_NM/ group Display style(column)={cellwidth=60pt just=center} "CRC" ;

define Total_Count/analysis sum ;

compute after;

THRD_PARTY_ORIG_CD = "Total";

line "Total" Total_Count.sum ;

endcomp;

run;

The code works fine however the Total_Count (label=Grand Total) at the bottom needs to display under the total column. Sample data enclosed. It display near the middle of the bottom

Re: Aligning Line total to the right

JerryLeBreton — Wed, 02 Dec 2015 04:02:03 GMT

Try this:

rbreak after / summarize;
compute after ;
  if _break_  = '_RBREAK_' then THRD_PARTY_ORIG_CD = 'Total';
endcomp;

If I understand what you're trying to do, this should give a last line with the total in the correct column, and the word 'Total' in the column immediately to the left of the total value.

Re: Aligning Line total to the right

Q1983 — Wed, 02 Dec 2015 14:31:38 GMT

Jerry you are a genious, thanks it worked, I will add this to my coding tips list