Count number of days in month that spell covered

[Henry Strawforrd]

I have spell data containing beginning and end date of spell at daily level. I am looping through months and would like to count in each month the number of days that are covered by the spell.

For example, if start date is 30.03.2010 and end date is 30.12.2010, then the variable should count 2 days in March 2010 and 30 days in April 2010 etc.

[Nick Cox]

Duplicate post. If interested, please follow https://www.statalist.org/forums/for...vered-by-spell

[Henry Strawforrd]

Here is dataex

* Example generated by -dataex-. For more info, type help dataex
clear
input long(persnr betnr) byte(spell quelle) int(begepi endepi erwstat)
988050 2654539  1 1  5479  5843   101
988050 2654539  2 1  5844  6209   101
988050 2654539  3 1  6210  6574   101
988050 2654539  4 1  6575  6939   101
988050 2654539  5 1  6940  7304   101
988050 2654539  6 1  7305  7581   101
988050 2654539  7 1  7582  7670   101
988050 2654539  8 1  8766  9131   101
988050 2654539  9 1  9132  9496   101
988050 2654539 10 1  9497  9861   101
988050 2654539 11 1  9862 10226   101
988050 2654539 12 1 10227 10291   102
988050      .n 13 2 10367 10760    11
988102 2683136  1 1 14976 15340   101
988102 2683136  2 1 15341 15705   109
988102 2683136  3 1 15706 15867   101
988102 2797563  4 1 16071 16436   109
988102 2797563  5 1 16437 16736   101
988102 2026217  6 1 16737 16801   101
988102 2026217  7 1 16802 17163   101
988102 2026217  8 1 17164 17166   101
988102 2026217  9 1 17167 17531   101
988102 2026217 10 1 17532 17673   101
988102 2026217 11 1 17674 17897   101
988102      .n 12 6 17674 17897    33
988102 2026217 13 1 17898 17952   109
988102      .n 14 6 17898 17952    33
988102      .n 15 2 17953 18118    11
988102      .n 16 6 17953 18118    33
988102      .n 17 2 18119 18205    11
988102      .n 18 6 18119 18205    31
988102      .n 19 2 18206 18210    11
988102      .n 20 4 18206 18210 10001
988102      .n 21 6 18206 18210    31
988102      .n 22 2 18211 18227    11
988102      .n 23 6 18211 18227    33
988102 2184204 24 1 18228 18250   109
988102 2184204 25 1 18251 18262   101
988102 2184204 26 1 18263 18627   109
988102 2184204 27 1 18628 18875   101
988102 2184204 28 1 18876 18992   101
988102 2184204 29 1 18993 19307   101
988102 1861604 30 1 19308 19358   101
988102 1861604 31 1 19359 19723   101
988102 1861604 32 1 19724 20088   101
988102 1861604 33 1 20089 20453   101
988102 1861604 34 1 20454 20624   101
988102 1861604 35 1 20625 20673   101
988102      .n 36 6 20625 20673    33
988102 1861604 37 1 20674 20711   101
988196 2482619  1 1  7944  8035   101
988196 2482619  2 1  8036  8400   101
988196 2482619  3 1  8401  8765   101
988196 2482619  4 1  8766  9131   101
988196 2482619  5 1  9132  9496   101
988196 2482619  6 1  9497  9861   101
988196 2482619  7 1  9862 10206   101
988196      .n  8 2 10207 10866    11
988196      .n  9 6 13460 14180    33
988260      .n  1 2 11323 11465    12
988260 1728968  2 1 11466 11660   101
988260      .n  3 2 11466 11660    12
988260      .n  4 2 11661 11667    12
988260 1661662  5 1 11688 11894   101
988260      .n  6 2 11895 11919    11
988260 1917100  7 1 11920 11960   101
988260      .n  8 2 11920 11960    11
988260 1917100  9 1 11961 12053   101
988260 1917100 10 1 12054 12063   101
988260 1298705 11 1 12099 12133   101
988260 2419355 12 1 12134 12183   101
988260 1298705 13 1 12134 12183   101
988260 2419355 14 1 12184 12280   101
988260      .n 15 2 12318 12431    11
988260 2065348 16 1 12434 12450   101
988260      .n 17 2 12501 12506    11
988260 2517749 18 1 12544 12638   101
988260 2738108 19 1 12766 12783   101
988260 2738108 20 1 12784 13148   101
988260 2738108 21 1 13149 13319   101
988260 2738108 22 1 13320 13514   101
988260      .n 23 6 13320 13514    31
988260      .n 24 2 13515 13795    11
988260      .n 25 6 13515 13795    31
988260      .n 26 2 13796 13842    11
988260      .n 27 6 13796 13842    31
988260      .n 28 2 13843 13888    11
988260      .n 29 6 13843 13888    33
988260 2738108 30 1 13889 13959   101
988260      .n 31 2 13889 13959    11
988260 2738108 32 1 13960 13974   101
988260 1896655 33 1 13975 14108   101
988260      .n 34 2 14109 14282    12
988260      .n 35 6 14109 14282    31
988260      .n 36 2 14317 14398    11
988260      .n 37 6 14317 14398    31
988260      .n 38 2 14399 14729    11
988260      .n 39 6 14399 14729    31
988260      .n 40 2 14730 14822    11
988260      .n 41 6 14730 14822    31
end
format %tdD_m_CY begepi
format %tdD_m_CY endepi
label values betnr miss_de
label def miss_de .n ".n Fehlt syst.", modify
label values quelle quelle_de
label def quelle_de 1 "1 BeH Beschaeftigtenhistorik", modify
label def quelle_de 2 "2 LEH Leistungsempfaengerhistorik", modify
label def quelle_de 4 "4 MTH Massnahmeteilnahmehistorik", modify
label def quelle_de 6 "6 ASU Arbeitsuchendenhistorik", modify
label values erwstat erwstat_de
label def erwstat_de 11 "11 ALG Arbeitslosengeld", modify
label def erwstat_de 12 "12 ALHI Arbeitslosenhilfe", modify
label def erwstat_de 31 "31 Arbeitslos (ALO)", modify
label def erwstat_de 33 "33 Nicht arbeitslos arbeitssuchend (NALO)", modify
label def erwstat_de 101 "101 Sozialversicherungspflichtig Beschaeftigte ohne besondere Merkmale", modify
label def erwstat_de 102 "102 Auszubildende ohne besondere Merkmale", modify
label def erwstat_de 109 "109 Geringfuegig Beschaeftigte", modify
label def erwstat_de 10001 "10001 Aktivierung und berufliche Eingliederung", modify

[Nick Cox]

#2 again. Presumably you posted twice by accident, but please don't do it on purpose. No-one wants to have to read two threads to see if their contribution has already been said in the other thread.

[Henry Strawforrd]

yes, sorry!