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
- 5037 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How many ways to overcome a missing values???
Name few SAS functions?
What function CATX syntax does?
how will you locate the sas platform applications? : Sas-bi
what is the use of sas management console? : Sas-di
Which command is used to perform sorting in sas program?
why is sas considered self-documenting? : Sas programming
what is the use of proc sql? : Sas programming
what is sas database server? : Sas-di
how does sas handle missing values in sort order? : Sas programming
What are the five ways to do a table lookup in sas? : sas-grid-administration
how would you create multiple observations from a single observation? : Sas programming
What is the difference between proportion and average?
Describe the function and utility of the most difficult SAS macro that you have written?
what is sas business intelligence? : Sas-bi
