Review Buckets Simple 2 dimension data preparation

[Tajinder]

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 !

[PeterClemmensen]

Do you want a data set like this or is it for reporting purposes?

[Tajinder]

This is for reporting purpose..yes

[Tajinder]

friends..an early response would be highly appreciated..thanks

[ballardw]

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?

[Tajinder]

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

[Tajinder]

Dear Friends..request support..thanks