Hi there, I'm using Stata 18 on Windows 11 Pro. I'm trying to do two things: 1) create a MM-YYYY or YYYY-MM (order doesn't matter) from two variables (ppbeg_mnth, created from a month variable, dobmm) and (ppbeg_yr, created from a year variable, dobyy) and 2) from this, write a command that enables me to identify whether a given event falls within a YEAR in the combined variable of #1.
Any advice or guidance would be greatly appreciated!
Any advice or guidance would be greatly appreciated!
Code:
* Example generated by -dataex-. For more info, type help dataex clear input double(dobyy dobmm) float(ppbeg_mnth ppbeg_year) 1962 11 11 1962 1959 10 10 1959 1992 6 6 1992 1985 10 10 1985 2012 3 3 2012 2011 1 1 2011 1988 1 1 1988 1990 1 1 1990 2014 10 10 2014 1970 11 11 1970 1966 8 8 1966 2003 1 1 2003 2005 7 7 2005 1954 1 1 1954 1961 11 11 1961 1988 10 10 1988 1983 9 9 1983 2010 5 5 2010 1988 10 10 1988 1962 8 8 1962 1955 5 5 1955 1979 8 8 1979 1977 4 4 1977 2009 1 1 2009 2011 2 2 2011 1997 1 1 1997 1999 11 11 1999 1970 12 12 1970 1995 5 5 1995 1963 1 1 1963 1945 6 6 1945 2007 3 3 2007 2003 5 5 2003 1977 4 4 1977 2014 6 6 2014 1982 2 2 1982 1976 7 7 1976 2001 5 5 2001 2007 6 6 2007 1940 8 8 1940 1949 7 7 1949 1961 2 2 1961 1969 1 1 1969 1974 5 5 1974 1991 5 5 1991 2013 3 3 2013 2012 6 6 2012 2009 10 10 2009 2010 11 11 2010 2015 9 9 2015 1960 3 3 1960 2005 2 2 2005 1980 7 7 1980 2003 10 10 2003 2010 8 8 2010 1974 6 6 1974 1935 3 3 1935 1933 9 9 1933 1948 6 6 1948 1966 5 5 1966 1930 12 12 1930 1949 3 3 1949 1930 5 5 1930 1932 2 2 1932 1933 10 10 1933 1961 4 4 1961 1989 6 6 1989 1952 8 8 1952 1976 2 2 1976 1963 4 4 1963 2012 1 1 2012 1985 7 7 1985 1988 3 3 1988 2012 1 1 2012 2009 1 1 2009 1977 4 4 1977 1978 8 8 1978 1961 2 2 1961 2001 12 12 2001 1997 9 9 1997 1959 5 5 1959 1970 10 10 1970 1965 8 8 1965 1997 7 7 1997 1968 8 8 1968 1968 2 2 1968 1998 1 1 1998 2003 6 6 2003 1944 7 7 1944 2000 10 10 2000 1945 7 7 1945 1985 8 8 1985 1989 10 10 1989 1990 12 12 1990 2007 7 7 2007 1970 9 9 1970 1986 11 11 1986 2009 12 12 2009 2014 9 9 2014 1964 12 12 1964 end label values dobyy H1810223X label values dobmm H1810222X label def H1810222X 1 "1 JANUARY", modify label def H1810222X 2 "2 FEBRUARY", modify label def H1810222X 3 "3 MARCH", modify label def H1810222X 4 "4 APRIL", modify label def H1810222X 5 "5 MAY", modify label def H1810222X 6 "6 JUNE", modify label def H1810222X 7 "7 JULY", modify label def H1810222X 8 "8 AUGUST", modify label def H1810222X 9 "9 SEPTEMBER", modify label def H1810222X 10 "10 OCTOBER", modify label def H1810222X 11 "11 NOVEMBER", modify label def H1810222X 12 "12 DECEMBER", modify
Comment