I have got a dataset with declarations of healthcare providers to a health insurance company. One provider can have multiple cases in the dataset. In the dataset there are health care providers who signed different types of contracts with health insurance companies. I want to identify the number of unique health care providers for each contract category.
My question is: How can I use SPSS to calculate the number of unique values in a variable. Additionally, I want the outcome to be grouped per value from another variable (for each type of contract).