Give e an example of..

0 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  

---

How do you convert basic cube to transaction cube and transaction cube to basic cube?

0 Answers  

---

What data sets do you need to produce the report?

2 Answers   Novartis,

---

what is conditional processing?

4 Answers   Accenture,

---

how do you test for missing values? : Sas programming

0 Answers  

---

Why double trailing @@ is used in input statement?

0 Answers  

---

In sas admin differentiate between roles and capabilities? : sas-grid-administration

0 Answers  

---

Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?

1 Answers  

---

what is a post baseline?

2 Answers   Accenture,

---

Does SAS ?Translate? (compile) or does it ?Interpret?? Explain.

10 Answers  

---

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?

0 Answers  

---