In the SAS Data step what is the difference between the
subsetting done by Where and subsetting done by If?

Answer Posted / s.s.suresh

WHERE Statement can be only be used with variables in the
existing dataset where as IF statement can also be used raw
data as well

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I remove header from output data set?

2060


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

698


What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1222


How to create a permanent sas data set?

676


what is slowly changing dimension? : Sas-di

620






How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2381


what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

624


what do the pad and dim functions do? : Sas programming

563


explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

541


what is the difference between unique key and primary key? : Sas-di

593


In sas, what are the areas that you are most interested in? : sas-grid-administration

636


How substr function works in sas?

699


How do you convert basic cube to transaction cube and transaction cube to basic cube?

1770


what are sas/access and sas/connect? : Sas programming

546


how to read the variables in sas? : Sas-administrator

551