I've been asked to automate the existing report.  I'm having trouble with creating the change line below.  I'm hoping somehow I can just use that summarize command to create the change but I do not know how to change the summarize function to be a difference.  Any help anyone can provide would be appreciated. thanks!   ods _all_ close; ods noresults; /*closes resluts window and directs output to file */ ods excel file="&file" options(start_at= "1,1" flow = "table" sheet_name = "Active" sheet_interval="none" embedded_titles='yes' absolute_column_width= "45,10,10,10,10,10,10,10,10,10,10,10,10,10,10" row_heights="40,15" embedded_footnotes='yes') style=SASDocPrinter; ODS ESCAPECHAR='^'; title1 justify=center; proc report data = QTR_MBRSP split='|' style(column) = {FONT = ('ARIAL') fontsize = 8.5pt} style(header) = {FONT = ('ARIAL') fontsize = 9.5pt fontweight =bold } style(report) = {FONT = ('ARIAL') fontsize = 9.5pt } headline headskip; columns Type Period contracts Adults children ; define Type / group; define Period / group ' ' ; define contracts / 'Employee|Months' computed ; define Adults / 'Member|Months' analysis ; define children / 'Percent|Adult' analysis ; compute after Type; line ' '; endcomp; break after Type / skip summarize style ={font_size=10pt font_face=Arial fontweight=bold} ; run; ods excel close; Active   Employee Member   Period1 159,574 3   Period2 167,530 2   Change -7,956 1         Satellite       Period1 6,788 12,562   Period2 7,261 13,703   Change -473 -1,141         Direct Pay       Period1 3,901 6,215   Period2 8,586 13,926   Change -4,685 -7,711 ... View more