SAS Certified Advanced Programmer Exam Practice Test

A pharmaceutical safety group is joining case, product, and reporter tables. The same case can have multiple products, but report-level metrics must not be inflated. A claims analyst needs the earliest paid claim per member using PROC SQL. Several members have multiple claims on the same earliest date, and ties should be retained. Which query shape is best?

A university research center is converting legacy SAS programs written by several analysts. Some code relies on formats, some on macros, and the output must match last year's published appendix. During development, a programmer wants PROC SQL to read only the first 500 rows from each source table to test join logic quickly. Which option is the better fit?

A clinical trials programmer is validating SDTM-derived transfer tables on SAS 9.4M8. The nightly job runs on Linux, receives late adverse-event corrections, and must leave an auditable log. A reviewer asks for the exact CREATE TABLE-style definition of a SAS SQL view before approving a production change. Which PROC SQL statement provides the definition in the log?

A university research center is converting legacy SAS programs written by several analysts. Some code relies on formats, some on macros, and the output must match last year's published appendix. A compliance cleanup must remove rows from a staging table only when the same key appears in a reviewed rejection table. The production history table must not be touched. Which SQL statement is safest?

A retail loyalty program is loading daily transaction feeds with duplicate customer IDs, sparse coupon columns, and a small reference table maintained by marketing in a permanent SAS library. A reference table contains replacement risk bands for some, but not all, customers. The production table should update only rows with a matching replacement and leave all others untouched. Which pattern is safest?