---

Suppose you are asked to concatenate the list of instructors who teach at the Dallas location and suppose also that the begin date for the course is after 01JAN2020. The list of instructors should be stored in a macro variable and should be separated by a comma with no leading or trailing blanks. Which SQL program would correctly accomplish the task?

proc sql noprint;
    select distinct Teacher format=$upcase21.,
    into NameListDallas separated by ','
    from certadv.schedule
    where Location='Dallas' and Begin_Date>'01JAN2020'd;
quit;
%put &=NameListDallas;

proc sql noprint;
    select distinct Teacher format=$upcase21.
    into:NameListDallas separated by ',' trimmed
    from certadv.schedule
    where Location='Dallas' and Begin_Date>'01JAN2020'd;
quit;
%put &=NameListDallas;

proc sql noprint;
    select distinct Teacher format=$upcase21. as NameListDallas
    separated by ',' trimmed
    from certadv.schedule
    where Location='Dallas' and Begin_Date>'01JAN2020'd;
quit;
%put &=NameListDallas;

proc sql noprint;
    select distinct Teacher format=$upcase21.
    into:NameListDallas separated by ','
    from certadv.schedule
    where Location='Dallas' and Begin_Date>'01JAN2020'd;
quit;
%put &=NameListDallas;