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

Answer Posted / govardhan bandari

IF-Works With New Variable
Where- Cant work With New Variables

IF-Works After PDV
Where-Works Before PDV

IF-in backend if process all the variable and it gives output based on condition
BUT
Where-process only conditionally met obseravtions

IF-Cant work with proceduers(except proc report with compute statement)
WHERE- work with proceduers

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

1842


please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

1661


Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1460


What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

712


what is hash files in sas and why we are using this one in sas?

1724






what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

605


What are the data types in sas?

604


Give e an example of..

1842


what is factor analysis? : Sas-administrator

609


How do you delete duplicate observations in sas?

571


it will become easy if uuu provide website linkssss and list of consultanciessssss

1526


State the difference between INFORMAT and FORMAT ?

591


Can you execute macro within another macro? : sas-macro

524


what are some good sas programming practices for processing very large data sets? : Sas programming

507


What is PROC in SAS?

602