DATA Step, Macro, Functions and more

Array question

Reply
Occasional Contributor
Posts: 17

Array question

[ Edited ]

Hi All,

 

I have below question

 

Data

 

 

 

test;

input

 

 

ID$ Month1 Month2 Month3 Month4;

cards

 

 

;

A1 29 60 91 119

A2 89 120 0 0

A3 1 30 61 89

A4 29 19 50 78

A5 6 37 68 96

;

run

 

 

;

 

I would like to count the months when month hit over 90

 

My desire output is as below

 

 Month1Month2Month3Month4Flag
A12960911193
A289120002
A313061890
A4291950780
A563768964

 

Means in the first case A1 id is started from 29 at the month1 and continue until month3 where it reached 91 then flag is 3. On the other hand Case 3 in the month1 is 1 and month 2 is 30 which not added to 31 that time I want flag to be 0

 

Can someone help me, please

Trusted Advisor
Posts: 1,228

Re: Array question

data want(drop=i);
set test;
flag=0;
array m(*) m:;
do i=1 to dim(m);
     if m(i)>90 then do;
     flag=i;
    leave;
end;
end;
run;

Ask a Question
Discussion stats
  • 1 reply
  • 199 views
  • 4 likes
  • 2 in conversation