Displaying 1 result from an estimated 1 matches for "countvariable".
2007 Aug 09
2
Countvariable for id by date
...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...F20001,F20002...
2. “countF2129”: another “countvariable” that shows which in order (by date) the id has if it fulfils...