Building Tables from Scratch in R: Livestream Recording

*Note: I may be compensated, but you will not be charged, if you click on the links below.
🔵Download the slides from the lectures in the series here: buff.ly/3QMqAh8
🟠Want to participate in our upcoming free online workshop “Application Basics”? Details are here: buff.ly/43SfASM
🟢Check out all the lectures in the series: buff.ly/44AtKZv

This livestream event was originally recorded on September 12, 2023.

💡 Read about all our online educational resources: buff.ly/45amjaQ
💡 Learn more about online group mentoring program: buff.ly/3Sw4Fsa
💡 Try the “Applications Basics” course 📣 USE DISCOUNT CODE lemon55 FOR 75% OFF REGULAR PRICE! 📣 buff.ly/3vyx7Ad
💡 EXCLUSIVE! Download 9-page list of applications terminology with definitions along with flash cards from the course! buff.ly/43yEUgT

WANT TO SUPPORT MONIKA ON SOCIAL MEDIA?
🔵Sign up for Monika’s weekly data science e-newsletter: buff.ly/2UYW60l
🟠Follow/connect with Monika on LinkedIn: www.linkedin.com/in/dethwench/
🟢Try Monika’s courses on LinkedIn Learning: linkedin-learning.pxf.io/NKN0JO
⚫Follow Monika on Twitter: twitter.com/dethwench
🟣Follow Monika on Instagram: www.instagram.com/dethwench/?hl=en
🟤Follow Monika on Facebook: www.facebook.com/DWProfSvcs

💜Intro and outro by CJ Hutchings, recorded exclusively for DPS. Check out more of CJ’s music and art here: dethwench.com/cjhutchings/
❤️Got too much work? You can hire Ebenezer as YOUR executive assistant, too! He is highly competent and reliable. Contact him here: ebdado.netlify.app/

Links/Timestamps from Video:
01:10 What SAS is good at – and NOT good at!
01:50 Monika’s book on data warehousing in SAS: buff.ly/31Hz1mg
03:34 Monika has an imaginary conversation with SAS to explain the Output Delivery System (ODS) 🤣
05:17 Come to Monika’s free online workshop in Application Basics! buff.ly/3vyx7Ad
06:58 How do you refer to columns in datasets in SAS and in R? Do you use names…or numbers?
08:50 How do you refer to datasets in SAS and in R? How does the software know which dataset you are talking about when you refer to variables?
12:36 Shift to R – Import dataframe
14:40 What is “Table 1”? We will build it!
17:40 Demonstration of doing a one-way frequency in R
19:46 Overall strategy for making the table in R out of nothing
21:40 First step: Making vectors for columns
23:30 Using the rep command
25:25 Fusing the vectors together into the blank table!
26:00 Explanation of how to refer to columns, rows, and cells in R using both names and numerical referencing
27:50 Filling in top row of the table using one-way frequencies
34:04 Filling in the rest of the table with one- and two-way frequencies
39:18 Filling in a row using a flag
41:20 Exporting the table out of R as a *.csv
44:06 Summar