I have three columns named ID, Month, and Year. My goal is to create a new column called "new_month."   The values for the "new_month" column will be determined based on a prompt that asks for a specific date. I will provide a date in response to the prompt. The values in the Month column that fall between the month of the prompted date and two months following that month should be assigned to the last month.   For example, if the prompted date is 08/01/2021, any values in the Month column that fall between 8 and 10 should be assigned the value 10. Similarly, values between 9 and 11 should be assigned 11, and values between 10 and 12 should be assigned 12. These assignments will be made in the calculated new_month column.   It's worth noting that there will be duplicated values for IDs because a single month, such as 10, may belong to multiple categories (10, 11, and 12). This duplication is intentional as I need to count the number of IDs from two months prior to my measuring period. The measuring periods, in this case, are 10, 11, and 12.   Initially, I considered using a CASE statement with multiple WHEN-THEN conditions. However, I discovered that if the first condition evaluates to TRUE, SAS will ignore the subsequent conditions.   I am using SAS EG. So, please keep this in mind when commenting. I would appreciate any assistance you can provide in implementing this logic.     ... View more

Is there a setting in SAS EG that will allow me to remove the Source column and re-arrange the Age Category column in the following order: Age18, Age 18-64, then Age 65+ (the ascending and descending option is ineffective)? Please refrain from recommending any SAS Code unless you are sure it is the only way I can achieve these two objectives. I am running on an SAS server and accessing the MIS/DSS database. If SAS EG can handle it on its own, I don't want to deal with the complexity of changing my base code. It is already complicated enough! 😀     Thanks in advance.       Age Group in ascending order     Age Group in descending order:       ... View more

I am not asking how to right a code. I am asking how to use Tasks in SAS EG to create such a statement.   I have an 'age' column and would like to group them into '<18', 'between 18 and 65', and '65+'.   Thank you in advance. ... View more

I want to remove the duplicated records which have similar entries across all variables except 'age'. I don't care which row to keep once a duplicated row found. Also, I don't want to see 'age' column in my report either. Any help would be appreciated.     Here is what I have:   Here is what I want:     Thanks in advance.    ... View more