In the SAS Data step what is the difference between the
subsetting done by Where and subsetting done by If?

Answer Posted / k

There is difference between how SAS handles IF and WHERE
conditions. The 'WHERE' condition is applied on data before
they enter Program Data Vector (PDV) and in case of 'IF' it
is applied after data comes out from PDV. Now, if you have
created a variable in the same data step using
Where : the created variable will not be applied condition.
IF: the created variable will be subjected to the condition
applied.

Is This Answer Correct ?    19 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the default statistics for means procedure?

923


Name few SAS functions?

901


Differentiate between sas functions and sas procedures.

905


How we can create SAS USER DEFINED CODE?

1877


What do the put and input function do?

819


What are the statements in proc sql?

854


What is the difference between proportion and average?

3052


How many ways to overcome a missing values???

2587


is data integration and etl programming is same? : Sas-di

835


what is the use of proc contents and proc print in sas? : Sas-administrator

856


Compare sas with other data analytics tools.

832


What sas features do you use to check errors and data validation?

993


How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2638


Explain the difference between using drop = data set option in set and data statement?

958


If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

947