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