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
- 4916 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 does sas handle missing values in sort order? : Sas programming
What is program data vector (pdv)?
What are the differences between sum function and using “+” operator?
how can you put a "trace" in your program? : Sas programming
What is the difference between proportion and average?
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
what is sas application server? : Sas-di
why is a stop statement needed for the point=option on a set statement? : Sas programming
Enlist the syntax rules followed in sas statements.
What is SAS? What are the functions does it performs?
what is broad cast agent? : Sas-bi
What are common programming errors committed in sas
How to specify variables to be processed by the freq procedure?
What is substr function?
what are the considerations when picking a SAS/STAT procedure?
