proc report - rbreak summaries not giving sum of computed variable

riya275 — Thu, 28 Dec 2017 17:00:53 GMT

proc report data= c1.o;
columns probability____  probability____=opp Total_Media_Value Forecasted_Budget ;
define probability____ / group descending 'Probability';
define Total_Media_Value / SUM 'Total Budget' format= dollar30. ;
define Forecasted_Budget/ computed 'Forecasted Budget'format= dollar30.;
compute Forecasted_Budget;
Forecasted_Budget= (Total_Media_Value.sum)*(probability____);
endcomp;
define opp/n 'Num_of_optys';
rbreak after/ ol summarize style=[backgroundcolor= grrp color=aliceblue ];
title 'London Olympic Pipeline As of 17th November 2012';
run;

Here in the report , in the last line where summary is given, i get a missing value for the column Foretasted Budget (computed variable). How to fix this?

Re: proc report - rbreak summaries not giving sum of computed variable

snoopy369 — Tue, 02 Jan 2018 19:46:35 GMT

Can you show example data that shows the problem? I don't see it in an example dataset such as here:

proc report data=sashelp.class;
columns sex height weight bmi;
define sex/group;
define height/analysis mean;
define weight/analysis mean;
define bmi/computed;
compute bmi;
  bmi = (weight.mean/2.3)/((height.mean/39)**2);
endcomp;
rbreak after/ol summarize;
run;

topic Re: proc report - rbreak summaries not giving sum of computed variable in SAS Programming

proc report - rbreak summaries not giving sum of computed variable

Re: proc report - rbreak summaries not giving sum of computed variable