Like this?
proc sql;
select HAVE1.*
, HAVE2.NSAID_Date
, HAVE2.NSAID
, HAVE3.NSAID_freq_Date
, HAVE3.FREQ
, NSAID_Date -DM_Med_Date as DateLength_DM_Med_VS_NSAID
, NSAID_freq_Date-DM_Med_Date as DateLength_DM_Med_VS_NSAID_freq
from HAVE1, HAVE2, HAVE3;
quit;
MRN
DM_Med_Date
DM_Med
NSAID_Date
NSAID
NSAID_freq_Date
freq
DateLength_DM_Med_VS_NSAID
DateLength_DM_Med_VS_NSAID_freq
CGMHLK0001
2014-06-18
1
2014-06-18
1
2014-06-18
1
0
0
CGMHLK0001
2014-06-18
1
2014-07-09
1
2014-06-18
1
21
0
CGMHLK0001
2014-06-18
1
2014-06-24
1
2014-06-18
1
6
0
CGMHLK0001
2014-06-18
1
2014-07-09
1
2014-06-18
1
21
0
CGMHLK0001
2014-06-18
1
2014-06-18
1
2014-07-09
2
0
21
CGMHLK0001
2014-06-18
1
2014-07-09
1
2014-07-09
2
21
21
CGMHLK0001
2014-06-18
1
2014-06-24
1
2014-07-09
2
6
21
CGMHLK0001
2014-06-18
1
2014-07-09
1
2014-07-09
2
21
21
CGMHLK0001
2014-06-18
1
2014-06-18
1
2014-06-24
1
0
6
CGMHLK0001
2014-06-18
1
2014-07-09
1
2014-06-24
1
21
6
CGMHLK0001
2014-06-18
1
2014-06-24
1
2014-06-24
1
6
6
CGMHLK0001
2014-06-18
1
2014-07-09
1
2014-06-24
1
21
6
CGMHLK0001
2014-06-18
1
2014-06-18
1
2014-07-09
1
0
21
CGMHLK0001
2014-06-18
1
2014-07-09
1
2014-07-09
1
21
21
CGMHLK0001
2014-06-18
1
2014-06-24
1
2014-07-09
1
6
21
CGMHLK0001
2014-06-18
1
2014-07-09
1
2014-07-09
1
21
21
CGMHLK0002
2014-07-09
12
2014-06-18
1
2014-06-18
1
-21
-21
CGMHLK0002
2014-07-09
12
2014-07-09
1
2014-06-18
1
0
-21
CGMHLK0002
2014-07-09
12
2014-06-24
1
2014-06-18
1
-15
-21
CGMHLK0002
2014-07-09
12
2014-07-09
1
2014-06-18
1
0
-21
CGMHLK0002
2014-07-09
12
2014-06-18
1
2014-07-09
2
-21
0
CGMHLK0002
2014-07-09
12
2014-07-09
1
2014-07-09
2
0
0
CGMHLK0002
2014-07-09
12
2014-06-24
1
2014-07-09
2
-15
0
CGMHLK0002
2014-07-09
12
2014-07-09
1
2014-07-09
2
0
0
CGMHLK0002
2014-07-09
12
2014-06-18
1
2014-06-24
1
-21
-15
CGMHLK0002
2014-07-09
12
2014-07-09
1
2014-06-24
1
0
-15
CGMHLK0002
2014-07-09
12
2014-06-24
1
2014-06-24
1
-15
-15
CGMHLK0002
2014-07-09
12
2014-07-09
1
2014-06-24
1
0
-15
CGMHLK0002
2014-07-09
12
2014-06-18
1
2014-07-09
1
-21
0
CGMHLK0002
2014-07-09
12
2014-07-09
1
2014-07-09
1
0
0
CGMHLK0002
2014-07-09
12
2014-06-24
1
2014-07-09
1
-15
0
CGMHLK0002
2014-07-09
12
2014-07-09
1
2014-07-09
1
0
0
CGMHLK0003
2014-06-24
1
2014-06-18
1
2014-06-18
1
-6
-6
CGMHLK0003
2014-06-24
1
2014-07-09
1
2014-06-18
1
15
-6
CGMHLK0003
2014-06-24
1
2014-06-24
1
2014-06-18
1
0
-6
CGMHLK0003
2014-06-24
1
2014-07-09
1
2014-06-18
1
15
-6
CGMHLK0003
2014-06-24
1
2014-06-18
1
2014-07-09
2
-6
15
CGMHLK0003
2014-06-24
1
2014-07-09
1
2014-07-09
2
15
15
CGMHLK0003
2014-06-24
1
2014-06-24
1
2014-07-09
2
0
15
CGMHLK0003
2014-06-24
1
2014-07-09
1
2014-07-09
2
15
15
CGMHLK0003
2014-06-24
1
2014-06-18
1
2014-06-24
1
-6
0
CGMHLK0003
2014-06-24
1
2014-07-09
1
2014-06-24
1
15
0
CGMHLK0003
2014-06-24
1
2014-06-24
1
2014-06-24
1
0
0
CGMHLK0003
2014-06-24
1
2014-07-09
1
2014-06-24
1
15
0
CGMHLK0003
2014-06-24
1
2014-06-18
1
2014-07-09
1
-6
15
CGMHLK0003
2014-06-24
1
2014-07-09
1
2014-07-09
1
15
15
CGMHLK0003
2014-06-24
1
2014-06-24
1
2014-07-09
1
0
15
CGMHLK0003
2014-06-24
1
2014-07-09
1
2014-07-09
1
15
15
CGMHLK0004
2014-07-09
12
2014-06-18
1
2014-06-18
1
-21
-21
CGMHLK0004
2014-07-09
12
2014-07-09
1
2014-06-18
1
0
-21
CGMHLK0004
2014-07-09
12
2014-06-24
1
2014-06-18
1
-15
-21
CGMHLK0004
2014-07-09
12
2014-07-09
1
2014-06-18
1
0
-21
CGMHLK0004
2014-07-09
12
2014-06-18
1
2014-07-09
2
-21
0
CGMHLK0004
2014-07-09
12
2014-07-09
1
2014-07-09
2
0
0
CGMHLK0004
2014-07-09
12
2014-06-24
1
2014-07-09
2
-15
0
CGMHLK0004
2014-07-09
12
2014-07-09
1
2014-07-09
2
0
0
CGMHLK0004
2014-07-09
12
2014-06-18
1
2014-06-24
1
-21
-15
CGMHLK0004
2014-07-09
12
2014-07-09
1
2014-06-24
1
0
-15
CGMHLK0004
2014-07-09
12
2014-06-24
1
2014-06-24
1
-15
-15
CGMHLK0004
2014-07-09
12
2014-07-09
1
2014-06-24
1
0
-15
CGMHLK0004
2014-07-09
12
2014-06-18
1
2014-07-09
1
-21
0
CGMHLK0004
2014-07-09
12
2014-07-09
1
2014-07-09
1
0
0
CGMHLK0004
2014-07-09
12
2014-06-24
1
2014-07-09
1
-15
0
CGMHLK0004
2014-07-09
12
2014-07-09
1
2014-07-09
1
0
0
... View more