You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?

2 Answers  

---

What is a method to debug and test your SAS program?

0 Answers  

---

how we can call macros with in data step?

17 Answers   Allianz, ManPower,

---

What do you feel about hardcoding?

4 Answers   Oracle,

---

What was the last computer book you purchased? Why?

0 Answers   Oracle,

---

Do you know the features of sas?

0 Answers  

---

If you set a label in the data step and call a proc freq on the data, how do you display the data without the labels and just the variables.

1 Answers  

---

What is _n_?

23 Answers   Accenture,

---

What are symbol tables?Differemce between Local N Global Symbol tables.....

2 Answers   TCS,

---

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

1 Answers  

---

Describe the ways in which you can create a macro variable?

0 Answers  

---

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,

---