In the SAS Data step what is the difference between the
subsetting done by Where and subsetting done by If?
- 6 Answers
- 17869 Views
- Cognizant, I also Faced
- E-Mail Answers
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
Did you used proc test? when?
What is the basic syntax style in SAS?
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
Explain proc univariate?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
Mention the validation tools used in SAS?
Have you ever used the SAS Debugger?
Tell me more about the parameters in macro? : sas-macro
what is metadata? : Sas-bi
explain the difference between proc means and proc summary?
What are the difference between ceil and floor functions in sas?
Explain how you can debug and test your SAS program?
Name any two sas spawners? : sas-grid-administration
describe about metadata object? : Sas-di
what are validation tools that are used in sas? : Sas-administrator
