DATA Step, Macro, Functions and more

How to get Max value of a column

Accepted Solution Solved
Reply
Contributor
Posts: 47
Accepted Solution

How to get Max value of a column

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

 


Accepted Solutions
Solution
‎05-12-2017 05:40 PM
PROC Star
Posts: 7,468

Re: How to get Max value of a column

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

 

View solution in original post


All Replies
Solution
‎05-12-2017 05:40 PM
PROC Star
Posts: 7,468

Re: How to get Max value of a column

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

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 434 views
  • 2 likes
  • 2 in conversation