SPSS macro to automatically remove duplicates and drop variable

SPSS macroSPSS macro for removing duplicates

SPSS has a built in GUI function for removing duplicates however it is lacking some of the key options that I like to use (perform case insensitive dedupe, drop duplicates, drop the flag, etc). I built my own macro which is very easy to use and has all the options I typically need.

The following video demonstrates them in use.


Removing duplicates in SPSS using a custom macro

Here are the SPSS macros 



Leave a Reply