Hi there, I would like to merge two data sets when the date of the first data set is equal or the closet date to the second date set date. example data diagonsed;
input id diag_date mmddyy10. disease $;
format diag_date mmddyy10.;
datalines;
1 05/23/10 C
1 05/26/10 C
1 01/01/11 B
;
run;
data disharge;
input id dis_date mmddyy10. disease $ hospital$;
format dis_date mmddyy10.;
datalines;
1 05/21/10 C W
1 05/24/10 C N
1 05/25/10 C G
1 05/27/10 A R
1 05/29/10 C R
1 05/28/10 B W
1 09/15/10 D S
1 12/29/10 C F
1 12/31/10 A F
1 01/02/11 B S
1 01/05/11 B N
;
run;
/*i want to know the name of the hospital for those who were diagnosed for specific disease as in only diagnosed data set*/
/* The diagnosed date should be less or equal to the discharge date (minimum value=dis_date- diag_date) for the same type of disease in the first data set
*/
/* The correct answer should be as below:
id diag_date dis_date disease hospital
1 05/23/10 05/24/10 C N
1 05/26/10 05/29/10 C R
1 01/01/11 01/02/11 B S for the same type of disease in both data sets, difference_Date=min( dis_date - diag_date ) and it should equal zero or grater than zero. Could you please give me any suggestion. Thanks
... View more