topic Re: Calculate percentage between the variables in SAS Programming

Calculate percentage between the variables

Babloo — Fri, 09 Nov 2018 11:42:43 GMT

I've the data as follows and I need to calculate the percentage of difference between the variables 'amount1' and 'amount2' by ignoring the negative sign.

Input data:

AMOUNT1	AMOUNT2
100	110
200	220
1000	100
100	20
1000	900

Desired Output:

AMOUNT1	AMOUNT2	Diff in percent
100	110	10
200	220	10
1000	100	90
100	20	80
1000	900	10

Datastep to create the data:

data A;
Input AMOUNT1 AMOUNT2 ;
cards;
100 110
200 220
1000 100
100 20
1000 900
;
run;

Re: Calculate percentage between the variables

Peter_C — Fri, 09 Nov 2018 11:49:22 GMT

Use range( amount1, amount2) / amount1

Re: Calculate percentage between the variables

trungdungtran — Fri, 09 Nov 2018 11:53:50 GMT

You can use

data B;
	set A;
	diff=round(abs(AMOUNT2-AMOUNT1)/AMOUNT1*100);
run;

where abs is absolute value, i.e., ignoring negative. If you do not need round, then you can remove it.

Re: Calculate percentage between the variables

FreelanceReinh — Fri, 09 Nov 2018 11:53:59 GMT

Or try this:

data want;
set a;
if amount1>0 then diffpct=round(abs(amount2/amount1-1)*100,1e-9);
else diffpct=.;
label diffpct='Diff in percent';
run;

proc print data=want label noobs;
run;

Re: Calculate percentage between the variables

Babloo — Fri, 09 Nov 2018 12:22:44 GMT

What format should I use to display the percentage with percent sign (%) as shown below?

Diff in percent

10%

90%

80%

10%

Re: Calculate percentage between the variables

s_lassen — Fri, 09 Nov 2018 12:30:44 GMT

If you want the differences shown with a percent sign, the easiest is to calculate the absolute relative difference, and use the PERCENT. format to display as a percent:

data want;
  set a;
  rel_diff=abs((amount1-amount2)/amount1);
  format rel_diff percent5.0;
run;

Re: Calculate percentage between the variables

Kurt_Bremser — Fri, 09 Nov 2018 12:49:46 GMT

@Babloo wrote:

What format should I use to display the percentage with percent sign (%) as shown below?

Diff in percent

10%

10%

90%

80%

10%

Are you really too lazy to google "sas percent"?

Re: Calculate percentage between the variables

FreelanceReinh — Fri, 09 Nov 2018 13:10:14 GMT

@Babloo wrote:

Diff in percent

10%

Also, I don't think it's the best style to write both percent signs after the numbers and "in percent" in the header (same with other units of measurement).

Re: Calculate percentage between the variables

trungdungtran — Sat, 10 Nov 2018 18:17:08 GMT

I agree with you that it seems to lazy. I had this feeling from the first post and now you share the same feeling.