Made a dummy data :

data dummy;
input q1 q3 q4 q2 q6$ bu$ q5;
cards;
1 2 3 5 sa an 3
2 4 3 6 sm sa 4
6 5 3 8 cb na 3
;
run;
data test1(drop=q1--q5);
set dummy;
total = sum(of q1-q4);
total1 = sum(of q1--q4);
proc print data=test1;
run;

if I change the total = sum(of q1-q4); to total = sum(q1-q4); the output changes. How are the two different? And how are they calculated?

1

1 Answer

• sum(of q1-q4) means sum(q1, q2, q3, q4).
• sum(of q1--q4) means sum of all numeric variables that are placed between q1 and q4 (included) in the PDV.
• sum(q1-q4) is different. In this case - is a minus sign. In your first obs, that means total = sum(q1-q4) = sum(1-3) = sum(-2) = -2.

0

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.