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
Mention common programming errors committed in sas ?
Explain append procedure?
AE datasets names? how many types?
How would you invoke a macro? : sas-macro
How to test the debugging in sas?
How to create an external dataset with sas code?
How do you use the do loop if you don’t know how many times you should execute the do loop?
explain the function of substr in sas? : Sas-administrator
In proc transpose and data step with arrays which one you pick?
What do you know about sas data set?
how does sas handle missing values in a merge? : Sas programming
what is the function of catx syntax? : Sas-administrator
what is the Population you used in your project, is it ITT or PP?
what is the use of proc contents and proc print in sas? : Sas-administrator
How many data types are there in SAS?