Data Munging in SAS

Here are the two most common ways to create new variables in SAS: Method 1: Create Variables from Scratch data original_data; input…

You can use the SUBSTR function in SAS to extract a portion of a string. This function uses the following basic syntax:…

You can use the datalines statement in SAS to quickly create a new dataset from scratch. You can use the following basic…

You can use the DAY, MONTH, and YEAR functions in SAS to extract the day, month, and year as numeric values from…

You can use the following methods to convert strings to uppercase, lowercase, and proper case in SAS: Method 1: Convert String to…

Here are the three most common ways to delete rows in SAS: Method 1: Delete Rows Based on One Condition data new_data;…

You can use PROC TRANSPOSE in SAS to quickly transpose a dataset from a long format to a wide format. This function…

A dummy variable is a type of variable that we create in regression analysis so that we can represent a categorical variable…

You can use the RETAIN function in SAS to quickly reorder the variables in a dataset. Here are the three most common…

You can use the COALESCE function in SAS to return the first non-missing value in each row of a dataset. The following…