I´m new in the group. Please help with this instruction because I am very confused.
I have a file "sales" with a category "Year" (1980,...2020).
I need to create a new category "Period" with some conditions: Years from 1980-2018 named as "Past", Year 2019 named as "Present" and Year 2020 named as "Future".
There are some questions needed to be answerwed with the new category "Period" but it is not allowed to remove the category "Year".
Some said to use if.else or mapvalues, but it is impossible to complete.
The problem is to have a category Year as numeric, Period as non numeric and different extensions of the levels.
Could you help me with that? I am lost.