Derived Period Variable based on Date Variable

Many datasets contain date variables and it might be useful to organize the dates into periods.

  1. Locate the date variable. Click on it and to the right choose ‘Create Periods’.

  1. Select the variable type: Days, Weeks, Months, Quarters or Year

    1. For Weeks select Monday or Sunday as starting day for the week

  1. A new variable ‘Date’ will now appear in the tree-structure with a blue icon containing Days, Weeks, Months, Quarters or Years as categories

    The name of the new variable is the same as the original added ‘Days’, ‘Weeks’ etc. depending on the type.