topic Re: PROC Report in SAS Programming

PROC Report

Prateek1 — Mon, 25 Jul 2016 12:28:09 GMT

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.

Re: PROC Report

Tim_SAS — Mon, 25 Jul 2016 12:33:33 GMT

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

Re: PROC Report

PaulLee — Mon, 25 Jul 2016 12:35:44 GMT

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

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

Re: PROC Report

RW9 — Mon, 25 Jul 2016 12:38:54 GMT

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;