Dear Friends, Have two data variables , Customer Name and a Review date column. Basis review Date's month, I need to bucket customers accordingly.
My input data is like this :
Customer Name | Review Date |
ABC Apparels | 30-03-2019 |
CL EDUCATE | 30-03-2019 |
Jammy Foods | 30-03-2019 |
B R Infra | 30-03-2019 |
A W India | 15-04-2019 |
XYX Tele | 18-04-2019 |
PQR INTL | 01-04-2019 |
G INTL LTD | 21-04-2019 |
M CONTRACTORS | 12-05-2019 |
PIC Limited | 10-05-2019 |
S POWER GEN | 29-05-2019 |
I need to group these customers basis the month of review they fall in and hence the output expected is (basis the assumption that the current month is Mar-19, all my customers with Review date before Apr-19 are in overdue bucket)
Overdue | Apr-19 | May-19 |
ABC Apparels | A W India | G INTL LTD |
CL EDUCATE | XYX Tele | M CONTRACTORS |
Jammy Foods | PQR INTL | PIC Limited |
B R Infra | S POWER GEN |
Kindly help to get this done in SAS EG.
Thanks !
Do you want a data set like this or is it for reporting purposes?
This is for reporting purpose..yes
Please describe the logic for how your example output rows are aligned. I don't see any particular reason for ABC Apparels to have A W India on the same row.
Are any of the customer names duplicated within a month? If so, how would that affect the output?
In the example, I need to present a report as on month end. there is an assumption that I am running the report in the Month of April 19. ABC Apparels - review date (30-03-2019) is falling in the March month ,hence in April 19 month (when the report is run) , it came in the column of Overdue bucket whereas A W India's review date (15-4-19) is in April 2019 month, hence it is come under separate column i.e April 19.
Hope this clarifies..Thanks
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.