and calculate the difference between two dates 11:14 Monday, June 12, 2000 1 Obs id dob newdob intake newintak diff diffyr 1 101 560816 -1233 900911 11211 12444 34.0698 2 102 620816 958 900911 11211 10253 28.0712 3 103 591022 -71 900911 11211 11282 30.8884 4 104 521129 -2589 900925 11225 13814 37.8207 5 105 510804 -3072 910115 11337 14409 39.4497 6 106 550423 -1714 910115 11337 13051 35.7317 7 108 700530 3802 910205 11358 7556 20.6872 8 109 660916 2450 910205 11358 8908 24.3888 9 110 631001 1369 910219 11372 10003 27.3867 10 111 471111 -4434 910226 11379 15813 43.2936 11 112 590809 -145 910226 11379 11524 31.5510 12 113 490110 -4008 910326 11407 15415 42.2040 13 114 330412 -9760 910326 11407 21167 57.9521 14 115 511108 -2976 910402 11414 14390 39.3977 15 116 510220 -3237 910903 11568 14805 40.5339 16 117 620921 994 910903 11568 10574 28.9500 17 118 450821 -5246 910903 11568 16814 46.0342 18 119 511017 -2998 910917 11582 14580 39.9179 19 120 710218 4066 910924 11589 7523 20.5969 20 121 600701 182 910924 11589 11407 31.2307 21 122 570118 -1078 911015 11610 12688 34.7379 22 123 600710 191 911112 11638 11447 31.3402 23 124 720308 4450 . . . . 24 126 580201 -699 920107 11694 12393 33.9302 25 127 570909 -844 920109 11696 12540 34.3326 26 129 691007 3567 920121 11708 8141 22.2888 27 128 340929 -9225 920114 11701 20926 57.2923 and calculate the difference between two dates 11:14 Monday, June 12, 2000 2 Obs id dob newdob intake newintak diff diffyr 1 101 560816 August 16, 1956 900911 09/11/90 12444 34.0698 2 102 620816 August 16, 1962 900911 09/11/90 10253 28.0712 3 103 591022 October 22, 1959 900911 09/11/90 11282 30.8884 4 104 521129 November 29, 1952 900925 09/25/90 13814 37.8207 5 105 510804 August 4, 1951 910115 01/15/91 14409 39.4497 6 106 550423 April 23, 1955 910115 01/15/91 13051 35.7317 7 108 700530 May 30, 1970 910205 02/05/91 7556 20.6872 8 109 660916 September 16, 1966 910205 02/05/91 8908 24.3888 9 110 631001 October 1, 1963 910219 02/19/91 10003 27.3867 10 111 471111 November 11, 1947 910226 02/26/91 15813 43.2936 11 112 590809 August 9, 1959 910226 02/26/91 11524 31.5510 12 113 490110 January 10, 1949 910326 03/26/91 15415 42.2040 13 114 330412 April 12, 1933 910326 03/26/91 21167 57.9521 14 115 511108 November 8, 1951 910402 04/02/91 14390 39.3977 15 116 510220 February 20, 1951 910903 09/03/91 14805 40.5339 16 117 620921 September 21, 1962 910903 09/03/91 10574 28.9500 17 118 450821 August 21, 1945 910903 09/03/91 16814 46.0342 18 119 511017 October 17, 1951 910917 09/17/91 14580 39.9179 19 120 710218 February 18, 1971 910924 09/24/91 7523 20.5969 20 121 600701 July 1, 1960 910924 09/24/91 11407 31.2307 21 122 570118 January 18, 1957 911015 10/15/91 12688 34.7379 22 123 600710 July 10, 1960 911112 11/12/91 11447 31.3402 23 124 720308 March 8, 1972 . . . . 24 126 580201 February 1, 1958 920107 01/07/92 12393 33.9302 25 127 570909 September 9, 1957 920109 01/09/92 12540 34.3326 26 129 691007 October 7, 1969 920121 01/21/92 8141 22.2888 27 128 340929 September 29, 1934 920114 01/14/92 20926 57.2923