Creating a variable that takes the max number of a binary variable within a 12-month rolling window in SAS
In SAS, I need to create a field Defaulted_Ind_12m_Max that takes the max(Defaulted_Ind_t, … Defaulted_Ind_{t+k}) where k=12 months and assigns it at every point of Defaulted_Ind_12m_Max where it holds true, per month per group of accounts.
Creating a variable that takes the max number of a binary variable within a 12-month rolling window in SAS
In SAS, I need to create a field Defaulted_Ind_12m_Max that takes the max(Defaulted_Ind_t, … Defaulted_Ind_{t+k}) where k=12 months and assigns it at every point of Defaulted_Ind_12m_Max where it holds true, per month per group of accounts.
Creating a variable that takes the max number of a binary variable within a 12-month rolling window in SAS
In SAS, I need to create a field Defaulted_Ind_12m_Max that takes the max(Defaulted_Ind_t, … Defaulted_Ind_{t+k}) where k=12 months and assigns it at every point of Defaulted_Ind_12m_Max where it holds true, per month per group of accounts.
Creating a variable that takes the max number of a binary variable within a 12-month rolling window in SAS
In SAS, I need to create a field Defaulted_Ind_12m_Max that takes the max(Defaulted_Ind_t, … Defaulted_Ind_{t+k}) where k=12 months and assigns it at every point of Defaulted_Ind_12m_Max where it holds true, per month per group of accounts.
Creating a variable that takes the max number of a binary variable within a 12-month rolling window in SAS
In SAS, I need to create a field Defaulted_Ind_12m_Max that takes the max(Defaulted_Ind_t, … Defaulted_Ind_{t+k}) where k=12 months and assigns it at every point of Defaulted_Ind_12m_Max where it holds true, per month per group of accounts.
Creating a variable that takes the max number of a binary variable within a 12-month rolling window in SAS
In SAS, I need to create a field Defaulted_Ind_12m_Max that takes the max(Defaulted_Ind_t, … Defaulted_Ind_{t+k}) where k=12 months and assigns it at every point of Defaulted_Ind_12m_Max where it holds true, per month per group of accounts.
New to using SAS arrays and can’t get array elements to populate with values based on IF-THEN-ELSE statement
Admittedly, I’ve never written an array, so I’m sure this is an easy solution for most users. I’ve got a dataset with two columns: