06-16-2016 01:31 PM
06-16-2016 02:06 PM
I'm assuming you actually used semicolons to end your statements, and you merged using a MERGE statement rather than a SET statement.
The basic problem is that you have a common variable, SUBJECT, in both data sets. There are a couple of ways to deal with that. To ignore all SUBJECT values in one data set, you could just drop it:
merge new (drop=subject in=a) new1;
by name class;
I would assume you are merging by both variables, and not just by NAME.
The problem gets a little more complex if you need to compare the SUBJECT values in the two data sets, to see which you want to use.