Multiple choice technology programming languages

data sasdata.atlanta sasdata.boston work.portland work.phoenix; set company.prdsales; if region='NE' then output boston; if region='SE' then output atlanta; if region='SW' then output phoenix; if region='NW' then output portland; Which one of the following is true regarding the output datasets

  1. No library references are required

  2. The datasets listed on all the IF statements require a library reference

  3. The datasets listed on the last two IF statements require a library reference

  4. The datasets listed on the first two IF statements require a library reference
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The SAS DATA statement declares four output datasets with two-level names. The first two IF statements output to sasdata.atlanta and sasdata.boston - the libref 'sasdata' must be explicitly assigned with a LIBNAME statement. The last two IF statements output to work.portland and work.phoenix - 'work' is SAS's built-in temporary library, automatically available without any LIBNAME statement.

Keep practicing — related questions