what do you mean by data staging area? : Sas-di

0 Answers  

---

Describe crosslist option in tables statement?

0 Answers  

---

How to write duplicate records into a separate dataset using sort?

4 Answers   HSBC,

---

What are the new features included in the new version of SAS Programming Language?

0 Answers  

---

how sas deals with business intelligence? : Sas-bi

0 Answers  

---

---

What is data _null_?

0 Answers  

---

Are you sensitive to code walk-throughs peer review or QC review?

0 Answers   Quintiles,

---

How do you test for missing values?

0 Answers   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.

1 Answers  

---

In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;

1 Answers  

---

For clinical entire study how many tables will create approx?

0 Answers   TCS,

---

. Which date advances a date, time or date/time value by a given interval?

8 Answers  

---