Counting number of days a treatment was ON in a given county - Statalist

Search in titles only
Search in General only Advanced Search

You are not logged in. You can browse but not post. Login or Register by clicking 'Login or Register' at the top-right of this page. For more information on Statalist, see the FAQ.

X

Lars Pete

Join Date: Nov 2020
Posts: 118

#1

Counting number of days a treatment was ON in a given county

04 May 2023, 17:02

Code:

* Example generated by -dataex-. For more info, type help dataex
clear
input byte statefips str20 state long countyfips str33 county int year str9 date_string byte value str52 countyorderstatus long SAHO_status float(date date2)
1 "Alabama" 1001 "Autauga" 2020 "3/15/2020" 1 "No order found (1)"          7 21989 21989
1 "Alabama" 1001 "Autauga" 2020 "3/16/2020" 1 "No order found (1)"          7 21990 21990
1 "Alabama" 1001 "Autauga" 2020 "3/17/2020" 1 "No order found (1)"          7 21991 21991
1 "Alabama" 1001 "Autauga" 2020 "3/18/2020" 1 "No order found (1)"          7 21992 21992
1 "Alabama" 1001 "Autauga" 2020 "3/19/2020" 1 "No order found (1)"          7 21993 21993
1 "Alabama" 1001 "Autauga" 2020 "3/20/2020" 1 "No order found (1)"          7 21994 21994
1 "Alabama" 1001 "Autauga" 2020 "3/21/2020" 1 "No order found (1)"          7 21995 21995
1 "Alabama" 1001 "Autauga" 2020 "3/22/2020" 1 "No order found (1)"          7 21996 21996
1 "Alabama" 1001 "Autauga" 2020 "3/23/2020" 1 "No order found (1)"          7 21997 21997
1 "Alabama" 1001 "Autauga" 2020 "3/24/2020" 1 "No order found (1)"          7 21998 21998
1 "Alabama" 1001 "Autauga" 2020 "3/25/2020" 1 "No order found (1)"          7 21999 21999
1 "Alabama" 1001 "Autauga" 2020 "3/26/2020" 1 "No order found (1)"          7 22000 22000
1 "Alabama" 1001 "Autauga" 2020 "3/27/2020" 1 "No order found (1)"          7 22001 22001
1 "Alabama" 1001 "Autauga" 2020 "3/28/2020" 1 "No order found (1)"          7 22002 22002
1 "Alabama" 1001 "Autauga" 2020 "3/29/2020" 1 "No order found (1)"          7 22003 22003
1 "Alabama" 1001 "Autauga" 2020 "3/30/2020" 1 "No order found (1)"          7 22004 22004
1 "Alabama" 1001 "Autauga" 2020 "3/31/2020" 1 "No order found (1)"          7 22005 22005
1 "Alabama" 1001 "Autauga" 2020 "4/1/2020"  1 "No order found (1)"          7 22006 22006
1 "Alabama" 1001 "Autauga" 2020 "4/2/2020"  1 "No order found (1)"          7 22007 22007
1 "Alabama" 1001 "Autauga" 2020 "4/3/2020"  1 "No order found (1)"          7 22008 22008
1 "Alabama" 1001 "Autauga" 2020 "4/4/2020"  7 "Mandatory - all people (7)"  2 22009 22009
1 "Alabama" 1001 "Autauga" 2020 "4/5/2020"  7 "Mandatory - all people (7)"  2 22010 22010
1 "Alabama" 1001 "Autauga" 2020 "4/6/2020"  7 "Mandatory - all people (7)"  2 22011 22011
1 "Alabama" 1001 "Autauga" 2020 "4/7/2020"  7 "Mandatory - all people (7)"  2 22012 22012
1 "Alabama" 1001 "Autauga" 2020 "4/8/2020"  7 "Mandatory - all people (7)"  2 22013 22013
1 "Alabama" 1001 "Autauga" 2020 "4/9/2020"  7 "Mandatory - all people (7)"  2 22014 22014
1 "Alabama" 1001 "Autauga" 2020 "4/10/2020" 7 "Mandatory - all people (7)"  2 22015 22015
1 "Alabama" 1001 "Autauga" 2020 "4/11/2020" 7 "Mandatory - all people (7)"  2 22016 22016
1 "Alabama" 1001 "Autauga" 2020 "4/12/2020" 7 "Mandatory - all people (7)"  2 22017 22017
1 "Alabama" 1001 "Autauga" 2020 "4/13/2020" 7 "Mandatory - all people (7)"  2 22018 22018
1 "Alabama" 1001 "Autauga" 2020 "4/14/2020" 7 "Mandatory - all people (7)"  2 22019 22019
1 "Alabama" 1001 "Autauga" 2020 "4/15/2020" 7 "Mandatory - all people (7)"  2 22020 22020
1 "Alabama" 1001 "Autauga" 2020 "4/16/2020" 7 "Mandatory - all people (7)"  2 22021 22021
1 "Alabama" 1001 "Autauga" 2020 "4/17/2020" 7 "Mandatory - all people (7)"  2 22022 22022
1 "Alabama" 1001 "Autauga" 2020 "4/18/2020" 7 "Mandatory - all people (7)"  2 22023 22023
1 "Alabama" 1001 "Autauga" 2020 "4/19/2020" 7 "Mandatory - all people (7)"  2 22024 22024
1 "Alabama" 1001 "Autauga" 2020 "4/20/2020" 7 "Mandatory - all people (7)"  2 22025 22025
1 "Alabama" 1001 "Autauga" 2020 "4/21/2020" 7 "Mandatory - all people (7)"  2 22026 22026
1 "Alabama" 1001 "Autauga" 2020 "4/22/2020" 7 "Mandatory - all people (7)"  2 22027 22027
1 "Alabama" 1001 "Autauga" 2020 "4/23/2020" 7 "Mandatory - all people (7)"  2 22028 22028
1 "Alabama" 1001 "Autauga" 2020 "4/24/2020" 7 "Mandatory - all people (7)"  2 22029 22029
1 "Alabama" 1001 "Autauga" 2020 "4/25/2020" 7 "Mandatory - all people (7)"  2 22030 22030
1 "Alabama" 1001 "Autauga" 2020 "4/26/2020" 7 "Mandatory - all people (7)"  2 22031 22031
1 "Alabama" 1001 "Autauga" 2020 "4/27/2020" 7 "Mandatory - all people (7)"  2 22032 22032
1 "Alabama" 1001 "Autauga" 2020 "4/28/2020" 7 "Mandatory - all people (7)"  2 22033 22033
1 "Alabama" 1001 "Autauga" 2020 "4/29/2020" 7 "Mandatory - all people (7)"  2 22034 22034
1 "Alabama" 1001 "Autauga" 2020 "4/30/2020" 2 "Advisory/Recommendation (2)" 1 22035 22035
1 "Alabama" 1001 "Autauga" 2020 "5/1/2020"  2 "Advisory/Recommendation (2)" 1 22036 22036
1 "Alabama" 1001 "Autauga" 2020 "5/2/2020"  2 "Advisory/Recommendation (2)" 1 22037 22037
1 "Alabama" 1001 "Autauga" 2020 "5/3/2020"  2 "Advisory/Recommendation (2)" 1 22038 22038
end
format %td date
format %td date2
label values SAHO_status SAHO_status
label def SAHO_status 1 "Advisory/Recommendation", modify
label def SAHO_status 2 "Mandatory - all people", modify
label def SAHO_status 7 "No order found", modify

The treatment is SAHO_status, which is categorical. Dates are WEEKLY. How can we count the number of DAYS each type of treatment was ON for each county?

Thanks.

Tags: None

Carlo Lazzaro

Join Date: Apr 2014

Posts: 17740
#2

05 May 2023, 02:07

Lars:
you may want to try:
bysort statefips: gen wanted=sum( value ) if SAHO_status==2

Last edited by Carlo Lazzaro; 05 May 2023, 02:10.

Kind regards,
Carlo
(Stata 19.0)
Comment
Lars Pete

Join Date: Nov 2020

Posts: 118
#3

05 May 2023, 07:55

Hi Carlo, thanks for your response. I was able to do this in a different way yesterday.
Comment

Previous Next

Working...

X