Array question

umesh1 — Sat, 30 Apr 2016 13:21:31 GMT

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

	Month1	Month2	Month3	Month4	Flag
A1	29	60	91	119	3
A2	89	120	0	0	2
A3	1	30	61	89	0
A4	29	19	50	78	0
A5	6	37	68	96	4

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

Re: Array question

stat_sas — Sat, 30 Apr 2016 14:10:30 GMT

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;

topic Re: Array question in SAS Programming

Array question

Re: Array question