A00-202 Real Exam Questions

Given the following SAS data set ONE: ONE CATEGORY AGE SALARY BONUS ----------------- ---------- -------------- ------------ M 28 200 20 M 25 100 10 M 28 300 10 M 33 300 30 F 18 100 50 F 25 200 10 F 35 400 50 The following SQL program is submitted: proc sql; create table two as select distinct age from one where age < 33; quit; How many rows are written to the SAS data set TWO?

Given the following SAS data set ONE: ONE GROUP SUM ----------------- -------- A 765 B 123 C 564 The following SAS program is submitted: data _null_; set one; call symput(group,sum); run; Which one of the following is the result when the program finishes execution?

The following SAS program is submitted: %macro execute; <insert statement here> proc print data = sasuser.houses; run; %end; %mend; Which of the following completes the above program so that it executes on Tuesday?

Given the following SAS statement: %let idcode = Prod567; Which one of the following statements stores the value 567 in the macro variable CODENUM?

Given the following SAS program: proc sql; select product, type, sum(sales) as revenue SAS A00-202 Exam from one group by product, type; quit; Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing REVENUE?