Answer Posted / rushi

When you have a long series of mutually exclusive conditions and the comparison is numeric, using a SELECT group is slightly more efficient than using IF-THEN or IF-THEN-ELSE statements because CPU time is reduced.

The syntax for SELECT WHEN is as follows :

SELECT (condition);
WHEN (1) x=x;
WHEN (2) x=x*2;
OTHERWISE x=x-1;
END;

Example :

SELECT (str);
WHEN ('Sun') wage=wage*1.5;
WHEN ('Sat') wage=wage*1.3;
OTHERWISE DO;
wage=wage+1;
bonus=0;
END;
END;

How to limit decimal places for variable using proc means?

1113

---

What are the table names in oracle database...?

2757

---

If a variable contains letters or special characters, can it be numeric data type?

1213

---

What is the difference between SAS functions and procedures?

1152

---

What is program data vector (pdv)?

1296

---

What is the difference between the proc sql and data step?

1177

---

What will calendar procedure do?

1075

---

What is the differnce between SDTM 3.1.2 to 3.1.1 version

5077

---

what is the basic structure sas administrator? : Sas-administrator

1005

---

what are the types of interactive display types? : Sas-bi

1100

---

What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

1038

---

what are input dataset and output dataset options? : Sas programming

1105

---

what is function of retain statment

2041

---

why is a stop statement needed for the point=option on a set statement? : Sas programming

1086

---

what is the difference between floor and ceil functions in sas? : Sas-administrator

1262

---