Hi,   I've a sample input data below and the expected output format. I need to find number of active customers as per the start date of the year and their based on end date, I've to keep the count added for each year.  Example, Customer A,H,I - Active from 2004, so we have 3 customers active from 2004 and I'm keeping the count added horizontally for each year and by 2009 one customer got dropped. So for 2010 - customer count was 2. Similarly I've to populate the same for the next row active from  2005 and followed by  other rows. Could you please suggest me the best approach to get this done ?   Thanks in advance for your help.             ... View more

The fact that I even have to post this tells u what kind of day I'm having 😞 If the HLT_ALZDEM variable doesn't have a valid value of 1 or 2 (yes/no), then the variables that are constructed based on HLT_ALZDEM should be given a value of missing.  However, they sometimes are given a value of 0 instead.   Below is a portion of the output file, sorted for rows where HLT_ALZDEM  is missing. Since missing is clearly not 1 or 2, all ADRD_group and non_ADRD_group values should also be missing. But they're not. Obs 9 and 10 are identical except for these 2 variables., when Obs 9 is missing and Obs 10 is 0 for both.   The only possible explanation I can think of is that there are non-printable characters for some values of HLT_ALZDEM. But even if there are, those non-printable characters are not 1 or 2. Frequencies for HLT_ALZDEM  only show values of 1, 2, and missing. IF cohort_flag = 1 AND ADM_MA_FLAG_YR = 3 THEN MA_group = 1; ELSE MA_group = 0; IF cohort_flag = 0 THEN MA_group = .; IF cohort_flag = 1 AND ADM_FFS_FLAG_YR = 3 THEN TM_group = 1; ELSE TM_group = 0; IF cohort_flag = 0 THEN TM_group = .; IF cohort_flag = 1 AND HLT_ALZDEM = 1 THEN ADRD_group = 1; ELSE ADRD_group = 0; IF cohort_flag = 0 THEN ADRD_group = .; IF HLT_ALZDEM ^in (1,2) THEN ADRD_group = .; IF cohort_flag = 1 AND HLT_ALZDEM = 2 THEN non_ADRD_group = 1; ELSE non_ADRD_group = 0; IF cohort_flag = 0 THEN non_ADRD_group = .; IF HLT_ALZDEM ^in (1,2) THEN non_ADRD_group = .; Obs HLT_ALZDEM cohort_flag MA_group TM_group ADRD_group non_ADRD_group 1   0         2   1 0 1 0 0 3   1 1 0     4   0         5   0         6   1 0 1     7   1 1 0     8   1 1 0     9   1 1 0     10   1 1 0 0 0 11   1 1 0     12   1 0 1     13   1 0 1     14   1 0 1     15   1 0 1     16   1 0 1 0 0 ... View more

Hi SAS Community, I've been trying to create a grouped forest plot in SAS, but so far, I've only been able to find resources on how to create a single forest plot. However, my requirement is to combine two forest plots into one, similar to the attached sample plot.   I'm wondering if anyone could offer some guidance on how to achieve this. Should I use proc sgplot or proc template for this purpose? Currently, I'm using the proc sgplot code provided in this post: CTSPedia Clinical Graphs - Subgrouped Forest Plot. Any insights or examples you could share would be greatly appreciated! Thank you in advance! Jess ... View more

What is the equivalent of slice statement in a negative binomial regression model?  ... View more