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
Traj command (dropout model)Hello everyone, I am using the traj command to examined gait speed trajectories and I have a questi…
Selecting Date RangeI have a data where one of the variables is CloseDate whose Variable Type is int and Format is %tdnn…
Making a dummy for threshold Hi, I am going to make a dummy Ii ( Em (i)<= Em) that selects firms whose employment (Em(i)) is…
Solve dynamic non linear deterministic systemDear forum, After several hours of work, I am looking for the forum to help me to find a solution to…
How are p-values calculated in an Oaxaca-Blinder DecompositionHi all, I am trying to interpret the results of an Oaxaca-Blinder Decomposition. I am using the pop…
Subscribe to:
Post Comments (Atom)
0 Response to Generate variable capturing properties of other variables
Post a Comment