Multiple choice technology programming languages

Which of the following correctly creates a macro variable in a PROC SQL step?

  1. call symput(daily_fee, put(fee/days, dollar8.);

  2. %let daily_fee=put(fee/days, dollar8.)

  3. select fee/days format=dollar8. into :daily_fee from sasuser.a

  4. select fee/days format=dollar8. into daily_fee from sasuser.all;
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In PROC SQL, macro variables are created using the INTO clause with a colon prefix. Option C shows the correct syntax: select ... into :daily_fee. Option A uses SYMPUT which is a DATA step function. Option B uses %LET which is not SQL. Option D is missing the colon prefix.

Keep practicing — related questions