hello we have month year strings and used the date(S, "MY") command. The resulting months are completely off. can anyone tell us what the problem is?
thanks. the data is below
thanks. the data is below
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str7 DDN float ddn "05/1975" 5599 "11/1984" 9071 "12/1984" 9101 "12/1970" 3987 "11/1975" 5783 "09/1974" 5357 "09/1954" -1948 "06/1976" 5996 "05/0719" -453146 "01/1975" 5479 "04/1968" 3013 "09/1978" 6818 "11/1951" -2983 "10/1962" 1004 "10/1994" 12692 "12/1980" 7640 "12/1997" 13849 "12/1979" 7274 "04/1972" 4474 "03/1987" 9921 "05/1986" 9617 "06/1955" -1675 "08/1988" 10440 "07/1995" 12965 "07/1995" 12965 "09/1976" 6088 "10/1970" 3926 "12/1984" 9101 "05/1963" 1216 "04/1979" 7030 "05/1973" 4869 "02/1981" 7702 "11/1948" -4078 "06/1991" 11474 "05/1991" 11443 "12/1972" 4718 "11/1960" 305 "12/1972" 4718 "11/1986" 9801 "07/1988" 10409 "10/1977" 6483 "01/1988" 10227 "10/2004" 16345 "12/1990" 11292 "02/1977" 6241 "09/1966" 2435 "09/1979" 7183 "01/1981" 7671 "05/1979" 7060 "08/1975" 5691 "06/1959" -214 "07/1975" 5660 "03/1995" 12843 "10/1958" -457 "08/2000" 14823 "01/1967" 2557 "09/1982" 8279 "12/1996" 13484 "01/1983" 8401 "02/1976" 5875 "04/1971" 4108 "12/1996" 13484 "12/1998" 14214 "10/1970" 3926 "12/1985" 9466 "07/1975" 5660 "07/1993" 12235 "03/1959" -306 "01/1961" 366 "09/1978" 6818 "01/1963" 1096 "12/1970" 3987 "07/1989" 10774 "03/1960" 60 "08/1979" 7152 "05/1981" 7791 "10/1960" 274 "03/1976" 5904 "08/1964" 1674 "07/1988" 10409 "08/1990" 11170 "06/1992" 11840 "02/1983" 8432 "08/1960" 213 "03/1979" 6999 "11/1991" 11627 "10/1984" 9040 "11/1972" 4688 "04/1980" 7396 "08/1948" -4170 "09/1988" 10471 "05/1991" 11443 "03/1982" 8095 "11/1979" 7244 "11/1967" 2861 "06/1957" -944 "12/1987" 10196 "11/1981" 7975 "04/1965" 1917 "07/1984" 8948 end format %tmMonth_CCYY ddn
Comment