Posted on April 29, 2015 by kuekawaMerge statement with various options data mrgawd; merge x1 (in=a DROP=xx RENAME=(xxx_id=xxid)) x2 (in=b); by xxxid; run