topic How to sum positive numbers and negative numbers in a variable? in SAS Programming

How to sum positive numbers and negative numbers in a variable?

Saikiran_Mamidi — Wed, 13 May 2020 10:14:54 GMT

Data have;

input id;

cards;

-1

-2

-3

;

run;

sum of nagative values in positive varible

sum of positive values in negative variable

like below

positive negative

60 -6

Re: How to sum positive numbers and negative numbers in a variable?

PaigeMiller — Wed, 13 May 2020 10:21:20 GMT

Data have;
input id;
if id<0 then negative+id;
else if id>0 then positive+id;
cards;
-1
-2
-3
10
20
30
;
run;

You have negative ID numbers?

Re: How to sum positive numbers and negative numbers in a variable?

yabwon — Wed, 13 May 2020 10:26:22 GMT

Just for fun 🙂

Data have;
input id;
negative + (id<0)*id;
positive + (id>0)*id;
cards;
-1
-2
-2
10
20
30
;
run;

Bart

Re: How to sum positive numbers and negative numbers in a variable?

Ksharp — Wed, 13 May 2020 11:10:20 GMT

Just for fun.

Data have;
input id;
cards;
-1
-2
-3
10
20
30
;
proc sql;
select (select sum(id) from have where id>0) as positive,
       (select sum(id) from have where id<0) as negative
from have(obs=1);
quit;