How to display duplicate observations in data?

1 Answers  

---

Diff between proc sql merge and join?

1 Answers   HSBC, Sristek,

---

How would you delete observations with duplicate keys?

13 Answers   Accenture,

---

what kind of variables are collected in AE dataset?

3 Answers   Accenture, Quintiles, SAS,

---

We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B

3 Answers  

---

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  

---

What is substr function?

0 Answers  

---

How would you delete duplicate observations?

9 Answers  

---

How to Rename Library?

3 Answers  

---

what is snowflake schema? : Sas-di

0 Answers  

---

what is the difference between informat$8. $char8.

3 Answers   SAS,

---

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

0 Answers   Axis Bank,

---