Replace Values Higher than n (Updated)

This is a version of syntax Replace values higher than n by the mean of the other values, adapted to capabilities of modern SPSS versions (tested with IBM SPSS Statistics 24). Code is much simpler as we don't need anymore to store aggregated values to external file and match it with original data. AGGREGATE command simply saves aggregates to the original file as new variable. There are just 4 steps remain: calculate 'valid' values, aggregate over them, apply condition with replacing value, and (optionally) delete extra variables.

* Encoding: UTF-8.
* Topic: replacing values, greater then specified value by mean for the remaining cases.

* Data example.
DATA LIST LIST /hrt clientid linenum.
BEGIN DATA
485     1002        1
280     1002        2
100     1002        3
420     1002        4
410     1002        5
510     1002        6
END DATA.
LIST.

* Solution.
IF hrt<=480 hrt_norm = hrt.

AGGREGATE
  /OUTFILE=* MODE=ADDVARIABLES
  /meanhrt = MEAN(hrt_norm).

IF hrt>480 hrt=meanhrt.
EXECUTE.

* Delete temporary variables.
DELETE VARIABLES hrt_norm meanhrt.

You may note, there is no BREAK subcommand in AGGREGATE: in modern SPSS version if you aggregating over the whole file this subcommand can be omitted, as well as no need to create dummy nobreak variable. You may also note relatively new DELETE VARIABLES command for clearing temporary variables. ADD FILES with KEEP subcommand (as in original syntax) is still preferrable in general as it allows at the same time not only keep needed variables but also reorder them.

Replace values higher than n by the mean of the other values

Navigate from here