I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.

1 Answers  

---

How would you delete observations with duplicate keys?

13 Answers   Accenture,

---

What is the maximum length of the macro variable? : sas-macro

0 Answers  

---

What are symget and symput? : sas-macro

0 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 set to a second data set, and the non-matches of the right-most data set to a third data set?

2 Answers  

---

How would you invoke a macro? : sas-macro

0 Answers  

---

In ARRAY processing, what does the DIM function do?

0 Answers  

---

What is program data vector (pdv) and what are its functions?

0 Answers  

---

what are input dataset and output dataset options? : Sas programming

0 Answers  

---

Explain proc sort?

0 Answers  

---

do you need to know if there are any missing values? : Sas programming

0 Answers  

---

in ods is there any lib's

2 Answers   SAS,

---