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
What are the default statistics for means procedure?
Name few SAS functions?
Differentiate between sas functions and sas procedures.
How we can create SAS USER DEFINED CODE?
What do the put and input function do?
What are the statements in proc sql?
What is the difference between proportion and average?
How many ways to overcome a missing values???
is data integration and etl programming is same? : Sas-di
what is the use of proc contents and proc print in sas? : Sas-administrator
Compare sas with other data analytics tools.
What sas features do you use to check errors and data validation?
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?
Explain the difference between using drop = data set option in set and data statement?
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?