~/sas-a00-232 · study

← all exams

practice sheet · all objectives switch to smart practice →

SAS Certified Professional: Advanced Programming Using SAS 9.4

0/42 checked
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
Q_17 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_18 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_19 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_20 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_21 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_22 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_23 domain/d2 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_24 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_25 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_26 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_27 domain/d2 · easy single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_28 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_29 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_30 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_31 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_32 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_33 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_34 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_35 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_36 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_37 domain/d3 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_38 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_39 domain/d3 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_40 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_41 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review
Q_42 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

40 questions locked

unlock all 40 questions