i have created a tabulate with two dfferent dates' data as values (example below):
sumary data:
DPD Date _freq_
1 20/05/2010 500
30 20/05/2010 500
60 20/05/2010 500
1 21/05/2010 400
30 21/05/2010 400
60 21/05/2010 400
tabulate result
DPD 20/05/2010 21/05/2010
1 500 400
30 500 400
60 500 400
code
PROC TABULATE DATA= jackie.oview_201 format=comma13.;
CLASS DPD DATE ;
VAR _freq_;
TABLE DPD,Date*_freq_;
TITLE 'Late Stage Overview Number';
label _freq_ =Number;
RUN;
how do i get a variance between the two figures if it is a result of the tabulate?
Desired Result:
DPD 20/05/2010 21/05/2010 Variance
1 500 400 100
30 500 400 100
60 500 400 100
also, i want my ods output in excel to reflect the data with a white background
(i already have the headings under control).