what is the difference between if and where in sas?
Variables. While IF statement can be applied on automatic variables. WHERE statement applies the subset condition before merging the data sets, Whereas, IF statement applies the subset condition after merging the data sets.