Given has SAS dataset ONE:

The following SAS program is submitted:

proc sql; <insert SQL clause here> from one; quit; The following output is desired:

Which SQL procedure clause completes the program and generates the desired output?

Question

Given has SAS dataset ONE:

The following SAS program is submitted:

proc sql; <insert SQL clause here> from one; quit; The following output is desired:

Which SQL procedure clause completes the program and generates the desired output?

Accepted Answer

C. select salary, salary * .10 label = 'BONUS'

Answer

A. select salary, salary * .10 var = BONUS

Answer

B. select salary, salary * .10 name = 'BONUS'

Answer

D. select salary, salary * .10 column = 'BONUS'

Given has SAS dataset ONE: The following SAS program is submitted: proc sql; <insert SQL clause here> from one; quit; The following output is desired: Which SQL procedure clause completes the…