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;

Mention what is SAS data set?

1105

---

what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1194

---

what is intially documentation in sas?

4978

---

How would you define the end of a macro? : sas-macro

1054

---

In ARRAY processing, what does the DIM function do?

1127

---

what is SAS OPTIMIZATION?

2253

---

What are the features of SAS?

988

---

How would you identify a macro variable?

1047

---

What do you know about sas data set?

1044

---

What are the new features included in the new version of SAS Programming Language?

1166

---

What is the difference between where and if statement?

1083

---

What are the ways to do a “table lookup” in sas?

989

---

what is hierarchy flattening? : Sas-di

1041

---

Which are the statements whose placement in the data step is critical?

1204

---

what are the considerations when picking a SAS/STAT procedure?

3338

---