---

Which PROC SQL query removes duplicate values of MemberType from the query output, so that only the unique values are listed?

 

proc sql nodup;
    select membertype
    from certadv.frequentflyers;
quit;

---

 

proc sql;
    select distinct(membertype) as MemberType
    from certadv.frequentflyers;
quit;

---

 

proc sql;
    select unique membertype
    from certadv.frequentflyers
    group by membertype;
quit;

---

 

proc sql;
    select distinct membertype
    from certadv.frequentflyers;
quit;

---