topic Re: want to create a max base in SAS Programming

want to create a max base

TarunKumar — Thu, 27 Feb 2014 10:06:45 GMT

Dear Freinds,

need yout help in this .

data test;

input ANR_Q1 ANR_Q2 ANR_Q3;

datalines;

1 2 5

9 6 3

8 9 3

5 6 7

4 6 3

;RUN;

want to output like this

ANR_Q1 ANR_Q2 ANR_Q3 Base;

1 2 5 5

9 6 3 9

8 9 3 9

5 6 7 7

4 6 3 6

Re: want to create a max base

Xianhua_zeng — Thu, 27 Feb 2014 10:29:12 GMT

data want;

set test;

array have(*) ANR_Q1 ANR_Q2 ANR_Q3;

array temp(3);

do i=1 to dim(have);

temp(i)=have(i);

end;

call sortn(of temp:);

Base=temp3;

drop i temp:;

run;

Re: want to create a max base

stataddict — Thu, 27 Feb 2014 11:57:21 GMT

simply take a maximum:

data max_base;

set test;

Base = max(of ANR_Q1 - ANR_Q3);

run;

Re: want to create a max base

TarunKumar — Thu, 27 Feb 2014 12:37:32 GMT

not working

Re: want to create a max base

TarunKumar — Thu, 27 Feb 2014 12:40:29 GMT

thanx a lot

Re: want to create a max base

data_null__ — Thu, 27 Feb 2014 13:41:02 GMT

Your reply to @stataddict is less thank helpful. Since you simply want to find the max of a "list of variables" I believe that is correct. I'm guessing you left out OF before the variable list.

Re: want to create a max base

Trancho — Fri, 28 Feb 2014 08:54:40 GMT

Simply use the following code :

DATA TEST;

INPUT ANR_Q1 ANR_Q2 ANR_Q3;
BASE = MAX (OF ANR_Q1 - ANR_Q3);

DATALINES;

1 2 5

9 6 3

8 9 3

5 6 7

4 6 3

;

Re: want to create a max base

TarunKumar — Fri, 28 Feb 2014 11:45:40 GMT

@stataddict my Apologies i think i left of in the code

Re: want to create a max base

TarunKumar — Fri, 28 Feb 2014 11:46:36 GMT

you are correct it was my mistake

Re: want to create a max base

stataddict — Fri, 28 Feb 2014 11:59:22 GMT

No problem