mycsg.in
SAS
SASnR
Clinical Programming
CRFs
SDTM
ADaM
TFL
Tasks
Macros
QnA
Certification
Resources
Disclaimer
Contact Us
Sign Up
Login
This website uses cookies to personalize content and analyse traffic in order to offer you a better experience. By clicking "OK", or continuing using our site, you consent to the use of cookies.
OK
Quiz title : Using Subqueries
Question 1 of 10
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
;