Select Page

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. NoWhere statementIf statement
1Used for data MiningUsed for data Mining
2.Cannot create new variable in SASCan create new variable in SAS
3.Can apply in proc steps directly in SASCan not apply in proc steps in SAS
4Can apply in operators like betweenCan not apply in operators like between
5.Can not apply in multiple statementsCan apply in multiple statements in SAS so many times we will write if statements
6Only filtered observations read from filtered dataAll 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-

SAS Certification Course

Clinical SAS Online Course

DATA Science Course

Contact us Durga Trainer

Power BI Online Course