|
I HAVE A DATA THAT LOOKS LIKE THIS
sub visit type score
101 1 A 13
101 1 B 14
101 1 C 26
101 1 D 88
101 1 E .
101 2 A 12
101 2 B 24
101 2 C .
101 2 D .
101 2 E 89
101 3 A 11
101 3 B 15
101 3 C 14
101 3 D 29
101 3 E 89
IF NUMBER OF MISSING SCORES IN A VISIT ARE GREATER THAN OR EQUAL TO
TWO (>= 2) THEN NEW_SCORE SHOULD BE MISSING;
ELSE THE NEW_SCORE SHOULD BE = (SUM OF NON MISSING SCORE)/(NUMBER OF
NON MISSING SCORE) FOR EACH VISIT.
THANKS A LOT IN ADVANCE
| 
