Data Munging in SAS
Data Munging in SAS
SAS: How to Use the IN Operator in PROC SQL
You can use the IN operator in the PROC SQL statement in SAS to only return rows where a variable in a dataset contains...
Data Munging in SAS
SAS: How to Use EXCEPT in PROC SQL
You can use the EXCEPT operator in the PROC SQL statement in SAS to only return rows from one dataset that are not in...
Data Munging in SAS
SAS: How to Use UNION in PROC SQL
You can use the UNION operator in the PROC SQL statement in SAS to combine two datasets vertically.
The following example shows how to use...
Data Munging in SAS
How to Check if Dataset Exists in SAS (With Example)
You can use the following macro in SAS to quickly check if a dataset exists:
%macro check_exists(data);
%if %sysfunc(exist(&data.)) %then %do;
...
Data Munging in SAS
How to Use the MAX Function in SAS (With Examples)
You can use the MAX function in SAS to find the largest value in a list of values.
Here are the two most common ways...
Data Munging in SAS
How to Use the MIN Function in SAS (With Examples)
You can use the MIN function in SAS to find the smallest value in a list of values.
Here are the two most common ways...
Data Munging in SAS
How to Convert Datetime to Date in SAS
The easiest way to convert a datetime to a date in SAS is to use the DATEPART function.
This function uses the following basic syntax:
date...
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