Hi SAS Communities,   This is a follow-up question to a question I posted a few days ago. See here: https://communities.sas.com/t5/SAS-Programming/Calculate-Duration-First-Visit-to-Time-to-Event/m-p/738489#M230369   The code has been modified to provide me with one duration variable using two separate conditions. One condition pulls in the first instance of an event '1' and calculates the duration and the second condition pulls in the last instance of an event '0' and calculates the duration.    The code below results in an array subscript out of range error: proc sql noprint; select count(*) into :n_vars trimmed from dictionary.columns where libname='WORK' and memname='HAVE' and upcase(name) like 'EVENT^_%' escape '^' ; quit; data duration; length duration_in_days 8; set table1; array _visit {*} visit_date_:; array _event {*} recovered_:; n_event1=whichn(1,of _event[*]); if n_event1>=1 then do; duration_in_days=_visit[n_event1]-_visit[1]; end; if missing(duration_in_days) then do; array _r_visit {*} visit_date_&n_vars - visit_date_1; array _r_event {*} recovered_&n_vars - recovered_1; n_event_last0=whichn(0 ,of _r_event[*]); if n_event_last0>=1 then do; duration_in_days=_r_visit[n_event_last0]-_r_visit[&n_vars]; end; end; run; The error is specifically associated with this line of code (see log below): duration_in_days=_r_visit[n_event_last0]-_r_visit[&n_vars]; 95 if missing(duration_in_days) then do; 96 array _r_visit {*} visit_date_&n_vars - visit_date_1; 97 array _r_event {*} recovered_&n_vars - recovered_1; 98 n_event_last0=whichn(0 ,of _r_event[*]); 99 if n_event_last0>=1 then 100 do; 101 %put &=n_vars.; N_VARS=0 102 duration_in_days=_r_visit[n_event_last0]-_r_visit[&n_vars]; 103 end; 104 end; 105 run; ERROR: Array subscript out of range at line 102 column 42. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 1 observations read from the data set WORK.TABLE1.   Does anyone know why this error is occurring and how I can fix it? Thank you in advance!  ... View more

Hi SAS Communities,    I'm working on a dataset in wide structure and this is a simplified example of how the dataset looks like:   ID      visit_1        event_1      visit_2        event_2      visit_3       event_3         visit_4     event_4        1      2/28/2020        0           3/05/2020         0         08/31/2020        1                 .                    . 2      4/10/2020        0           07/01/2020       1                 .                  .                 .                    . 3      03/12/2020      0           05/29/2020       1         08/05/2020        0            12/21/2020       1 4      07/07/2020      1                  .                  .                  .                  .                  .                   . 5     09/03/2020       0          10/15/2020        0          10/31/2020       0             11/15/2020       1      My goal is to calculate the duration measuring the time (in months) from visit_1 to the visit date of the first instance of an event = 1. I believe I would need to create an array to loop through each row and determine the date of the first occurrence of an event=1, subtract the visit_1 date from it, and output it into a new variable called 'duration'.  So I would have a duration for each ID.    Important things to note: 1. Each ID has a varying number of visits. ID 15 may have 10 visits and 10 events, while ID 55 only has 3 visits and 3 events. There isn't a consistent pattern in the number of visits. 2. My visits are all already in SAS date format 3. Visit numbers and event numbers are grouped together by the number following the underscore. For example, event_2 takes place on the date listed for visit_2.   I'm unsure of how to write my code in a way that would determine the first event=1, pull the date from that event and then calculate duration. I would appreciate any guidance on this problem. I can provide additional information/details if necessary. Thank you in advance!  ... View more

Hi SAS Communities,   I would like to create a new variable called duration that will calculate the total number of months an individual (ID) was in a health program using a variable called visit_date (already converted to numeric and is in SAS date format). My data is currently in long format, so each ID has a value for the visit_date variable.   My dataset is quite large and each ID has a varying # of visits, but the variables mentioned above are structured as follows: ID1    3/15/2020 ID1    6/27/2020 ID1    01/25/2021 ID2    3/02/2020 ID2   09/15/2020   I've used arrays in the past to calculate duration of time, but I've only done that with data in wide format. How would I go about accomplishing this task? Thank you in advance.  ... View more

Hi SAS communities,   I am attempting to use a WHERE= option in my ODS Output statement to pull in observations where variable HypRelDeathInd=1 and variable StateCd is a non-missing value. I've tried using a MISSING function by coding it as "WHERE Not Missing(StateCd)", but that yielded a syntax error in the log. Any other suggestions for how I can change my code to pull in non-missing values for my StateCd variable? Thank you in advance!    Here is the code I've described: PROC FREQ DATA = Work.Analysis2; TABLES HypRelDeathInd*StateCd / NOPERCENT NOROW CHISQ; ODS OUTPUT CrossTabFreqs = HypRslt.StatePercents (WHERE = (HypRelDeathInd=1 and WHERE Not Missing(StateCd))); ODS OUTPUT ChiSq = HypRslt.ChiSqResults (WHERE = (Statistic='Chi- Square')); RUN; QUIT;   ... View more