Checking if a date falls between two other dates

Parul Gupta

Join Date: Jun 2020
Posts: 152

Checking if a date falls between two other dates

28 Jul 2024, 23:15

Hi, I have data listing the chief ministers (CMs) and their terms for each state. I want to know which CMs were in office on 31st January 2018.

Code:

* Example generated by -dataex-. For more info, type help dataex
clear
input str17 State_Name str47 Name str10(Start_Date End_Date) str6 Party
"Andhra_Pradesh"    "Sri (Dr)Neelam Sanjeeva Reddy" "12-03-1962" "28-02-1964" "INC"  
"Andhra_Pradesh"    "Sri Kasu Bramhananda Reddy"    "29-02-1964" "28-02-1967" "INC"  
"Andhra_Pradesh"    "Sri Kasu Bramhananda Reddy"    "01-03-1967" "30-09-1971" "INC"  
"Andhra_Pradesh"    "Sri P.V.Narasimha Rao"         "30-09-1971" "14-03-1972" "INC"  
"Andhra_Pradesh"    "Sri P.V.Narasimha Rao"         "14-03-1972" "18-01-1973" "INC"  
"Andhra_Pradesh"    "President's Rule"              "18-01-1973" "10-12-1973" ""      
"Andhra_Pradesh"    "Sri. Jalagam Vengala Rao"      "10-12-1973" "05-03-1978" "INC"  
"Andhra_Pradesh"    "Dr Marri Chenna Reddy"         "6-3-1978"   "10-10-1980" "INC(I)"
"Andhra_Pradesh"    "Sri Tanguturi Anjaiah"         "11-10-1980" "24-02-1982" ""      
"Andhra_Pradesh"    "Sri Bhavanam Venkataram"       "24-02-1982" "20-09-1982" ""      
"Andhra_Pradesh"    "Sri K.Vijaya Bhaskara Reddy"   "20-09-1982" "08-01-1983" ""      
"Andhra_Pradesh"    "Sri N.T.Rama Rao"              "09-01-1983" "16-08-1984" "IND"  
"Andhra_Pradesh"    "Sri N.Bhaskara rao"            "16-08-1984" "16-09-1984" "IND"  
"Andhra_Pradesh"    "Sri N.T.Rama Rao"              "16-09-1984" "07-03-1985" "IND"  
"Andhra_Pradesh"    "Sri N.T.Rama Rao"              "08-03-1985" "02-12-1989" "TDP"  
"Andhra_Pradesh"    "Dr.Marri Chenna Reddy"         "03-12-1989" "07-12-1990" "INC"  
"Andhra_Pradesh"    "Sri N.Janardhana Reddy"        "17-12-1990" "09-10-1992" "INC"  
"Andhra_Pradesh"    "Sri K.VijayaBhaskara Reddy"    "10-10-1992" "11-12-1994" "INC"  
"Andhra_Pradesh"    "Sri N.T.Rama Rao"              "12-12-1994" "31-08-1995" "TDP"  
"Andhra_Pradesh"    "Sri N. Chandra Babu Naidu"     "01-09-1995" "09-10-1999" "TDP"  
"Andhra_Pradesh"    "Sri N. Chandra Babu Naidu"     "10-10-1999" "13-05-2004" "TDP"  
"Andhra_Pradesh"    "Dr.Y.S. Rajasekhara Reddy"     "14-05-2004" "19-05-2009" "INC"  
"Andhra_Pradesh"    "Dr.Y.S. Rajasekhara Reddy"     "19-05-2009" "02-09-2009" "INC"  
"Andhra_Pradesh"    "Sri. K. Rosaiah"               "03-09-2009" "24-11-2010" ""      
"Andhra_Pradesh"    "Sri. N.Kiran Kumar Reddy"      "25-11-2010" "28-02-2014" "INC"  
"Andhra_Pradesh"    "President's Rule"              "01-03-2014" "02-06-2014" ""      
"Andhra_Pradesh"    "Chandrababu Naidu"             "02-06-2014" "29-05-2019" "TDP"  
"Andhra_Pradesh"    "Y. S. Jaganmohan Reddy"        "30-05-2019" "Current"    "YSRCP"
"Arunachal_Pradesh" "P.K. Thungon"                  "16-08-1975" "20-03-1978" ""      
"Arunachal_Pradesh" "P.K. Thungon"                  "21-03-1978" "06-09-1979" "JNP"  
"Arunachal_Pradesh" "Late Tomo Riba"                "18-09-1979" "03-11-1979" "PPA"  
"Arunachal_Pradesh" "President's Rule"              "03-11-1979" "18-01-1980" ""      
"Arunachal_Pradesh" "Gegong Apang"                  "18-01-1980" "02-02-1985" "INC(I)"
"Arunachal_Pradesh" "Gegong Apang"                  "02-02-1985" "05-03-1990" "INC"  
"Arunachal_Pradesh" "Gegong Apang"                  "06-03-1990" "18-03-1995" "INC"  
"Arunachal_Pradesh" "Gegong Apang"                  "19-03-1995" "18-01-1999" "INC"  
"Arunachal_Pradesh" "Mukut Mithi"                   "19-01-1999" "09-10-1999" "INC"  
"Arunachal_Pradesh" "Mukut Mithi"                   "10-10-1999" "02-08-2003" "INC"  
"Arunachal_Pradesh" "Gegong Apang"                  "03-08-2003" "23-10-2004" "AC"    
"Arunachal_Pradesh" "Gegong Apang"                  "24-10-2004" "09-04-2007" "INC"  
"Arunachal_Pradesh" "Dorjee Khandu"                 "10-04-2007" "22-10-2009" ""      
"Arunachal_Pradesh" "Dorjee Khandu"                 "23-10-2009" "04-05-2011" "INC"  
"Arunachal_Pradesh" "Jarbom Gamlin"                 "05-05-2011" "31-10-2011" "INC"  
"Arunachal_Pradesh" "Nabam Tuki"                    "01-11-2011" "17-05-2014" "INC"  
"Arunachal_Pradesh" "Nabam Tuki"                    "18-05-2014" "26-01-2016" "INC"  
"Arunachal_Pradesh" "President's Rule"              "26-01-2016" "19-02-2016" ""      
"Arunachal_Pradesh" "Kalikho Pul"                   "19-02-2016" "13-07-2016" "INC"  
"Arunachal_Pradesh" "Nabam Tuki"                    "13-07-2016" "17-07-2016" "INC"  
"Arunachal_Pradesh" "Pema Khandu"                   "17-07-2016" "26-05-2019" "INC"  
"Arunachal_Pradesh" "Pema Khandu"                   "29-05-2019" "Current"    "BJP"  
"Assam"             "B.P. Chaliha"                  "03-03-1962" "01-03-1967" "INC"  
"Assam"             "B.P. Chaliha"                  "01-03-1967" "06-11-1970" "INC"  
"Assam"             "Mohendra Mohan Choudhury"      "11-11-1970" "30-01-1972" "INC"  
"Assam"             "Shri Sarat Chandra Sinha"      "31-01-1972" "12-03-1978" "INC"  
"Assam"             "Shri Golap Borbora"            "12-03-1978" "04-09-1979" "JNP"  
"Assam"             "Shri Jogendra Nath Hazarika"   "9-9-1979"   "11-12-1979" "JNP"  
"Assam"             "President's Rule"              "12-12-1979" "05-12-1980" ""      
"Assam"             "Shrimati Anowara Taimur"       "06-12-1980" "30-06-1981" "INC(I)"
"Assam"             "President's Rule"              "30-06-1981" "13-01-1982" ""      
"Assam"             "Shri Kesab Chandra Gogoi"      "13-01-1982" "19-03-1982" "JNP"  
"Assam"             "President's Rule"              "19-03-1982" "27-02-1983" ""      
"Assam"             "Shri Hiteswar Saikia"          "27-02-1983" "23-12-1985" "INC"  
"Assam"             "Shri Prafulla Kumar Mahanta"   "24-12-1985" "27-11-1990" "IND"  
"Assam"             "President's Rule"              "28-11-1990" "30-06-1991" ""      
"Assam"             "Shri Hiteswar Saikia"          "30-06-1991" "22-04-1996" "INC"  
"Assam"             "Dr. Bhumidhar Barman"          "22-04-1996" "14-05-1996" "INC"  
"Assam"             "Shri Prafulla Kumar Mahanta"   "15-05-1996" "17-05-2001" "AGP"  
"Assam"             "Shri Tarun Gogoi"              "17-05-2001" "11-05-2006" "INC"  
"Assam"             "Shri Tarun Gogoi"              "12-05-2006" "16-05-2011" "INC"  
"Assam"             "Shri Tarun Gogoi"              "17-05-2011" "21-05-2016" "INC"  
"Assam"             "Shri Sarbananda Sonowal"       "24-05-2016" "09-05-2021" "BJP"  
"Assam"             "Shri Himanta Biswa Sarma"      "10-05-2021" "Current"    "BJP"  
"Goa"               "Shri Pratapsingh R. Rane"      "09-01-1990" "27-03-1990" "INC"  
"Goa"               "Shri Churchill Alemao"         "27-03-1990" "14-04-1990" "INC"  
"Goa"               "Dr. Luis Proto Barbosa"        "14-04-1990" "14-12-1990" "INC"  
"Goa"               "President's Rule"              "14-12-1990" "25-01-1991" ""      
"Goa"               "Shri Ravi S. Naik"             "25-01-1991" "18-05-1993" "MAG"  
"Goa"               "Dr. Wilfred de Souza"          "18-05-1993" "02-04-1994" "INC"  
"Goa"               "Shri Ravi S. Naik"             "02-04-1994" "08-04-1994" "INC"  
"Goa"               "Dr. Wilfred de Souza"          "08-04-1994" "16-12-1994" "INC"  
"Goa"               "Shri Pratapsingh R. Rane"      "16-12-1994" "29-07-1998" "INC"  
"Goa"               "Dr. Wilfred de Souza"          "29-07-1998" "23-11-1998" "INC"  
"Goa"               "Shri Luizinho Faleiro"         "26-11-1998" "08-02-1999" "INC"  
"Goa"               "President's Rule"              "10-02-1999" "09-06-1999" ""      
"Goa"               "Shri Luizinho Faleiro"         "09-06-1999" "24-11-1999" "INC"  
"Goa"               "Shri Francisco Sardinha"       "24-11-1999" "23-10-2000" "INC"  
"Goa"               "Shri Manohar Parrikar"         "24-10-2000" "31-05-2002" "BJP"  
"Goa"               "Shri Manohar Parrikar"         "01-06-2002" "02-02-2005" "BJP"  
"Goa"               "Shri Pratapsingh R. Rane"      "03-02-2005" "04-03-2005" "INC"  
"Goa"               "President's Rule"              "04-03-2005" "06-06-2005" ""      
"Goa"               "Shri Pratapsingh R. Rane"      "07-06-2005" "07-06-2007" "INC"  
"Goa"               "Shri Digambar Kamat"           "08-06-2007" "08-03-2012" "INC"  
"Goa"               "Shri Manohar Parrikar"         "09-03-2012" "08-11-2014" "BJP"  
"Goa"               "Shri Laxmikant Parsekar"       "08-11-2014" "11-03-2017" "BJP"  
"Goa"               "Shri Manohar Parrikar"         "14-03-2017" "17-09-2019" ""      
"Goa"               "Shri Pramod Sawant"            "17-09-2019" "Current"    ""      
"Gujarat"           "Dr. Jivraj Narayan Mehta"      "03-03-1962" "19-09-1963" "INC"  
"Gujarat"           "Shri Balwantray Mehta"         "19-09-1963" "19-09-1965" ""      
"Gujarat"           "Shri Hitendra K. Desai"        "19-09-1965" "28-02-1967" "INC"  
"Gujarat"           "Shri Hitendra K. Desai"        "01-03-1967" "13-05-1971" "INC"  
end

Could someone help with this?

Last edited by Parul Gupta; 28 Jul 2024, 23:41.

Tags: None

Parul Gupta

Join Date: Jun 2020

Posts: 152
#2

28 Jul 2024, 23:41

I got it with

Code:

gen byte within = inrange(mdy(1,31,2018), startdate, enddate)

but I also want to know out of all states, how many had an INC govt on this given date. Is that possible?
Comment

Hemanshu Kumar

Join Date: Mar 2015
Posts: 1371

28 Jul 2024, 23:54

Code:

egen byte INC_within = max(within & Party == "INC"), by(State_Name)
egen tag_state = tag(State_Name)

which produces:

Code:

. list State_Name INC_within if tag_state, noobs abbrev(10)

  +--------------------------------+
  |        State_Name   INC_within |
  |--------------------------------|
  |    Andhra_Pradesh            0 |
  | Arunachal_Pradesh            1 |
  |             Assam            0 |
  |               Goa            0 |
  |           Gujarat            0 |
  +--------------------------------+

Comment

Parul Gupta

Join Date: Jun 2020

Posts: 152
#4

29 Jul 2024, 00:00

Perfect, thanks Hemanshu!
Comment

Announcement

Checking if a date falls between two other dates

Comment

Comment

Comment