Q Research Software

The user would like to roll the months in the columns of their table for a 3 month roll. However, instead of setting the values for the first 2 months to missing or ignoring them entirely, we would have month 1 only and month 1 + month 2 rolled prior to the 3 month rolling periods that follow.

Ability to set Missing Values in Date/Time variable

For this client, the fieldwork start and end dates for a particular month are inconsistent. For example, for Jan 2022, field work could run from the 1st to the 31st, while in 2023, it could spill over to the first week of February. He gets an SPSS file where the agency creates all the variables for the month and year. He would like to use these variables to create moving averages rather than date and time variables to set up monthly periods.

You can do monthly, quarterly and annual date aggregation but there is no option to do half-yearly. The only workaround is to use R code: {{as.character(lubridate::floor_date(WAVE_MONTH, "halfyear"))}}