Hi

I have a variable named age_range (with storage type: str5) as you can see in the following table:

age_range
55-64
35-44
45-54
25-34
18-24
65+
18-24
35-44
I want to calculate the average age range of each participant.
May I ask you to advise me on how to calculate it?

I am thinking of using the split command but I'm not sure.

Many thanks,