Interested to Buy Any Domain ? << Click Here >> for more details...
Under what circumstances would you code a SELECT construct
instead of IF statements?
- 4 Answers
- 15648 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sumalatha.ch
select statement is reduced cpu time.and make the programme
easier to read and debug
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 3nadh
Select Statement executes one of several statements or
group of statements.
If Statement :- Continues processing only those obs that
meet the condition.
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / jothi sankar
--> When renaming of varibales during getting data itself,
--> new varible creation by combining already existing
varibales(eg: Name = FName + LName) to reduce memory usage
--> When nested conditions are less and getting more %
records from base
| Is This Answer Correct ? | 0 Yes | 4 No |
i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?
Which is the best training Institute for SAS Business Intelligence course?
what is business intelligence? : Sas-bi
What is the difference between match merge and one to one merge?
What is the purpose of _character_ and _numeric_?
Explain how merging helps to combine data sets.
In which format does Date stores in sas..? What is the use of DATE in SAS.?
what techniques and/or procs do you use for tables? : Sas programming
What is the Program Data Vector (PDV) and What are its functions?
What is the use of PROC gplot?
What are the special input delimiters used in SAS?
how to shift the rows to cols? eg: i have like field1 field2 field3 10 20 20 this should be displayed as field1 10 field2 20 field3 30 (without the obs col) how do this?can i use transpose or tell me suitable way to do this?
Teradata 
