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

Day 23: PROC SQL Basics — SAS vs R

Single-table SQL queries in SAS, dplyr and sqldf, with missing traps

Practice PROC SQL against dplyr and sqldf: SELECT, CREATE TABLE, WHERE, ORDER BY, DISTINCT, COUNT, GROUP BY, HAVING, CALCULATED, CASE WHEN, remerging, and ALTER/UPDATE/DELETE/INSERT, with the missing-value differences that break QC.