Quiz

mycsg.in

SAS
SASnR
Clinical Programming
CRFs SDTM ADaM TFL Tasks Macros
Quizzes
Resources
Disclaimer
Contact Us

🎉

A little announcement. A lot to explore.

Happy learning!

Explore lessons, including SAS & R programs and practice data.

WhatsApp

For Instagram or another app, paste the message and link.

Search lessons

Search lessons ⚲

Area

Type at least 3 characters to see matching lessons.

Search titles, descriptions, and keywords

1 / 9

Joining Tables Using Set Operators
Question 1 of 9

Which PROC SQL step returns the names of all the students who took both the PROG1 and PROG2 classes?

proc sql;

    select fname, lname
    from certadv.prog1 union corr
    select fname, lname
    from certadv.prog2;

quit;

proc sql;

    select fname, lname
    from certadv.prog1 intersect all
    select fname, lname
    from certadv.prog2;

quit;

  
proc sql;  
    select fname, lname
    from certadv.prog1 except corr
    select fname, lname
    from certadv.prog2;
  quit;

proc sql;

    select fname, lname
    from certadv.prog1 union
    select fname, lname
    from certadv.prog2;

quit;

Saving progress… My progress

Report this question

Quiz:

Loading the question…

Question

What's the issue?

The marked correct answer is wrong

Question is unclear / insufficient information

Pick the correct answer marked correct

Describe the issue (optional)

© 2014–2026 Copyright: www.mycsg.in