Dear all,
I have a household survey dataset consisting of two rounds. The dataset provides information on the month and the year of the interview. In round 1, a household could have been interviewed either in 2004 or in 2005 in any month. In round two, a household could have been interviewed either in 2011 or in 2012 in any month.
Additionally, I have monthly weather data for every year (e.g. T2004_1 for average temperature in January 2004).
I would like to generate a variable that captures the following information for every household for every round: average spring (January-March), summer (June-September) and winter (October-November) temperature and precipitation preceding the interview.
So for instance, for a household that was interviewed in round 1 in December 2004 the variables would be generated for the year 2004.
However, a household that was interviewed in June 2004 would draw on both, information from 2003 on winter and summer weather and 2004 for spring weather. I am however not really sure how to generate this variable. Could anyone please help?
Many thanks.
Related Posts with Generate variable capturing properties of other variables
Is there any method to statistically compare the coefficients in 2 tobit model ?Hello, I'm Dahye Yim. I need some helps to interpret the coefficients in 2 Tobit models. model 1 :…
Symmetric transposition of graph with respect to y = xDear Statalists, I came across one of the commands relevant to the quantile regression of econometr…
loop between dates variables long formatHow to make a loop between the variable date2 and date1 to check if there is a difference of more th…
Is it possible to "zoom in" a region of a map using grmap?Dear all, I am plotting age-standardised incidence rates of a certain health condition onto a map o…
asdoc: version update on SSCI have been pushing updates to asdoc through my website, all updates till this date are now part of …
Subscribe to:
Post Comments (Atom)
0 Response to Generate variable capturing properties of other variables
Post a Comment