BookmarkSubscribeRSS Feed
summy
Calcite | Level 5

Here is the sample dataset:

CustomerNo  M1T1  M1A1  M2T2  M2A2     ......   M19T19  M19A19  M20T20  M20A20

1                     2        500.4    12    3689.9                    0             0            4             12

2                     5           30       3      3000                      1        9999           9          29875

3                     0          0          0       0                           0             0            0              0

4                     1        42310    0       0                           0             0            0              0

.

.

.

.

.

.

490000          0         0        11     879454.4                1              6             1              44

Take CustomerNo=1 as example,M1T1=2 and M1A1=500.4 means this customer had  number of transaction 2 and amount of transaction 500.4 at merchant type M1,
There are total 20 merchant types and 490000 Customers.

Now need to do Customer Classification and identify Consumption Habit.

Which ways will you choose? And can you share the code in SAS?

6 REPLIES 6
Reeza
Super User

Do you have SAS EM? This sounds like Market Basket Analysis to me.

SAS Base doesn't have the mechanism to do this well.

summy
Calcite | Level 5

Yes, I have SAS EM and SAS/STAT

Reeza
Super User

Then I'd probably recommend walking through a tutorial on Market Basket Analysis either in the SAS EM documentation and then move on to your data.

Also consider reading up on what MBA is, if you're unfamiliar with the concept.

summy
Calcite | Level 5

Walked through tutorial months ago,only found the result SAS giving like Cluster is a little specious.
What do you think?

Reeza
Super User

MBA isn't cluster analysis AFAIK and does require SAS EM. This whole field of customer classification is a bit new and still in flux in my opinion. I haven't tried any ML algothims but I know a lot of people do.

summy
Calcite | Level 5

I meant proc cluster; in SAS/STAT. Anyway,let's find out a way, an executable way.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 6 replies
  • 1542 views
  • 0 likes
  • 2 in conversation