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?
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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: