12-28-2017 12:00 PM
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?
01-02-2018 02:46 PM
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;