Where and If statements both are same only used for data mining and cleaning but few key differences are there which are arranged in tabular manner.
| S. No | Where statement | If statement |
| 1 | Used for data Mining | Used for data Mining |
| 2. | Cannot create new variable in SAS | Can create new variable in SAS |
| 3. | Can apply in proc steps directly in SAS | Can not apply in proc steps in SAS |
| 4 | Can apply in operators like between | Can not apply in operators like between |
| 5. | Can not apply in multiple statements | Can apply in multiple statements in SAS so many times we will write if statements |
| 6 | Only filtered observations read from filtered data | All observations are read from input data |
All those steps are cleared by using sashelp.class data which are by default present in the SAS library. It’s very tricky and useful difference.
SAS Certification Course Training Online
We offer best SAS Certification Course Training Online in India and Aboard and you can experts in analyses and data and report on data and export result to these format like Excel, PDF, HTML and understand the concept of the SAS programming language. Learn Full SAS Course Online from Durga Online Trainer.
You can join also online classes-