How to get Max value of a column

[zqkal]

Hello everyone,

I need to find the maximum value of a variable looking at all the previous values in the column. i have a dataset that looks the one listed below. i want to create a variable v4 with the maximum value of all the previous values in the column. 

DATASET 1
V1 V2 V3
01 AA 02

01 AA 08

01 AA 03
02 BB 24
02 BB 98

02 BB 24

03 CC 11

03 CC 99

03 CC 15
02 DD 54


DATASET 2
V1 V2 V3 v4 

01 AA 02 02

01 AA 08 08

01 AA 03 08
02 BB 24 24
02 BB 98 98

02 BB 24 98

03 CC 11 98

03 CC 99 99

03 CC 15 99
02 DD 54 99

[art297 · Accepted solution]

data DATASET1;
  input (V1 V2 V3) ($);
  cards;
01 AA 02
01 AA 08
01 AA 03
02 BB 24
02 BB 98
02 BB 24
03 CC 11
03 CC 99
03 CC 15
02 DD 54
;

data dataset2;
  set dataset1;
  retain v4;
  v4=max(v3,v4);
run;

Art, CEO, AnalystFinder.com