Hello! I am having some troubles in doing some analysis with stata.
I have a dataset in which each raw represents an household that could be composed by a maximum number of 6 people. The variables conprof* refer to the occupational status of each household member, in particular 2 means unemployed. The variable coeff is used as weight for each household.
What follows is an example of how my dataset is built.

Code:
clear
input byte(conprof1 conprof2 conprof3 conprof4 conprof5 conprof6) double coeff
2 1 2 . . .  590.27028
2 2 2 . . . 1339.21721
2 2 . . . . 1196.43504
2 1 1 2 . .     168.75
2 2 4 . . .  373.10946
2 2 1 . . . 1528.00751
2 2 . . . . 1638.18854
2 2 . . . . 1142.63984
2 2 . . . .  764.71468
2 2 . . . .  751.01047
2 1 2 4 . .  753.32879
2 2 . . . .  1323.0436
2 1 2 2 . .  718.52977
2 2 . . . . 1227.99028
2 1 2 2 . . 1178.57795
2 2 . . . . 2148.28157
2 1 2 . . .  876.54834
2 2 4 4 . .   1178.836
2 2 2 1 . 2  875.58562
2 4 4 2 . .  879.83198
2 2 . . . .  351.51266
2 2 1 . . .  632.80426
2 1 2 2 2 .  259.68247
2 2 . . . .  347.96527
2 2 1 4 . .  464.83877
2 2 4 . . .  229.23751
2 1 2 . . . 1218.22996
2 4 2 8 . . 1336.40534
2 2 . . . . 1200.79717
2 2 . . . . 1373.21638
end
I am interested in knowing the total number and the share of unemployed people in my dataset, and then, by using the household weight, I want to obtain an estimate of the number and of the share of unemployed people in the entire population.

Do you have any suggestions on how to do this?
Thank you for your help.