Home › Practice › SAS vs R for Clinical Programming — 26-Day Series

Day 24: SQL Joins and Set Operators — SAS vs R

PROC SQL joins, COALESCE, IN subqueries and UNION vs dplyr joins

Practice PROC SQL joins against dplyr: inner, left, right and full joins, COALESCE on keys, two-key and range joins, one-to-many row counts, IN and NOT IN versus semi_join() and anti_join(), and UNION, INTERSECT and EXCEPT with the position-versus-name trap.