how does sas handle missing values in a merge? : Sas programming

0 Answers  

---

What are the default statistics for means procedure?

0 Answers  

---

Explain substr function?

0 Answers  

---

What is the one statement to set the criteria of data that can be coded in any step?

4 Answers  

---

If you could design your ideal job, what would it look like?

0 Answers   Oracle,

---

What is the order of evaluation of the comparison operators: + - * /** ()?

3 Answers   Quintiles,

---

what is the difference between x=substr(name,1,2); and substr(name,1,2)='x';

3 Answers   HSBC,

---

To what type of programms have you used scratch macros?

0 Answers   Novartis,

---

differnce between 8.2 and 9.1.3

1 Answers  

---

What is the difference between informat and format statement?

1 Answers  

---

in data set200 observation how to take 110,150,170 using sql procedure?

7 Answers   Accenture,

---

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.

0 Answers  

---