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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: