07-25-2016 08:28 AM
This is my code :
Proc report data=Olympics.Case7 nowd headline headskip;
Column Probability Nbr_of_optys Tot_Budget Tot_Forecast;
define Probability/Group width=12 descending"Probabilty';
define Tot_Budget/Analysis SUM FORMAT=Dollar15.2"Tot_Budget";
define Tot_Forecast/Computed format=Dollar15.2;
rbreak after/summarize ;
i am getting a error:
: Statement is not valid or it is used out of proper order.
07-25-2016 08:38 AM
This is a good example of where coding formatting would have highlighted your question - also note there are other typos in that code:
Here the code is fixed - there was unbalanced quotes around Probability, and missing compute line.
proc report data=olympics.case7 nowd headline headskip; column probability nbr_of_optys tot_budget tot_forecast; define probability / group width=12 descending "Probabilty"; define tot_budget / analysis sum format=dollar15.2 "tot_budget"; define n / "nbr_of_optys"; define tot_forecast / computed format=dollar15.2;
compute tot_forecast; tot_forecast=tot_budget.sum*probabilty*0.01; endcomp;
rbreak after/summarize ; run;