Example SAS program
PROC SQL; INSERT INTO Target.vitals_tgt ( STUDYID, SITEID, SUBJID, VISITNUM, INITIALS, BIRTHDT, HEIGHT, HEIGHTU, WEIGHT, WEIGHTU, SOURCE_KEY ) SELECT STUDYID, SITEID, SUBJID, VISITNUM, INITIALS, BIRTHDT, HEIGHT, HEIGHTU, WEIGHT, WEIGHTU, CDR_SKEY FROM Source.vitals; QUIT;