Subtracting numbers

[mlogan]

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             . 

[Kurt_Bremser · Accepted solution]

Try

result = sum(count2,-count1);

[Reeza]

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);