DATA Step, Macro, Functions and more

Identifying earliest date across column indicators

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 138
Accepted Solution

Identifying earliest date across column indicators

Hi,

 

I have a dataset with ID and indicators for each month/year (=1 if person had an event in that month, otherwise =.).

 

ID    event_200501   event_200502  event_200503.......event_200912

1              1                        1                       1                              .

2               .                        .                        1                              1

 

I have created an array to identify the earliest month in which a person has an event in each year, like this:

 

data want;

set have;

array  event2005(12) event_200501--event_200512;

do i=12 to 1;

if event2005(i)=1 then earliest_event_2005=i;

end;

/*Etc for all subsequent years*/

run;

 

The array runs with no error messages and earliest_event_2005 is created, but it's never actually populated (same with all other years). What I want is the exact same data but with new columns indicating the earliest event each person had in each year.

 

ID    event_200501   event_200502  event_200503.......event_200912  earliest_event_2005....earliest_event_2009

1              1                        1                       1                              .                           1                                   .

2               .                        .                        1                              1                          3                                   12

 

Any help is much appreciated. 

 


Accepted Solutions
Solution
‎05-24-2016 01:11 PM
Trusted Advisor
Posts: 1,117

Re: Identifying earliest date across column indicators

Posted in reply to Walternate

Hi @Walternate,

 

The issue with your code is that your iterative DO statement is incomplete:

do i=12 to 1 by -1;

Of course, ballardw's approach is more elegant.

View solution in original post


All Replies
Super User
Posts: 11,343

Re: Identifying earliest date across column indicators

Posted in reply to Walternate

Try this:

data want;
   set have;
   array  event2005(12) event_200501--event_200512;
   earliest_event_2005= whichn(min(of event2005(*)), of event2005(*));
run;
Solution
‎05-24-2016 01:11 PM
Trusted Advisor
Posts: 1,117

Re: Identifying earliest date across column indicators

Posted in reply to Walternate

Hi @Walternate,

 

The issue with your code is that your iterative DO statement is incomplete:

do i=12 to 1 by -1;

Of course, ballardw's approach is more elegant.

☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 209 views
  • 1 like
  • 3 in conversation