I am attempting to analyse the incidence rates of diseases for different ethnicities. Currently ethnicity is coded as a double digit. I want to analyses the rates of disease for different groups of Pacific Peoples. In the data itself there are multiple ethnic groups that fit under this. I am only interested in five pacific groups for analysis which are coded as follows: samoan = 31 tongan = 32 cook island maori = 33 aggregated other pacific = 30, 34, 35, 36, 37 total pacific = 30, 31, 32, 33, 34, 35, 36, 37 I want to assign a value to each of the analysis groups (so samoan ends up as 1, tongan as 2, cookisland maori as 3, aggregated other pacific = 4 and lastly the total pacific group = 5). Is this possible? And if so what sort of expression would I use to do that. The dataset looks as follow: clientid dob ethnicgp gender domicilecode 63287 05/04/1987 34 M 0441 87234 18/11/1963 30 F 8823 09834 27/01/2000 37 F 3015 23432 03/07/1991 31 M 2125 Thanks in Advance
... View more
