Yes, but you will need to add a statement to the program that controls which variables don't get replaced. Just before the OUTPUT statement: set have (keep = list of variables to keep as is); ... View more

A straight merge will do this if the variable names are the same as in your example.   data want; merge work sums; by SEQN; run; ... View more

Thank you! The first code you sent kept deleting all observations for some reason but the second one worked! I am just interested in the food groups eaten by participants for right now. ... View more