What is LAG function?How is it used? can any one explain

3 Answers   TRE, Verinon Technology Solutions,

---

here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.

2 Answers   Cap Gemini, L&T,

---

What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?

3 Answers   TCS,

---

What is the purpose of _error_?

1 Answers   Quintiles,

---

What will calendar procedure do?

0 Answers  

---

What is the maximum length of the macro variable?

0 Answers  

---

How do handle working under pressure?

1 Answers   Oracle, Wipro,

---

if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??

6 Answers   Accenture,

---

What is your favorite all time computer book? Why?

0 Answers   Oracle,

---

Which is the Best SAS training Institute in Delhi NCR for SAS certification preparation

1 Answers   SAS,

---

calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15

6 Answers  

---

Explain the purpose of retain statement.

0 Answers  

---