want to create a max base

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 77
Accepted Solution

want to create a max base

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


Accepted Solutions
Solution
‎02-27-2014 05:29 AM
Occasional Contributor
Posts: 12

Re: want to create a max base

Posted in reply to TarunKumar

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 tempSmiley Happy;

     Base=temp3;

     drop i temp:;

run;

View solution in original post


All Replies
Solution
‎02-27-2014 05:29 AM
Occasional Contributor
Posts: 12

Re: want to create a max base

Posted in reply to TarunKumar

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 tempSmiley Happy;

     Base=temp3;

     drop i temp:;

run;

Frequent Contributor
Posts: 77

Re: want to create a max base

Posted in reply to Xianhua_zeng

thanx a lot

Occasional Contributor
Posts: 14

Re: want to create a max base

Posted in reply to TarunKumar

simply take a maximum:

data max_base;

set test;

Base = max(of ANR_Q1 - ANR_Q3);

run;

Frequent Contributor
Posts: 77

Re: want to create a max base

Posted in reply to stataddict

not working

Respected Advisor
Posts: 3,799

Re: want to create a max base

Posted in reply to TarunKumar

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.

Frequent Contributor
Posts: 77

Re: want to create a max base

Posted in reply to data_null__

you are correct it was my mistake

Frequent Contributor
Posts: 77

Re: want to create a max base

Posted in reply to stataddict

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

Occasional Contributor
Posts: 14

Re: want to create a max base

Posted in reply to TarunKumar

No problem Smiley Happy

Occasional Contributor
Posts: 8

Re: want to create a max base

Posted in reply to TarunKumar

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

;

🔒 This topic is solved and locked.

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

Discussion stats
  • 9 replies
  • 351 views
  • 1 like
  • 5 in conversation