Data Munging in SAS

You can use the INTNX function in SAS to increment a date by a specific interval such as a day, week, month,…

You can use an IF-THEN-ELSE statement in SAS to return some value if some condition is true, else return another value if…

While it’s not possible to use an IF statement in PROC SQL in SAS, you can use the CASE operator to define…

You can use the CONTAINS operator in the PROC SQL statement in SAS to only return rows where a variable in a…

You can use the HAVING clause within PROC SQL in SAS to filter for rows that meet a certain condition. Note the…

You can use the UPDATE statement within PROC SQL in SAS to update the values in one or more columns of dataset.…

You can use the RETAIN statement in SAS to specify some variable that should not have its value set to missing at…

You can use the NOT IN operator in SAS to return only the rows where a variable does not have a value…

You can use the UNION operator in the PROC SQL statement in SAS to combine two datasets vertically. The following example shows…

You can use the LIKE operator in the PROC SQL statement in SAS to return rows where a variable in a dataset…