Counting unique values in one variable

[Robbert Schuijbroek]

Hello everyone,

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).

I have added a file to make myself clear.

I hope you guys can help me out.

[Author]

Posts