| pre and post Covid-19 groups India [message #28312] |
Tue, 12 December 2023 07:26  |
Varsha
Messages: 27
Registered: November 2020
|
Member |
|
|
Hello,
I want to create two groups based on the first lockdown in India: pre-Covid would be those surveyed before 25 March 2020 date and post on or after this date. How can I do that in stata? Please help.
|
|
|
|
| Re: pre and post Covid-19 groups India [message #28315 is a reply to message #28312] |
Tue, 12 December 2023 14:17  |
Varsha
Messages: 27
Registered: November 2020
|
Member |
|
|
I created the year and month of interview variables using the following codes:
gen year_of_interview = int(( hv008 - 1 )/12) + 1900
gen month_of_interview = hv008 - (( year_of_interview - 1900) * 12)
Should be use the variable 'date of interview (CMC)' when month and year of interview variables are already given?
[Updated on: Tue, 12 December 2023 14:22] Report message to a moderator |
|
|
|
| Re: pre and post Covid-19 groups India [message #28323 is a reply to message #28315] |
Thu, 14 December 2023 07:27 |
Bridgette-DHS
Messages: 3043
Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS staff member, Tom Pullum:
The Stata lines pasted below will give a variable that is 1 for interview dates on or after March 25, 2020, and 0 for earlier dates. If you want to run this in the IR or KR file, just replace "hv" with "v'.
use "...IAPR7EFL.DTA", clear
gen days_out=mdy(hv006,hv016,hv007)-mdy(3,25,2020)
gen after=0
replace after=1 if days_out>=0
label define after 0 "" 1 ""
label values after after
tab after
Using the "mdy" command will give what you want.
[Updated on: Thu, 14 December 2023 07:35] Report message to a moderator |
|
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
