I added an example of what I have and what I would expect to get in the new table
CREATE TABLE new AS
SELECT *,
case when status in ('28' ,'44' ,'13' ) then 1 else 0 end as exp,
case when status ='33' then 1 else 0 end as exp1
from old
WHERE DATE_FORMAT (clinic_admit_dt, 'yyyyMM') >= '201608' AND DATE_FORMAT(clinic_discharge_dt, 'yyyyMM') <= '201610' , 30)
);