WUSS Virtual Class: R for SAS Programmers: SQL Processing

In this workshop, you will learn about the Tidyverse package since it is a very powerful and a common R package for data management. You will learn about the DPLYR package since it simulates SQL type operations. We will focus on how to query data with select, drop and filter variables and records. In addition, you will learn how to derive new variables as well as how to stream R commands with piping.

While SAS programmers have the data step and Proc SQL, R programmers can leverage piping and DPLYR packages to streamline R functions for multiple SQL tasks. Once intermediate data frames are finalized, data frames can then be sorted, joined and appended together. Finally, summary variables and records can be created by overall or by group variables.

This workshop is hands-on and designed to increase your confidence to write error-free R syntax as well as review and confirm your results. This workshop is appropriate for beginner R programmers and for experienced R programmers who want structured R SQL learning.