Substitution transformations REPLACE RESCALE SEQ SET SUB SPLIT

REPLACE

!REPLACE old new replaces data values old with new values new in the current variable.


IF(DataValue.EQ.Old) DataValue=New
 Rate !REPLACE -9 0

RESCALE

!RESCALE o s rescales the column(s) in the current (!G group of) variable, or !G group of variables, by adding o and scaling the result by s
 Rate !RESCALE -10 0.1

SEQ

!SEQ replaces the data value with a sequential number starting at 1 which increments whenever the data value changes between successive records; the current field is presumed to define a factor and the number of levels in the new factor is set to the number of levels identified in this sequential process. Missing values remain missing.
 plot !=V3 !SEQ

SET

!SET vlist for a list of n values, vlist, replaces the data values 1:n by the corresponding element from vlist; data values less than 1 or greater than n are replaced by zero.

vlist may run over several lines provided each incomplete line ends with a comma, i.e., a comma is used as a continuation symbol.
 treat !L C A B
 CvR !=treat !SET 1 -1 -1
 group !=treat !SET 1,
    2 2 3 3 4

SUB

!SUB vlist replaces data values which appear in the list vlist with their position number. Data values not found in vlist are set to 0.0.

vlist may run over several lines provided each incomplete line ends with a comma. ASReml allows for a small rounding error when matching. It may not distinguish properly if values in vlist only differ in the sixth decimal place.
  year 3 !SUB 1966 1967 1968

SPLIT

!SPLIT g creates a new (set of) variables by splitting the data value in an existing (set of) variables g. A number greater than 99 represented as abcd is changed to ab and the new variable is cd. A number less than 100 represented as bd is changed to b and the new variable is d.

!SPLIT provides for the situation when marker data is given in a compressed form: that is a value of 12 actually means the allelic pair 1 and 2. The transformation is simple minded. If the data value is less than 100, it is split into two single digit numbers. Otherwise the last two digits are split off (so that 123 becomes 1 and 23). The prototye example is
 Lallele !G 10 6
 Rallele !G 10 6 !SPLIT Lallele
assuming the data values corresponding to Lallele are drawn from the set (11:16, 21:26, 31:36, 41:46, 51:56, 61:66). The transformation replaces the data value with the value of the first digit, and puts the second digit value into Rallele.
  • Back to transformation summary

    Return to index