Hi,
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 N/"Nbr_of_optys";
define Tot_Forecast/Computed format=Dollar15.2;
Tot_Forecast=Tot_Budget.sum*Probabilty*0.01;
endcomp;
rbreak after/summarize ;
run;
i am getting a error:
: Statement is not valid or it is used out of proper order.
Looks like you're missing the COMPUTE statement that should precede Tot_Forecast=Tot_Budget.sum*Probabilty*0.01;
You seem to have mis-matching quotes (started using double and ended using single)?
define Probability/Group width=12 descending"Probabilty';
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.