Interested to Buy Any Domain ? << Click Here >> for more details...
In the SAS Data step what is the difference between the
subsetting done by Where and subsetting done by If?
- 6 Answers
- 19768 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What do the PUT and INPUT functions do?
what is business intelligence? : Sas-bi
Explain why double trailing @@ is used in input statement?
how many types of prompts are there? : Sas-bi
what is sas business intelligence? : Sas-bi
What is the use of the %include statement?
What is the difference between %put and symbolgen? : sas-macro
How are numeric and character missing values represented internally?
What sas features do you use to check errors and data validation?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
Mention some common errors that are usually committed in sas programming.
what are sas bi dashboard components? : Sas-bi
How long can a macro variable be? A token? : sas-macro
How would you invoke a macro? : sas-macro
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
