Displaying 1 result from an estimated 1 matches for "f323".
Did you mean:
f32
2007 Aug 09
2
Countvariable for id by date
...isterdata) with four columns: id, dg1, dg2 and date(YYYY-MM-DD) of interest:
id;dg1;dg2;date;
1;F28;;1997-11-04;
1;F20;F702;1998-11-09;
1;F20;;1997-12-03;
1;F208;;2001-03-18;
2;F32;;1999-03-07;
2;F29;F32;2000-01-06;
2;F32;;2003-07-05;
2;F323;F2800;2000-02-05;
...
I would like o have two additional columns:
1. “countF20”: a “countvariable” that shows which in order (by date) the id has if it fulfils the following logical expression: dg1 = F20* OR dg2 = F20*,
where * means F201,F202... F2001,F2002...F...