Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5100 Views
- I also Faced
- E-Mail Answers
Answer / kumaraswamy maduri
data new;
date1="31Dec2008"d;
run;
data new1;
input date1 date9. subj;
cards;
31dec2008 1
30dec2008 1
30dec2008 2
31dec2008 2
;
run;
proc sort;by date1;run;
data comp;
merge new(in=x) new1;
by date1;
if x;
run;
I have used the above code. I got perfect results.
Please correct me if I misunderstood your question.
| Is This Answer Correct ? | 6 Yes | 0 No |
Intern stastical programmer written test
How would you delete observations with duplicate keys?
How would you invoke a macro? : sas-macro
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?
What is the work of tranwrd function?
what are the best practices to process the large data sets in sas programming? : Sas-administrator
What are the data types does SAS contain?
How to test the debugging in sas?
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.
what is the use of LRECL option.
Diff between proc sql merge and join?
explain about various caches available in data integrator? : Sas-di
Teradata 
