Counting total number of distrinct observations based on an ID and characteristics

[Luis Mijares Castaneda]

I have another issue with the same data set I previously posted, I want to find the total number of Muslim families in the data set below, the family_ID variable is what I need to use


* Example generated by -dataex-. To install: ssc install dataex
clear
input int family_id str22 voter_name str23 father_name int birth_year str6 religion float(voter_value father_value year expander first_birth_year family_religion_score) byte tag_family_id long num_religion
1 "Inda Swfnf" "Bhhhk Sfnvh" 1996 "Hindu" .9918037 .9155425 1987 11 1990 .9155425 1 1
1 "Mwnfvh Kamwd" "Bhhhk Sfnvh" 1990 "Hindu" .7049773 .9155425 1988 11 1990 .9155425 0 1
1 "Inda Swfnf" "Bhhhk Sfnvh" 1996 "Hindu" .9918037 .9155425 1989 11 1990 .9155425 0 1
1 "Inda Swfnf" "Bhhhk Sfnvh" 1996 "Hindu" .9918037 .9155425 1990 11 1990 .9918037 0 1
1 "Mwnfvh Kamwd" "Bhhhk Sfnvh" 1990 "Hindu" .7049773 .9155425 1991 11 1990 .7049773 0 1
1 "Inda Swfnf" "Bhhhk Sfnvh" 1996 "Hindu" .9918037 .9155425 1992 11 1990 .9918037 0 1
1 "Inda Swfnf" "Bhhhk Sfnvh" 1996 "Hindu" .9918037 .9155425 1993 11 1990 .9918037 0 1
1 "Mwnfvh Kamwd" "Bhhhk Sfnvh" 1990 "Hindu" .7049773 .9155425 1994 11 1990 .7049773 0 1
1 "Inda Swfnf" "Bhhhk Sfnvh" 1996 "Hindu" .9918037 .9155425 1995 11 1990 .9918037 0 1
1 "Mwnfvh Kamwd" "Bhhhk Sfnvh" 1990 "Hindu" .7049773 .9155425 1996 11 1990 .7049773 0 1
1 "Inda Swfnf" "Bhhhk Sfnvh" 1996 "Hindu" .9918037 .9155425 1997 11 1990 .9918037 0 1
2 "Rwhad Swfnf" "Bhhhk Sfnvh Swfnf" 1993 "Hindu" .9951079 .9960787 1987 11 1992 .9960787 1 1
2 "Dfnvvh Swfnf" "Bhhhk Sfnvh Swfnf" 1992 "Hindu" .9971012 .9960787 1988 11 1992 .9960787 0 1
2 "Dfnvvh Swfnf" "Bhhhk Sfnvh Swfnf" 1992 "Hindu" .9971012 .9960787 1989 11 1992 .9960787 0 1
2 "Dfnvvh Swfnf" "Bhhhk Sfnvh Swfnf" 1992 "Hindu" .9971012 .9960787 1990 11 1992 .9960787 0 1
2 "Rwhad Swfnf" "Bhhhk Sfnvh Swfnf" 1993 "Hindu" .9951079 .9960787 1991 11 1992 .9960787 0 1
2 "Rwhad Swfnf" "Bhhhk Sfnvh Swfnf" 1993 "Hindu" .9951079 .9960787 1992 11 1992 .9951079 0 1
2 "Rwhad Swfnf" "Bhhhk Sfnvh Swfnf" 1993 "Hindu" .9951079 .9960787 1993 11 1992 .9951079 0 1
2 "Rwhad Swfnf" "Bhhhk Sfnvh Swfnf" 1993 "Hindu" .9951079 .9960787 1994 11 1992 .9951079 0 1
2 "Dfnvvh Swfnf" "Bhhhk Sfnvh Swfnf" 1992 "Hindu" .9971012 .9960787 1995 11 1992 .9971012 0 1
2 "Rwhad Swfnf" "Bhhhk Sfnvh Swfnf" 1993 "Hindu" .9951079 .9960787 1996 11 1992 .9951079 0 1
2 "Rwhad Swfnf" "Bhhhk Sfnvh Swfnf" 1993 "Hindu" .9951079 .9960787 1997 11 1992 .9951079 0 1
3 "Kfdxf" "Swxyw Dvv Swfnf" 1992 "Hindu" .9840044 .9942695 1987 11 1992 .9942695 1 1
3 "Radhf" "Swxyw Dvv Swfnf" 1994 "Hindu" .8159367 .9942695 1988 11 1992 .9942695 0 1
3 "Kfdxf" "Swxyw Dvv Swfnf" 1992 "Hindu" .9840044 .9942695 1989 11 1992 .9942695 0 1
3 "Radhf" "Swxyw Dvv Swfnf" 1994 "Hindu" .8159367 .9942695 1990 11 1992 .9942695 0 1
3 "Radhf" "Swxyw Dvv Swfnf" 1994 "Hindu" .8159367 .9942695 1991 11 1992 .9942695 0 1
3 "Radhf" "Swxyw Dvv Swfnf" 1994 "Hindu" .8159367 .9942695 1992 11 1992 .8159367 0 1
3 "Kfdxf" "Swxyw Dvv Swfnf" 1992 "Hindu" .9840044 .9942695 1993 11 1992 .9840044 0 1
3 "Kfdxf" "Swxyw Dvv Swfnf" 1992 "Hindu" .9840044 .9942695 1994 11 1992 .9840044 0 1
3 "Radhf" "Swxyw Dvv Swfnf" 1994 "Hindu" .8159367 .9942695 1995 11 1992 .8159367 0 1
3 "Radhf" "Swxyw Dvv Swfnf" 1994 "Hindu" .8159367 .9942695 1996 11 1992 .8159367 0 1
3 "Kfdxf" "Swxyw Dvv Swfnf" 1992 "Hindu" .9840044 .9942695 1997 11 1992 .9840044 0 1
4 "Bhwdwx Bhavhwn" "Swxyw Pwd" 1992 "Hindu" .9844022 .9962896 1987 11 1992 .9962896 1 1
4 "Bhwdwx Bhavhwn" "Swxyw Pwd" 1992 "Hindu" .9844022 .9962896 1988 11 1992 .9962896 0 1
4 "Hwdfhm" "Swxyw Pwd" 1994 "Hindu" .3499433 .9962896 1989 11 1992 .9962896 0 1
4 "Hwdfhm" "Swxyw Pwd" 1994 "Hindu" .3499433 .9962896 1990 11 1992 .9962896 0 1
4 "Hwdfhm" "Swxyw Pwd" 1994 "Hindu" .3499433 .9962896 1991 11 1992 .9962896 0 1
4 "Bhwdwx Bhavhwn" "Swxyw Pwd" 1992 "Hindu" .9844022 .9962896 1992 11 1992 .9844022 0 1
4 "Hwdfhm" "Swxyw Pwd" 1994 "Hindu" .3499433 .9962896 1993 11 1992 .3499433 0 1
4 "Bhwdwx Bhavhwn" "Swxyw Pwd" 1992 "Hindu" .9844022 .9962896 1994 11 1992 .9844022 0 1
4 "Bhwdwx Bhavhwn" "Swxyw Pwd" 1992 "Hindu" .9844022 .9962896 1995 11 1992 .9844022 0 1
4 "Hwdfhm" "Swxyw Pwd" 1994 "Hindu" .3499433 .9962896 1996 11 1992 .3499433 0 1
4 "Bhwdwx Bhavhwn" "Swxyw Pwd" 1992 "Hindu" .9844022 .9962896 1997 11 1992 .9844022 0 1
5 "Shhwn Pwd" "Jwf Bhwvwwn" 1994 "Hindu" .8743593 .8680474 1987 11 1989 .8680474 1 1
5 "Tvvnw" "Jwf Bhwvwwn" 1989 "Hindu" .7304577 .8680474 1988 11 1989 .8680474 0 1
5 "Shhwn Pwd" "Jwf Bhwvwwn" 1994 "Hindu" .8743593 .8680474 1989 11 1989 .8743593 0 1
5 "Shhwn Pwd" "Jwf Bhwvwwn" 1994 "Hindu" .8743593 .8680474 1990 11 1989 .8743593 0 1
5 "Tvvnw" "Jwf Bhwvwwn" 1989 "Hindu" .7304577 .8680474 1991 11 1989 .7304577 0 1
5 "Shhwn Pwd" "Jwf Bhwvwwn" 1994 "Hindu" .8743593 .8680474 1992 11 1989 .8743593 0 1
5 "Shhwn Pwd" "Jwf Bhwvwwn" 1994 "Hindu" .8743593 .8680474 1993 11 1989 .8743593 0 1
5 "Shhwn Pwd" "Jwf Bhwvwwn" 1994 "Hindu" .8743593 .8680474 1994 11 1989 .8743593 0 1
5 "Tvvnw" "Jwf Bhwvwwn" 1989 "Hindu" .7304577 .8680474 1995 11 1989 .7304577 0 1
5 "Tvvnw" "Jwf Bhwvwwn" 1989 "Hindu" .7304577 .8680474 1996 11 1989 .7304577 0 1
5 "Tvvnw" "Jwf Bhwvwwn" 1989 "Hindu" .7304577 .8680474 1997 11 1989 .7304577 0 1
6 "Phhjw" "Kdfvhwn Kamwd" 1990 "Hindu" .4431141 .9756482 1987 11 1990 .9756482 1 1
6 "Phhjw" "Kdfvhwn Kamwd" 1990 "Hindu" .4431141 .9756482 1988 11 1990 .9756482 0 1
6 "Jwnwk" "Kdfvhwn Kamwd" 1993 "Hindu" .9848574 .9756482 1989 11 1990 .9756482 0 1
6 "Phhjw" "Kdfvhwn Kamwd" 1990 "Hindu" .4431141 .9756482 1990 11 1990 .4431141 0 1
6 "Phhjw" "Kdfvhwn Kamwd" 1990 "Hindu" .4431141 .9756482 1991 11 1990 .4431141 0 1
6 "Jwnwk" "Kdfvhwn Kamwd" 1993 "Hindu" .9848574 .9756482 1992 11 1990 .9848574 0 1
6 "Jwnwk" "Kdfvhwn Kamwd" 1993 "Hindu" .9848574 .9756482 1993 11 1990 .9848574 0 1
6 "Jwnwk" "Kdfvhwn Kamwd" 1993 "Hindu" .9848574 .9756482 1994 11 1990 .9848574 0 1
6 "Phhjw" "Kdfvhwn Kamwd" 1990 "Hindu" .4431141 .9756482 1995 11 1990 .4431141 0 1
6 "Jwnwk" "Kdfvhwn Kamwd" 1993 "Hindu" .9848574 .9756482 1996 11 1990 .9848574 0 1
6 "Jwnwk" "Kdfvhwn Kamwd" 1993 "Hindu" .9848574 .9756482 1997 11 1990 .9848574 0 1
7 "Rhhfx" "Rwjjfd" 1989 "Hindu" .6848928 .9323343 1987 11 1989 .9323343 1 1
7 "Rhhfx" "Rwjjfd" 1989 "Hindu" .6848928 .9323343 1988 11 1989 .9323343 0 1
7 "Rhhfx" "Rwjjfd" 1989 "Hindu" .6848928 .9323343 1989 11 1989 .6848928 0 1
7 "Rhhfx" "Rwjjfd" 1989 "Hindu" .6848928 .9323343 1990 11 1989 .6848928 0 1
7 "Mhhfx Kamwd" "Rwjjfd" 1994 "Hindu" .6835536 .9323343 1991 11 1989 .6835536 0 1
7 "Mhhfx Kamwd" "Rwjjfd" 1994 "Hindu" .6835536 .9323343 1992 11 1989 .6835536 0 1
7 "Rhhfx" "Rwjjfd" 1989 "Hindu" .6848928 .9323343 1993 11 1989 .6848928 0 1
7 "Mhhfx Kamwd" "Rwjjfd" 1994 "Hindu" .6835536 .9323343 1994 11 1989 .6835536 0 1
7 "Mhhfx Kamwd" "Rwjjfd" 1994 "Hindu" .6835536 .9323343 1995 11 1989 .6835536 0 1
7 "Rhhfx" "Rwjjfd" 1989 "Hindu" .6848928 .9323343 1996 11 1989 .6848928 0 1
7 "Mhhfx Kamwd" "Rwjjfd" 1994 "Hindu" .6835536 .9323343 1997 11 1989 .6835536 0 1
8 "Rwvf Kwnx" "Akvhwy Kamwd" 1990 "Hindu" .9438493 .8202123 1987 11 1990 .8202123 1 1
8 "Rwvf Kwnx" "Akvhwy Kamwd" 1990 "Hindu" .9438493 .8202123 1988 11 1990 .8202123 0 1
8 "Hfmwnvha" "Akvhwy Kamwd" 1993 "Hindu" .5292737 .8202123 1989 11 1990 .8202123 0 1
8 "Rwvf Kwnx" "Akvhwy Kamwd" 1990 "Hindu" .9438493 .8202123 1990 11 1990 .9438493 0 1
8 "Hfmwnvha" "Akvhwy Kamwd" 1993 "Hindu" .5292737 .8202123 1991 11 1990 .5292737 0 1
8 "Hfmwnvha" "Akvhwy Kamwd" 1993 "Hindu" .5292737 .8202123 1992 11 1990 .5292737 0 1
8 "Hfmwnvha" "Akvhwy Kamwd" 1993 "Hindu" .5292737 .8202123 1993 11 1990 .5292737 0 1
8 "Hfmwnvha" "Akvhwy Kamwd" 1993 "Hindu" .5292737 .8202123 1994 11 1990 .5292737 0 1
8 "Rwvf Kwnx" "Akvhwy Kamwd" 1990 "Hindu" .9438493 .8202123 1995 11 1990 .9438493 0 1
8 "Rwvf Kwnx" "Akvhwy Kamwd" 1990 "Hindu" .9438493 .8202123 1996 11 1990 .9438493 0 1
8 "Rwvf Kwnx" "Akvhwy Kamwd" 1990 "Hindu" .9438493 .8202123 1997 11 1990 .9438493 0 1
9 "Nvvdwj" "Bwdkfvhwn" 1990 "Hindu" .242285 .7505836 1987 11 1990 .7505836 1 1
9 "Mwnhj Kamwd" "Bwdkfvhwn" 1994 "Hindu" .8745513 .7505836 1988 11 1990 .7505836 0 1
9 "Nvvdwj" "Bwdkfvhwn" 1990 "Hindu" .242285 .7505836 1989 11 1990 .7505836 0 1
9 "Nvvdwj" "Bwdkfvhwn" 1990 "Hindu" .242285 .7505836 1990 11 1990 .242285 0 1
9 "Mwnhj Kamwd" "Bwdkfvhwn" 1994 "Hindu" .8745513 .7505836 1991 11 1990 .8745513 0 1
9 "Phhnwm" "Bwdkfvhwn" 1992 "Hindu" .7023188 .7505836 1992 11 1990 .7023188 0 1
9 "Phhnwm" "Bwdkfvhwn" 1992 "Hindu" .7023188 .7505836 1993 11 1990 .7023188 0 1
9 "Phhnwm" "Bwdkfvhwn" 1992 "Hindu" .7023188 .7505836 1994 11 1990 .7023188 0 1
9 "Nvvdwj" "Bwdkfvhwn" 1990 "Hindu" .242285 .7505836 1995 11 1990 .242285 0 1
9 "Mwnhj Kamwd" "Bwdkfvhwn" 1994 "Hindu" .8745513 .7505836 1996 11 1990 .8745513 0 1
9 "Mwnhj Kamwd" "Bwdkfvhwn" 1994 "Hindu" .8745513 .7505836 1997 11 1990 .8745513 0 1
10 "Vfkwv" "Dhwdwmkwd" 1998 "Hindu" .6458625 .9987964 1987 11 1992 .9987964 1 1
end
label values num_religion num_religion
label def num_religion 1 "Hindu", modify
[/CODE]

[Ken Chui]

egen unique_fam = tag(family_id) if religion == "Muslim"
tabulate unique_fam

The frequency of "1" is the number of unique family IDs with Muslim being the reported religion.

[Luis Mijares Castaneda]

I tried using your code and got this error

unknown egen function tab()

[Ken Chui]

I tried using your code and got this error

unknown egen function tab()

My apology. I made a typo. It's "tag". I've revised my code in #2.

[Nick Cox]

See also https://journals.sagepub.com/doi/pdf...867X0800800408 for a discussion of principles and practice.