Hi All,
Does anyone know how to create a RFM Segmentation in Base SAS??
Many Thanks
Alice
Hi,
RFM Segmentation is the subject of Rules Base Segmentation by taking in to account -
If it is like above then you can process with RFM Segmentation by using your transaction dataset as follow:
Now based on the above two KPIs, create RFM score by combining both the KPIs like -
RFM_Score = av.spend || av.visit;
Once you have RFM_Score variable ready, do Proc Rank and you will have rank based on Spend and Visit Dimension...
Finally based on assigned rank (by using Proc Rank), create some rules as follow:
The above procedure of creating RFM Segmentation does not include Margin Dimension as you can eassily group the households based on Frequency and Recency...You can simply calculate Margin KPI and pool more insight from that...
Hope it will be useful to your project...If you can post some sample transaction data, we can discuss more on RFM Segmentation...the above discussion is the starting in creating RFM Segmeatation...
You need to fix period through which you can refresh your RFM Model like every 4 week, 8 week, 13 weeks, etc...
-Urvish
If you have access to Enterprise Guide 6.1, then you can perform RFM analysis by selecting Tasks > Data Mining > Recency, Frequency, and Monetary Analysis ... The RFM analysis is a feature in SAS BASE 9.4 and above.
Thank you Ming!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.