This function fills all episodes of the case with a value from a specified attribute or constant. The syntax is:
fill from expression
where expression can be:
- an attribute, (e.g. fill from Glucose) or
- a sample identified by an expression (e.g. fill from last Glucose), or
- a constant, (e.g. fill from EXP), or
- a string or number, (e.g. fill from “positive”).
Example 1
The case below has an attribute Admit Time which only has a value in the current sample, which is “9:44”.
01 Jun 09 20 Jun 09 30 Jun 09 15 Oct 09 02 Nov 09 Admit Time 9:44
Now suppose we want to create a Calculated Value Attribute, say Current_Admit_Time which puts the current Admit Time into every episode. This is done using the expression “fill from Admit Time”. The current value of Admit Time will be used.
The case now becomes:
01 Jun 09 20 Jun 09 30 Jun 09 15 Oct 09 02 Nov 09 Admit Time 9:44 Current_Admit_Time 9:44 9:44 9:44 9:44 9:44
Example 2
The case below has an attribute Glucose which only has a maximum value of 15.1.
01 Jun 09 20 Jun 09 30 Jun 09 15 Oct 09 02 Nov 09 Glucose 10.2 12.3 15.1 14.0 9.5
Now suppose we want to create a Calculated Value Attribute, say Max_Glucose which puts the maximum value of Glucose into every episode. This is done using the expression “fill from max Glucose”.
The case now becomes:
01 Jun 09 20 Jun 09 30 Jun 09 15 Oct 09 02 Nov 09 Glucose 10.2 12.3 15.1 14.0 9.5 Max_Glucose 15.1 15.1 15.1 15.1 15.1