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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.