Compter le nombre de jours consécutifs selon 2 critères

Bonjour,

Je te propose cette solution:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
 
 
Data test;
format id z15. date date9.;
input id  date  date9.;
cards;
001250000100003	08MAR2012
001250000100003	09MAR2012
001250000100003	10MAR2012
001250000100003	11MAR2012
001250000100003	13MAR2012
001250000100003	23SEP2013
001250000100003	24SEP2013
001250000100005	21MAR2012
001250000100005	30SEP2013
001250000100005	15MAR2012
001250000100005	16MAR2012
001250000100005	17MAR2012
001250000100005	18MAR2012
001250000100005	20MAR2012
;run;
 
proc sort data =test; by id date; run;
 
data test1 (drop=lag_date) ;
  set test  ;
  format lag_date date9.;
  lag_date=lag(date) ;
  by id date;
  retain nbr;
 
  if first.id then do;
  nbr=1;
  end;
  if date-lag_date=1 then
   nbr+1;
  else nbr=1;
 
run;

Cordialement