Data Munging in SAS
SAS: How to Use IF Statement in PROC SQL
While it’s not possible to use an IF statement in PROC SQL in SAS, you can use the CASE operator to define the values...
Data Munging in SAS
SAS: How to Use CONTAINS in PROC SQL
You can use the CONTAINS operator in the PROC SQL statement in SAS to only return rows where a variable in a dataset contains...
Descriptive Statistics in SAS
SAS: How to Use PROC FREQ with WHERE Statement
You can use the following basic syntax to use a WHERE statement within PROC FREQ in SAS:
proc freq data=my_data;
where var1...
Data Munging in SAS
SAS: How to Use HAVING Clause Within PROC SQL
You can use the HAVING clause within PROC SQL in SAS to filter for rows that meet a certain condition.
Note the subtle difference between...
Data Munging in SAS
SAS: How to Use UPDATE Within PROC SQL
You can use the UPDATE statement within PROC SQL in SAS to update the values in one or more columns of dataset.
Here are the...
Data Munging in SAS
How to Use the RETAIN Statement in SAS (With Examples)
You can use the RETAIN statement in SAS to specify some variable that should not have its value set to missing at the beginning...
Data Munging in SAS
SAS: How to Use a “NOT IN” Operator
You can use the NOT IN operator in SAS to return only the rows where a variable does not have a value in some...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read