This is a continuation of a report that I previously received help with (https://communities.sas.com/message/277590), but since this a different issue, I decided to open another discussion. Xia Keshan helped me with the below code (although I added a couple of columns for demonstration purposes) to calculate row subtractions and it works well. The problem I'm having is formatting the computed variables to display nicely under the respective columns in the line @ statement. I've tried applying different commaW. widths, but the unless the subtractions results are the same size the alignment gets skewed. I've also tried to right justify the @line, but since each BREAK AFTER subtraction can have 1-4 digit differences, the results start off aligned, but get offset by different result widths. I appreciate any help. Thank you, Tim. data have; input country $ town $ _2012 : comma12. _2013 : comma12. _2014 : comma12. _2015 : comma12. ; format _2012 _2013 _2014 _2015 : comma12.; cards; USA LA 999,999 985,733 888,888 777,777 USA NY 888,888 895,000 888,887 777,677 Canada VAN 500,000 550,000 650,000 675,000 Canada TOR 750,000 751,000 650,010 675,100 ; run; proc report data=have nowd ; column country town _2012 _2013 _2014 _2015; define country/order; define town/display; define _2012/display; define _2013/display; define _2014/display; define _2015/display; compute before country; n=0; endcomp; compute _2015; n+1; if n=1 then do;sum_2012=_2012;sum_2013=_2013;sum_2014=_2014;sum_2015=_2015;end; else do;sum_2012+-1*_2012;sum_2013+-1*_2013;sum_2014+-1*_2014;sum_2015+-1*_2015; end; endcomp; compute after country; line @1'Difference' @17 sum_2012 comma12. sum_2013 comma12. sum_2014 comma12. sum_2015 comma12.; endcomp; run;
... View more