DATA Step, Macro, Functions and more

PROC Report

Reply
Contributor
Posts: 50

PROC Report

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.

Super Contributor
Posts: 394

Re: PROC Report

Looks like you're missing the COMPUTE statement that should precede Tot_Forecast=Tot_Budget.sum*Probabilty*0.01;

Occasional Contributor
Posts: 9

Re: PROC Report

You seem to have mis-matching quotes (started using double and ended using single)?

 

define Probability/Group width=12 descending"Probabilty';

 

 

Super User
Super User
Posts: 7,401

Re: PROC Report

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;

 

 

Ask a Question
Discussion stats
  • 3 replies
  • 246 views
  • 3 likes
  • 4 in conversation