## How to create a new variable with highest number from 3 other variables?

Solved
Frequent Contributor
Posts: 87

# How to create a new variable with highest number from 3 other variables?

Dear All,

I have a data file showed below:

ID  a1  b1  c1

1   23  35  61

2   76  71  10

3   90        60

4        31   50

5   70 42

6   35 67  89

I want create a new variable 'd1' with highest number from a1, b1, c1.

Accepted Solutions
Solution
‎11-03-2014 02:50 PM
Posts: 1,270

## Re: How to create a new variable with highest number from 3 other variables?

data have;

input ID  a1  b1  c1;

d1=max(of a1--c1);

datalines;

1   23  35  61

2   76  71  10

3   90  .   60

4    .  31  50

5   70  42  .

6   35  67  89

;

All Replies
Super User
Posts: 5,884

## Re: How to create a new variable with highest number from 3 other variables?

max()

Data never sleeps
Solution
‎11-03-2014 02:50 PM
Posts: 1,270

## Re: How to create a new variable with highest number from 3 other variables?

data have;

input ID  a1  b1  c1;

d1=max(of a1--c1);

datalines;

1   23  35  61

2   76  71  10

3   90  .   60

4    .  31  50

5   70  42  .

6   35  67  89

;

Frequent Contributor
Posts: 87

## Re: How to create a new variable with highest number from 3 other variables?

Hi stat@sas and Linush,