Can't calculate horisontal difference in PROC REPORT

[Multipla99]

Can someone please help me and explain why I get the following messages when I run the code below?

NOTE: Variable Weight is uninitialized.
NOTE: Variable Height is uninitialized. 

And why the column DIFF is empty in the result table?

proc report

data= SASHELP.CLASS;

  column Sex Height Weight Diff;

define Sex / group

'Sex'

style(column)=

{just= l }; 

define Height  / sum

'Height'

style(column)=

{just= l }; 

define Weight / sum

'Weight'

style(column)=

{just= l }; 

define  Diff / computed 'Diff'

style(column)=

{just= r};  

  compute Diff;

    Diff = Height - Weight;

  endcomp;

    compute before;

        Sex='TOTALT';

    endcomp;

    rbreak before/ SUMMARIZE;

run;

[Kathryn_SAS · Accepted solution]

You need to refer to the variables with their .statistic extension. Also to prevent the label for Sex from being truncated at the Break line, you need to change the length.

Revised code:

data class;
length sex $8;
set sashelp.class;
run;

proc report data= CLASS;
column Sex Height Weight Diff;
define Sex / group 'Sex'
style(column)={just= l }; 
define Height  / sum 'Height'
style(column)= {just= l }; 
define Weight / sum 'Weight'
style(column)= {just= l }; 
define  Diff / computed 'Diff'
style(column)= {just= r};  

compute Diff;
 Diff = Height.sum - Weight.sum;
endcomp;

compute before;
Sex='TOTALT';
endcomp;

rbreak before/ SUMMARIZE;
run;

[Tom]

PROC REPORT can create the longer variable.

proc report data= sashelp.CLASS;
column Sex Sex2 Height Weight Diff;
define Sex / group noprint;
define Sex2 /  group computed 'Sex' style(column)={just= l }; 
define Height  / sum 'Height' style(column)= {just= l }; 
define Weight / sum 'Weight' style(column)= {just= l }; 
define  Diff / computed 'Diff' style(column)= {just= r};  

compute sex2 / character length=8;
  sex2=sex;
endcomp;

compute Diff;
 Diff = Height.sum - Weight.sum;
endcomp;

compute before;
Sex2='TOTAL';
endcomp;

rbreak before/ SUMMARIZE;
run;