16.5 C
London
Monday, July 7, 2025
HomeSASData Munging in SASSAS: How to Use the WHERE Operator in PROC SQL

SAS: How to Use the WHERE Operator in PROC SQL

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

You can use the WHERE operator in the PROC SQL statement in SAS to only return rows where certain conditions are met.

The following examples show how to use the WHERE operator in the following scenarios:

  • Select rows where one condition is met.
  • Select rows where one of several conditions are met.
  • Select rows where multiple conditions are met.

The following examples show how to use the WHERE operator in each scenario with the following dataset in SAS:

/*create dataset*/
data my_data;
    input team $ points;
    datalines;
A 12
A 14
A 15
A 18
B 31
B 32
C 35
C 36
C 40
D 28
E 20
E 21
;
run;

/*view dataset*/
proc print data=my_data;

Example 1: Select Rows Where One Condition is Met

The following code shows how to use the WHERE operator in the PROC SQL statement to select all rows in the dataset where the team is equal to A:

/*select all rows where team is equal to A*/
proc sql;
   select *
   from my_data
   where team = 'A';
quit;

The only rows returned are the ones where the team is equal to A.

Example 2: Select Rows Where One of Several Conditions are Met

The following code shows how to use the WHERE operator in the PROC SQL statement to select all rows in the dataset where the team is equal to A or points is greater than 30:

/*select all rows where team is equal to A or points is greater than 30*/
proc sql;
   select *
   from my_data
   where team = 'A' or points > 30;
quit;

The only rows returned are the ones where the team is equal to A or points is greater than 30:

Example 3: Select Rows Where Multiple Conditions are Met

The following code shows how to use the WHERE operator in the PROC SQL statement to select all rows in the dataset where the team is equal to A and points is greater than 13:

/*select all rows where team is equal to A and points is greater than 13*/
proc sql;
   select *
   from my_data
   where team = 'A' and points > 13;
quit;

The only rows returned are the ones where the team is equal to A and points is greater than 13:

Additional Resources

The following tutorials explain how to perform other common tasks in SAS:

SAS: How to Use the IN Operator in PROC SQL
SAS: How to Use UNION in PROC SQL
SAS: How to Use EXCEPT in PROC SQL

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories