How do i read multiple spaces in datasets?

4 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  

---

what are different analysis datasets you created and what are the new variables created

2 Answers   Sciformix,

---

what is SAS/Graph?

1 Answers   CitiGroup, NTPC,

---

How do you control the number of observations and/or variables read or written?

0 Answers  

---

What are the different operating system platforms in which we can use sas? : sas-grid-administration

0 Answers  

---

i have a null dataset with 20 variables. i want to upload the variables which contain name like a or k or anything in another dataset.how can we create the dataset?

3 Answers   L&T,

---

what is the use of proc sql?

5 Answers   CitiGroup,

---

I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?

6 Answers  

---

What is PDV?

0 Answers  

---

What do you understand by the term Normal Distribution?

0 Answers  

---

Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT

0 Answers  

---