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


Please Help Members By Posting Answers For Below Questions

Mention common programming errors committed in sas ?

852


Explain append procedure?

843


AE datasets names? how many types?

2264


How would you invoke a macro? : sas-macro

791


How to test the debugging in sas?

873


How to create an external dataset with sas code?

807


How do you use the do loop if you don’t know how many times you should execute the do loop?

1016


explain the function of substr in sas? : Sas-administrator

784


In proc transpose and data step with arrays which one you pick?

2800


What do you know about sas data set?

815


how does sas handle missing values in a merge? : Sas programming

779


what is the function of catx syntax? : Sas-administrator

872


what is the Population you used in your project, is it ITT or PP?

2485


what is the use of proc contents and proc print in sas? : Sas-administrator

842


How many data types are there in SAS?

818