topic How to do a subtraction from col a to col b in SAS Procedures

How to do a subtraction from col a to col b

Beto16 — Sat, 16 Jul 2016 03:11:18 GMT

Hi I have a table that looks like this
Id. DollarA. Dollar B
1. 10. 45
2. 50. 35
3. 20. 25
I need it to look like this
. DollarA. Dollar B. DIFF
1. 10. 45. 35
2. 50. 35. 15
3. 20. 25. 5

Thanks for assistance

Re: How to do a subtraction from col a to col b

Reeza — Sat, 16 Jul 2016 04:42:44 GMT

Diff = b - a;

Re: How to do a subtraction from col a to col b

jklaverstijn — Sat, 16 Jul 2016 07:22:53 GMT

Looks like you need the absolute value of the difference:

diff=abs(a-b);

- Jan.

Re: How to do a subtraction from col a to col b

Beto16 — Mon, 18 Jul 2016 02:17:40 GMT

Thank you -Jan