topic Re: Review Buckets Simple 2 dimension data preparation in SAS Enterprise Guide

Review Buckets Simple 2 dimension data preparation

Tajinder — Thu, 26 Sep 2019 06:11:58 GMT

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 !

Re: Review Buckets Simple 2 dimension data preparation

PeterClemmensen — Thu, 26 Sep 2019 06:25:28 GMT

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

Re: Review Buckets Simple 2 dimension data preparation

Tajinder — Thu, 26 Sep 2019 06:53:36 GMT

This is for reporting purpose..yes

Re: Review Buckets Simple 2 dimension data preparation

Tajinder — Thu, 26 Sep 2019 11:47:17 GMT

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

Re: Review Buckets Simple 2 dimension data preparation

ballardw — Thu, 26 Sep 2019 15:15:26 GMT

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?

Re: Review Buckets Simple 2 dimension data preparation

Tajinder — Fri, 27 Sep 2019 04:09:08 GMT

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

Re: Review Buckets Simple 2 dimension data preparation

Tajinder — Mon, 30 Sep 2019 06:02:38 GMT

Dear Friends..request support..thanks