Multiple choice technology programming languages

Which of the following displays the structure of a table in the SAS log?

  1. proc sql; describe as select * from sasuser.payrollmaster;

  2. proc sql; describe contents sasuser.payrollmaster;

  3. proc sql; describe table sasuser.payrollmaster;

  4. proc sql; describe * from sasuser.payrollmaster;
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Option C uses the correct PROC SQL syntax DESCRIBE TABLE to display table structure in the SAS log. Option A incorrectly combines DESCRIBE with a SELECT statement. Option B uses CONTENTS which is valid for dictionaries but not the correct syntax for tables. Option D incorrectly uses DESCRIBE with a wildcard.

Keep practicing — related questions