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.
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 |
What are the efficacy variables in your study?
2 Answers Accenture, Quintiles,
What is the role of administrative users? : sas-grid-administration
For what purpose(s) would use the RETURN statement?
proc means? proc sort? proc append? proc freq? proc print? proc content?
Mention what is PROC in SAS?
what is the function of catx syntax? : Sas-administrator
How we can create SAS USER DEFINED CODE?
Write a SAS macro to calculate number of numbers in an email address
What do the PUT and INPUT functions do?
how can you sort the dataset having millions of OBS(instead of sort procedure?
What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?
Name and describe three SAS functions that you have used, if any?