BookmarkSubscribeRSS Feed
umesh1
Fluorite | Level 6

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

1 REPLY 1
stat_sas
Ammonite | Level 13

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;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 610 views
  • 4 likes
  • 2 in conversation