I'd use a PROC SQL statement and do a full outer join:   PROC SQL; CREATE TABLE OUTPUT AS SELECT t1.ID, t1.State, t2.Day, t2.Time FROM TABLE1 t1 FULL JOIN TABLE2 t2 ON (t1.State = t2.State); QUIT; ... View more