Panel data: how to draw a figure/table where we can see when households drop out and others come in?

[Michael Duarte Goncalves]

Hi everyone,

I have a panel data of households about electricity contracts and consumption. And, as it is usual in survey data, some households dropped out, and others came in.
I would like to know how can I obtain a figure/table in which we can observe when people came in or dropped out of our sample.

Here is a dataex:

* Example generated by -dataex-. For more info, type help dataex
clear
input long(id idcontrato) double(date_contract_start date_contract_end)
1103 1745245 22646 22676
1103 2018830 22677 22735
1103 2254240 22736 23010
1103 2709626 23011 23100
1103 3141169 23101     .
1104    1104 18914 21639
1104  427048 21640 21651
1104  434563 21652 22046
1104  699461 22047 22400
1104  968558 22401 22431
1104 1042456 22432 22645
1104 1732058 22646 22676
1104 2003646 22677 22735
1104 2256061 22736 23010
1104 2718762 23011 23069
1104 3077033 23070 23130
end
format %td date_contract_start
format %td date_contract_end

I really don't know how to proceed with this.
Could anyone help me, please?

Thank you very much.
Michael

[Michael Duarte Goncalves]

Hi,

I would like to have a figure like this one please:

Thank you very much.
Michael