You're getting that result, because that's what the program is designed to do.   There are several signs within the program that indicate you don't understand that this is what the program does.  If the program is designed to keep only one summary observation per CTYPE:   Why not keep CTYPE as one of the variables being output? Why keep _OTHER since it is merely the last value being added into the total? Bottom line:  the program doesn't do what you want.  It's not supposed to.  But you need to describe what you do want, if you would like some help. ... View more