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;