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
describe about metadata object? : Sas-di
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
What are the statements that are executed only?
If money were no object, what would you like to do?
Give e an example of..
Explain the difference between nodup and nodupkey options?
what is null hypothesis? why do you consider that?
what is hash files in sas and why we are using this one in sas?
Explain the purpose of substr functions in sas programming.
What are the differences between proc means and proc summary?
What are the different servers in sas? : sas-grid-administration
Describe the ways in which you can create macro variables? : sas-macro
To what type of programms have you used scratch macros?
What are the applications primarily used by business analyst? : Sas-bi
What are the functions used for character handling?