How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set?

2 Answers  

---

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

0 Answers  

---

Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

0 Answers  

---

How would you code a merge that will keep only the observations that have matches from both sets?

5 Answers  

---

What is univariate n where it can be used n how...?

2 Answers  

---

What is the purpose of the trailing @? The @@? How would you use them?

10 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.

1 Answers  

---

how to generate the test data in sas without input data? : Sas-administrator

0 Answers  

---

How to get the repeated values by using sql in sas ?

2 Answers  

---

How to create a permanent sas data set?

0 Answers  

---

wt is a-z and a--z?

3 Answers   Accenture,

---

How do dates work in sas?

0 Answers  

---