Derived Categorical Variables based on numeric variables
Many datasets contain numeric data, which it is often relevant present as intervals or categories. For example, a numeric variable containing numbers from 1590 can be organized into intervals, or a numeric variable containing the numbers ‘1’, ‘2’, ‘3’, ‘4’, ‘5’ and ‘99’ which can be organized into exact 6 categories.
Mark a numeric variable and these two options in the variable window appear:
Video: From Numeric to Categorical Variables
In our example, ‘Age’ is one of the variables. Say, for instance, that we are interested in creating four different age groups. The following shows how to create these into groups:

Locate the numerical variable. Click on it and to the right choose ‘Create Interval Variable.’ Select for instance 3 intervals:

A new variable will now appear in the treestructure with a blue icon, signalling it is a derived categorical variable. OfficeReports will give this type of new derived variable the same text as the original. The name of the new variable is the same as the original added ‘Intervals’:

Variable name and text are editable in the boxes on the righthand side.

To alter the intervals, we highlight each category that has appeared under the ‘Age Intervals’ variable and change the formula that is written in the bottom box on the righthand side. Click `Save´ when changing a formula.

If you need extra categories, these can be added using ‘Categories àNew Category’. Enter a category name (interval) and add a formula.

We are now ready to use the new variable for reporting or in combination with other variables.
Quite often a dataset includes numerical variables containing a limited number of exact values – it could be for instance ratings ‘1’, ‘2’, ‘3’, ‘4’, and ‘5’ to a scale question or as in our example data the variable ‘Working hours’ which contains 3 exact values ‘925’, ‘1500’ and ‘1850’.
Based on this example it can be useful to produce a derived categorical variable containing categories equalizing the exact numbers.

Locate the numerical variable (in our case ‘Working hours’). Click on it and to the right we choose ‘Create Categories:

A new variable will now appear in the treestructure with a blue icon containing as many categories as we have unique numbers in the original numerical variable.OfficeReports will give this type of new derived variable the same text as the original. The name of the new variable is the same as the original added ‘Categories’.
This video shows an example: From Numeric to Categorical Variable