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
- 5025 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 |
How would you identify a macro variable? : sas-macro
What are the five ways to do a table lookup in sas? : sas-grid-administration
What is the difference between an informat and a format? Name three informats or formats.
How can I remove header from output data set?
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
What is the purpose of the trailing and How would you use them?
what is the use of LRECL option.
What SAS statements would you code to read an external raw data file to a DATA step?
how to intersect the tables by using PROC MIXED?
Explain how merging helps to combine data sets.
How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?
6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK
Teradata 
