BookmarkSubscribeRSS Feed
Tajinder
Calcite | Level 5

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 NameReview Date
ABC Apparels30-03-2019
CL EDUCATE 30-03-2019
Jammy Foods30-03-2019
B R Infra30-03-2019
A W India15-04-2019
XYX Tele18-04-2019
PQR INTL01-04-2019
G INTL LTD21-04-2019
M  CONTRACTORS  12-05-2019
PIC Limited10-05-2019
S POWER GEN29-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)

 

OverdueApr-19May-19
ABC ApparelsA W IndiaG INTL LTD
CL EDUCATE XYX TeleM  CONTRACTORS  
Jammy FoodsPQR INTLPIC Limited
B R Infra S POWER GEN

 

Kindly help to get this done in SAS EG.

 

Thanks !

6 REPLIES 6
PeterClemmensen
Tourmaline | Level 20

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

Tajinder
Calcite | Level 5

This is for reporting purpose..yes

Tajinder
Calcite | Level 5
friends..an early response would be highly appreciated..thanks
ballardw
Super User

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
Calcite | Level 5

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
Calcite | Level 5
Dear Friends..request support..thanks

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

Creating Custom Steps in SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 1656 views
  • 0 likes
  • 3 in conversation