It looks like you are trying to get data from table 'income_dataset' into your new table 'substring_income_dataset' so do the following instead:

CREATE TABLE substring_income_dataset AS SELECT year, substring(income_total, 1, 2), benefit_type FROM income_dataset;