Dear all, Regarding "SAS 9.4 Base Programming Performance-Based Exam" practice examination, I have the following code which produces the same result as the solution code which SAS provided: libname results "....../Cert/output"; Proc sort data=cert.input08a out=sorted_08a; by ID; run; Proc sort data=cert.input08b out=sorted_08b; by ID; run; Data results.match08 results.nomatch08(drop=ex: ); merge sorted_08a(in=a8) sorted_08b(in=b8); by ID; if a8 and b8 then output results.match08; else output results.nomatch08; run; However, to answer question 3 ("How many observations (rows) are in results.match08?") and 5 ("How many observations (rows) are in results.nomatch08?"), I got 51 for the former, and for the later, 1151. More so, the provided solution gave the same results as the referenced figures. However, 1200 and a 2 where given in the solutions as the right answers. I have read through the log and the contents which resulted from the proc procedure but couldn't deduce how the figures where derived. I should be most grateful for your insights.
... View more