mycsg SASnR2 Lessons

⚡ Move from reading to hands-on practice with SAS, R, or Combo access. Explore plans

🎓 Online training class for Clinical R programming batch starts on Monday, 04May2026.

SASnR Lessons

Log in is required to view the content of the lessons.

Order	Title
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
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
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
3201	Apply Basic Numeric Functions
3210	Round Numeric Values
3214	Cumulative Sum, Mean, and Product
3304	Extract Day, Month, Year, Weekday from Date
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
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
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