| 0110 | Install an R package | |
| 0120 | Load an R package (library) | |
| 1000 | Create Sample Data | |
| 1100 | Create a copy of an existing dataset | |
| 1200 | Subset Observations | |
| 1300 | Subset variables | |
| 1400 | Subset observations and variables | |
| 1500 | Renaming variables | |
| 1501 | Convert all the variable names to uppercase | |
| 1600 | Adding new variables | |
| 1700 | Appending datasets | |
| 1800 | Merging datasets | |
| 1850 | Merging datasets- select unmatched records | |
| 1860 | Merging datasets - cartesian product | |
| 1865 | conditional logic - case_when - .default and missing values | |
| 1870 | conditional logic - if_else | |
| 1875 | conditional logic - if_else - nested conditions | |
| 1900 | Sorting observations | |
| 1901 | Sort Order with Missing Values | |
| 2000 | Fetching Frequencies | |
| 2050 | Cross-Tabulation: Two-Way Frequency Table | |
| 2100 | Descriptive statistics for numeric variables | |
| 2110 | Summarize Age by Treatment Group with Descriptive Statistics | |
| 2200 | First dot concept | |
| 2210 | Last dot concept | |
| 2220 | First dot and last dot concept | |
| 2250 | LAG: Access the Previous Row's Value | |
| 2260 | LEAD: Access the Next Row's Value | |
| 2270 | LAG Within BY Groups | |
| 2300 | Handling duplicates | |
| 2400 | Transpose data - long to wide | |
| 2500 | Transpose data - wide to long | |
| 2600 | Arrays-repeat same logic on multiple variables | |
| 2610 | Arrays - Example - replace a text value in all character variables | |
| 2611 | Arrays - Example - replace a value in all numeric variables | |
| 2612 | Arrays - Example - replace a value in all numeric and character variables | |
| 2700 | Retain first value of a subject onto other records | |
| 2701 | Retain last non-missing value | |
| 2702 | Retain minimum score upto the current observation | |
| 2703 | Retain maximum score upto the current observation | |
| 2705 | Retain - Concatenate character results into a single value in a group | |
| 2810 | Replicating the concept of usage of loops for dummy data creation | |
| 2900 | Replicate PROC FORMAT Using Named Vectors in R | |
| 3001 | Reading Files Using Path References | |
| 3100 | Character Functions | |
| 3105 | Compress or remove specific characters | |
| 3190 | Count Missing Values in Selected Variables | |
| 3191 | Convert Between Character and Numeric Variables | |
| 3193 | Keep Only Variables with Non-missing Values Across Dataset | |
| 3195 | COALESCE: Pick the First Non-Missing Value | |
| 3201 | Apply Basic Numeric Functions | |
| 3210 | Round Numeric Values | |
| 3214 | Cumulative Sum, Mean, and Product | |
| 3304 | Extract Day, Month, Year, Weekday from Date | |
| 3310 | Calculate the Difference Between Two Dates | |
| 3320 | Add an Interval to a Date | |
| 3330 | Convert Character Strings to Dates | |
| 3340 | Convert Dates to Formatted Character Strings | |
| 3350 | Extract Date and Time Parts from a Datetime Value | |
| 3407 | Find Maximum Value Across Multiple Variables in Each Row | |
| 3601 | Apply attributes to variables | |
| 3710 | Mimicking the behavior of PROC CONTENTS | |
| 3800 | Compare datasets | |
| 4010 | Import data from Excel workbooks - CSV | |
| 4015 | Import data from Excel workbooks - XLSX | |
| 4020 | Import data from Excel workbooks - XLS | |
| 4025 | Export data to Excel workbook | |
| 4030 | Read SAS Datasets (.sas7bdat) in R | |
| 4035 | Write SAS Transport Files (.xpt) | |
| 5100 | Create a macro variable and use it in open code | |
| 5103 | Create a macro variable to store list of values and use it in open code | |
| 5200 | Define and Call a Macro with Parameters | |
| 5300 | Loop Inside a Macro | |
| 5400 | Conditional Logic in Macros | |
| 6100 | Select Distinct Values Using SQL | |
| 6200 | Join Datasets Using SQL | |
| 6300 | Filter Using a Subquery | |
| 7100 | Advanced variable selection in tidyverse | |
| 7200 | Working with missing values (NA) in R | |
| 8100 | Get the list the files in a Directory/Folder to a dataset | |
| 8110 | List Files with Metadata: Size, Created and Modified Time | |
| 9105 | Detach an R package (unload from session) | |
| 9120 | Remove objects from the environment (rm / remove) | |
| 9310 | Read or load multiple xpt files or sas datasets simultaneously into R | |
| 9550 | Run multiple programs from a single file | |