Look into
Tables=>Join
Subset data table Dictionary by the Column column into a table for ETHCAT and one for ETHNICITY. Change the Value column into a numeric column. For the ETHNICITY data table, the Null or Missing needs to be expanded into 2 rows with Value having the value of . and one having the value of 0
Join each of the subsetted tables to the data table called dataset, joining ETHNICITY with Value for the one table, and ETHCAT with Value for the second table.
Jim