Proc report - percentages

Reddi — Wed, 06 Feb 2019 08:12:28 GMT

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;

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

Is there a way to get the required output please?

Re: Proc report - percentages

RW9 — Wed, 06 Feb 2019 09:36:12 GMT

Use a computed block: