From the course: SAS® 9.4 Cert Prep: Part 03 Exploring and Validating Data

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Demo: Filtering rows with basic operators

Demo: Filtering rows with basic operators - SAS Tutorial

From the course: SAS® 9.4 Cert Prep: Part 03 Exploring and Validating Data

Start my 1-month free trial Buy for my team

Demo: Filtering rows with basic operators

“

- [Instructor] In this demo we'll write several different where expressions to filter the data in the storm summary table. I'll start by completing the proc print statement to read the storm summary table. So let's say we would like to print only those rows where MaxWindMPH is greater than 156. This actually represents category five storms, so I'll start by typing a where keyword, and then the column name MaxWindMPH and greater than or equal to, and just the numeric constant 156. Because it is a numeric constant we don't quote the value. I'll run that program and in our output we can see that all of the values for MaxWindMPH are greater than or equal to 156, another helpful thing to point out, is in the log it will tell us exactly how many observations or rows met the criteria that was provided in the where statement. Let's go back to the program. This time I'll change the where statement, let's say I only want to look at…

Contents