if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

0 Answers   CTS,

---

what is the main difference between rename and label? (don't say that they both perform the same function).

11 Answers   Parexel,

---

Diff between proc sql merge and join?

1 Answers   HSBC, Sristek,

---

what is the Population you used in your project, is it ITT or PP?

0 Answers   Accenture, Quintiles,

---

What is your weekness? I am confuse what to say about this question. so can u give some answer which can be yur strenght.

1 Answers   Cipla,

---

---

What are the efficacy variables in your study?

2 Answers   Accenture, Quintiles,

---

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  

---

Explain the message 'Merge has one or more datasets with repeats of by variables'.

5 Answers  

---

Explain the main difference between the sas procedures and functions? : Sas-administrator

0 Answers  

---

What are all the problems you faced while validating tables and reports?

0 Answers   Accenture, Quintiles,

---

Name any two sas spawners? : sas-grid-administration

0 Answers  

---

what is difference in window SAS & Unix SAS.....how do define working environment in both???

1 Answers   JPMorgan Chase,

---