While PROC TRAJ is a SAS procedure, it was not written by SAS.  You will need to contact the authors of the procedure for help.  Clicking on the contact link here should send the author an email.   ... View more

Are there other variables with the same name in both sets? What do you want to happen with those if there are? You can only have one variable with a given name in a result.   It is usually best to provide small examples of you input data set(s) and the code you used with those sets. Then describe what is in the output that you do not want or is missing. Things as simple as the order of the data sets appearing on a merge statement in a data step make big differences in the output. See this brief example: data one; do x=1 to 3; do y = 4 to 6; output; end; end; run; data two; do x= 2 to 5; y= x+10; output; end; run; proc sort data=one; by x; run; proc sort data=two; by x; run; data mergeone; merge one two; by x; run; data mergetwo; merge two one; by x; run; Notice that the values for y are different for the two sets.   Merge with a by clause: when a value does not exist in both sets means that a record without a match is copied to the result. So you are likely getting more records than you expect. You can use the data set IN= option to test which data set contributed the current observation and discard or keep. data mergethree; merge two (in=InTWo) one (In=InOne); by x; if InTwo and InOne; /* keep records where only the X matches in both sets*/ run; data mergefour; merge two (in=InTWo) one (In=InOne); by x; if InTwo ; /* keep records that come from two and the values from one when the match*/ run; ... View more