In the SAS Data step what is the difference between the
subsetting done by Where and subsetting done by If?
- 6 Answers
- 17939 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
What is PROC in SAS?
how to change the execute of macro
Briefly explain input and put function?
What is the length assigned to the target variable by the scan function?
What is the basic structure of the SAS base program?
Differentiate between sas functions and sas procedures.
describe how to adjust the performance of data integrator? : Sas-di
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
what techniques and/or procs do you use for tables? : Sas programming
Mention the validation tools used in SAS?
how can you put a "trace" in your program? : Sas programming
For what purpose would you use the RETAIN statement?
how do you debug and test your sas programs? : Sas programming
What is a macro routine?
What areas of SAS are you most interested in?
