~/sas-a00-232 · study ▊

← all exams

practice sheet · all objectives switch to smart practice →

SAS Certified Professional: Advanced Programming Using SAS 9.4

0/16 checked
Practising Accessing Data Using SQL · 16 questions · View the full exam →
Q_01 domain/d1 · medium single discuss →

A programmer needs a report that shows each salesperson's name only once, even though the source table contains duplicate name rows. Which PROC SQL feature should be used to remove those duplicate values from the result set?

Q_02 domain/d1 · medium single discuss →

When performing a full join and needing to return non-missing values from either of two matched columns into a single output column, which function is specifically identified in the objectives for this task?

Q_03 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_04 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_05 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_06 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_07 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_08 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_09 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_10 domain/d1 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_11 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_12 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_13 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_14 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_15 domain/d1 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_16 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

14 questions locked

unlock all 14 questions