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

Explain what Proc glm does?

643


What is the basic structure of a sas program?

604


for whom is sas data integration studio designed? : Sas-di

560


what is the difference between floor and ceil functions in sas? : Sas-administrator

708


how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2295






Tell e how how dealt with..

1777


How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

1889


how does sas handle missing values in functions? : Sas programming

606


How to create list output for cross-tabulations in proc freq?

626


Which function is used to count the number of intervals between two sas dates?

576


Describe the ways in which you can create macro variables? : sas-macro

580


What is the difference between nodupkey and nodup options?

599


What is the use of %include statement?

625


Mention what is PROC in SAS?

605


what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

637