I'm struggling with PROC REPORT on my break statements. I have a couple of columns that are numerical and should be right justified--and in the main output table it right justifies correctly. However, I have a couple of break after statements that are summarizing the numbers, and for some reason they left justify by default. I could add style(summary)={just=right}, but then it also right justifies the categorical columns, which should be left justified. Anyone know a way to left justify some columns and right justify others? I've tried a million different ways and nothing seems to work. Thank you. data test ;
infile datalines truncover;
input cust_order:$356. pledge_order:$25. bbcrm_pledge_id: $100. open_amount_rem:8. past_due_amount_rem:8.;
datalines;
Bread REV-123456 REV-123456 25 75
Bread REV-123456 REV-123456 35 65
Bread REV-123456 REV-123456 100 0
Bacon REV-234567 REV-234567 200 0
Bacon REV-234567 REV-234567 100 100
Bacon REV-234567 REV-234567 150 0
Coffee REV-345678 REV-345678 100 25
Coffee REV-345678 REV-345678 60 140
Coffee REV-345678 REV-345678 50 50
;
run;
proc report data=test spanrows
style(report)=[bordercolor=black borderwidth=3 just=right]
style(header)=[foreground=black background=light grey font_weight=bold bordercolor=black borderwidth=3 just=R]
style(summary)=[background=light grey font_weight=bold just=l bordertopcolor=black bordertopwidth=3 borderbottomcolor=black borderbottomwidth=3];
columns
cust_order
pledge_order
bbcrm_pledge_id
open_amount_rem
past_due_amount_rem
;
define pledge_order/order style(column)={just=r} noprint;
define cust_order/order style(column)={just=r} noprint;
define bbcrm_pledge_id/display style(column)=[borderleftcolor=black borderleftwidth=3 just=L];
break after cust_order /summarize dol dul style(summary)=[background=cxE4DFEC];
break after pledge_order /summarize dol dul style(summary)=[background=cxFCD5B4 ];
rbreak after/summarize ;
compute after cust_order;
bbcrm_pledge_id= 'Total '||trim(cust_order);
endcomp;
compute after pledge_order;
bbcrm_pledge_id= 'Total '||pledge_order;
endcomp;
run;
... View more
