Hello,
I've got two data sets.
I'm trying to get these...
id,StartDate, Value,
001,01JUL2010, 6050
002,27MAY2010, 9050
003, 11DEC2010, 16500
into...
id, StartDate, EndDate, OtherValue
001, 01SEP2009,17DEC2009, 7500
001, 18DEC2009,29APR2010, 7000
001, 30APR2010,31DEC9999, 6000
002, 10MAY2010,16AUG2010, 11000
002, 17AUG2010,26NOV2010,10500
002, 27NOV2010,11APR2011,9500
002, 12APR2011,31DEC9999,9000
003, 01DEC2010,12JAN2011,20000
003, 13JAN2011, 25MAY2011,19500
003, 26MAY2011, 31DEC9999, 18990
and return the other value that would have been during that time...
id, StartDate, Value, OtherValue
001,01JUL2010, 6050, 6000
002,27MAY2010, 9050, 11000
003,11DEC2010, 16500, 20000
So I have a variable to merge on but the startdate variable in the first set needs to read in between the start and end date in the second one and then output the other value variable.
I'm not very experienced with any merging outside of indexing...
data name (index=( ));
set sample;
set sample2 key= /unique;
if _error_ then delete (or output...);
run;
Thanks in advance.
... View more