I have a dataset with age groups as individual variables with counts and I want to create one age group variable with all the options in that variable and combine some age groups as well: HAVE: age_grp_1 = 345 age_grp_2 = 123 age_grp_3 = 46 age_grp_4 = 35 age_grp_5 = 232 age_grp_6 = 372

WANT: age_grp variable with the following values 1= 345 2 = 123 3 = 46 + 35 (combine groups 3&4 above) 4 = 232 5 = 372

Anyone know how to do this? Thanks in advance!