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  

---

explain what is factor analysis? : Sas-administrator

0 Answers  

---

When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?

2 Answers   Accenture,

---

PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?

7 Answers   HP,

---

Which is Best Institute for learning SAS BASE & SAS BI in Hyderabad? Can anyone suggest me ?

5 Answers   ACC,

---

What are the Aggregate functions in SQL ?

2 Answers   AON,

---

How would you remove a format that has been permanently associated with a variable? ________________

5 Answers   Quintiles, TCS,

---

What do you know about symput and symget?

0 Answers  

---

What is SAS? What are the functions does it performs?

0 Answers  

---

how to perform paired t-test using Base/SAS & SAS/Stat?

2 Answers  

---

We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?

5 Answers  

---

How to get the repeated values by using sql in sas ?

2 Answers  

---