topic Subtracting numbers in SAS Data Management

Subtracting numbers

mlogan — Fri, 30 Oct 2015 16:10:35 GMT

Hi All,

I am subtracting count2 from count1. I have some missing variables (which is actually zero) and in the result column it shows (.) instead of a munber i am expecting. can someone please help.

Data want;
set have;
Result = (count2-count1);
run;

Count1 Count2 Result

. 5 .

2 6 4

. 3 .

Re: Subtracting numbers

Kurt_Bremser — Fri, 30 Oct 2015 16:13:36 GMT

Try

result = sum(count2,-count1);

Re: Subtracting numbers

Reeza — Fri, 30 Oct 2015 16:14:04 GMT

Do you want the missing number treated as 0?
To get around this you can use the sum function instead.

result = sum(count2, -1*count1);