----|----10---|----20---|----30
1901 2
1905 1
1910 6
1925 .
1941 1
The following SAS program is submitted and references the raw data file above:
data coins;
infile'file-specification';
input year quantity;
<insert statement(s) here>
run;
Which one of the following completes the program and produces a non-missing
value for the variable TOTQUANTITY in the last observation of the output data
set? (here quantity is the numbers 2,1,6,.,1 in the dataset)
A. totquantity + quantity;
B. totquantity = sum(totquantity + quantity);
C. totquantity 0;
sum totquantity;
D. retain totquantity 0;
totquantity = totquantity = quantity;
Ans –A
Doubt: As A is not in a SUM or RETAIN statement won't it cause missing value as '.'; or does this expression accumulates and retains the values?