Answer / 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.

Answer / gangadhar

Make sure you apply the following rules when determining
which approach to take when subsetting your data set using
the DATA step. If your subset condition does not meet the
requirements below, then the WHERE and IF statements should
produce identical results. For cases such as this, use the
WHERE statement since it is more efficient. Note that
having both WHERE and IF statements within the same DATA
step has a cumulative effect.
• Can use WHERE statement when only specifying data
set variables
• Use IF statement when specifying automatic
variables or new variables created within DATA step
• Use IF statement when specifying FIRST.BY or LAST.
BY variables
• Use IF statement when specifying data set options
such as OBS = , POINT = or FIRSTOBS =
• In general, use IF statement when merging data sets
to apply subset condition after merging data set
• Use WHERE statement when specifying indexes

Answer / 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

Answer / chowdary vamsi

Where:first chick the condensation ofter checking the errors
if:first chick the errors after chick the condensation
where :take more processing time compare if
if take less processing time compare to where.

Answer / 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

Answer / ramesh

Two Where coditions can be used at a time to one variable
Two IF conditions can not be used at a time to one variable

In Where condition either <= OR =< can be used
In If condition only <= can be used.

'where' is Data set options and statement
'If' is only Statement

What is highest missing value for numeric?

1 Answers  

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

0 Answers  

Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables.

7 Answers   Accenture,

Mention what is SAS data set?

0 Answers  

What is SAS? is it a software just for use or we can creat something over there?

5 Answers   Cognizant,

how can u extract,transform and loading?

2 Answers   CitiGroup,

what is the use of LRECL option.

1 Answers   L&T,

Why is SAS considered self-documenting?

1 Answers   Quintiles,

i have a macro variable var1,var2. i want titles for the each macro variable separately? how it is possible?

1 Answers   L&T,

How do i read multiple spaces in datasets?

4 Answers   Quintiles,

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set?

2 Answers  

What are the applications primarily used by business analyst? : Sas-bi

0 Answers