Proc report - percentages

[Reddi]

Hi ,

I would like to see the percentages instead of the numbers after running the following program.

proc report data=final_modelling1 nowd out=samp(drop=_BREAK_ where=(type NE "") rename=(_C2_=pr_susp_N _C3_=pr_susp_Y));

  title '2) With Group Usage';

  column type pr_susp,canc_from_del ,sum ;

  define type / group;

  define pr_susp / across '--pr_susp--';

  define canc_from_del / analysis sum '';

/*  define n  / 'Count';*/

/*  define sum / 'Group Total Value';*/

  define sum / '' /*f=percent9.2*/;

  rbreak after / summarize;

run;

	pr_susp_N	pr_susp_y
Type1	1256	1596
Type2	2869	5496

instead I'd like to have the output dataset like below ,

	pr_susp_N	pr_susp_y
Type1	11.2%	14.2%
Type2	25.6%	49.0%

Is there a way to get the required output please?

[RW9]

Use a computed block:

https://support.sas.com/resources/papers/proceedings/pdfs/sgf2008/031-2008.pdf