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.
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.
Try this:
data want;
set have;
array event2005(12) event_200501--event_200512;
earliest_event_2005= whichn(min(of event2005(*)), of event2005(*));
run;
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.