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 do dates work in sas?

0 Answers  

---

how do u test a pros sql(works or not) without executing it?

1 Answers   DELL, HSBC,

---

HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES? WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?

3 Answers   Accenture, Novartis,

---

what is the difference between proc means and proc tabulate?

3 Answers   Cognizant, CTS,

---

Where do you use proc means over proc freq?

0 Answers  

---

my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?

2 Answers   Dr Reddys, Oracle,

---

what type of reports you are generating in your company...???

2 Answers   GSK GlaxoSmithKline,

---

what is the formula to measure Baseline

3 Answers   Sristek,

---

Tell me more about the parameters in macro? : sas-macro

0 Answers  

---

what is the Population you used in your project, is it ITT or PP?

0 Answers   Accenture, Quintiles,

---

how can you improve the performance of a query, If it is excuting very slowly?

2 Answers   Zensar,

---