Under what circumstances would you code a SELECT construct
instead of IF statements?
Answer Posted / sonu
The SELECT statement begins a SELECT group. SELECT groups contain WHEN statements that identify SAS statements that are executed when a particular condition is true. Use at least one WHEN statement in a SELECT group. An optional OTHERWISE statement specifies a statement to be executed if no WHEN condition is met. An END statement ends a SELECT group.
Null statements that are used in WHEN statements cause SAS to recognize a condition as true without taking further action. Null statements that are used in OTHERWISE statements prevent SAS from issuing an error message when all WHEN conditions are false.
Using Select-When improves processing efficiency and understandability in programs that needed to check a series of conditions for the same variable.
Use IF-THEN/ELSE statements for programs with few statements.
Using a subsetting IF statement without a THEN clause could be dangerous because it would process only those records that meet the condition specified in the IF clause.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the function of output statement in a SAS Program?
What does PROC print, and PROC contents do?
what are informats in sas? : Sas-administrator
How would you include common or reuse to be processed along with your statements?
How to create an external dataset with sas code?
what is business intelligence? : Sas-bi
What is PDV?
what is data access? : Sas-di
What are the default statistics that proc means produce?
Differences between where and if statement?
what other sas products have you used and consider yourself proficient in using? : Sas programming
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
What is your favorite all time computer book? Why?
what is sas metadata repository? : Sas-bi
explain about data integrator metadata reports? : Sas-di