topic Re: How to create a new variable with highest number from 3 other variables? in SAS Programming

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

xinjian — Mon, 03 Nov 2014 19:45:01 GMT

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.

Thanks for your help.

LinusH — Mon, 03 Nov 2014 19:46:03 GMT

max()

stat_sas — Mon, 03 Nov 2014 19:50:55 GMT

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

;

xinjian — Mon, 03 Nov 2014 20:18:04 GMT

Hi stat@sas and Linush,

Thanks so much for your quick response. I appreciate your help.