proc sql;
    insert into db.app (id, name)
    select a.id a.name from work.test as a;
quit;