Proc Report Summarize difference

[debrahudson]

Does anyone know if you can use summarize in proc report to find the difference between to columns?  Or for that matter, just to add a row to find the difference between two rows?

	Employee
Period1	159,574
Period2	167,530
Change	-7,956
	Member
Period1	6,788
Period2	7,261
Change	-473

[PaigeMiller]

Its really unclear to me what you are asking. You want the "difference between to [sic] columns", but the only two columns shown are character strings in the left column and numbers in the right column, and you cannot compute a difference between character string and numbers.

Please start by showing us (a portion of) the data that goes into PROC REPORT. Then explain and show us clearly what the desired results are from PROC REPORT.

[debrahudson]

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