Under what circumstances would you code a SELECT construct
instead of IF statements?
Answer Posted / venkatesh.layam
when ever we wre do the task on puarticular variable select
works efficiently than if then else
And it will check immideatly and occupies less space.
it will give good shape out for data.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the default statistics that proc means produce?
what is null hypothesis? why do you consider that?
What would be the value of month at the end of data step execution and how many observations would be there?
what is broad cast agent? : Sas-bi
Differentiate between proc means and proc summary.
What are the limitations for memory allocation for SAS variables
Explain the purpose of substr functions in sas programming.
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
name some data transformation used in sas di? : Sas-di
Which command is used to perform sorting in sas program?
what has been your most common programming mistake? : Sas programming
Difference between informat and format?
What are the functions used for character handling?
How are numeric and character missing values represented internally?
What is maximum storage capability of SAS?