SAS has provided a helpful comparison chart that shows when you should use the WHERE and IF statements in SAS datastep programming?

...if your subset condition includes automatic variables or new variables created within the DATA step, then you must use the IF statement instead of the WHERE statement.