BookmarkSubscribeRSS Feed
laura_m
Calcite | Level 5

I have customer feedback survey data and attrition data. I'm trying to understand if low customer service scores are correlated with higher rates of attrition. It's been a while since I've had the opporunity to do this kind of analysis, and I need some help getting started. Any recommendations on SAS procedures to look into? 

 

A couple of notes about the data: 

- Customer scores are discrete from 1-10 (1=not at all satisfied to 10=completely satisfied, with no qualitative "value" being assigned to ratings 2-9)

- The data I have gives the average monthly customer satisfaction score by retail location; due to changes in the survey methods, I'm looking at Mar 2016 - Nov 2016. Each month's score is reported as YTD, so April's score is the sample that was collected from both March & April; May's score is March & April & May, etc. Initially I was looking at doing a timeseries analysis, but because the scores "build" on each other each month, I think it makes the most sense to use just the most recent month... but feel free to disagree. 

- The attrition value is net number of customers gained/lost, so it can be positive or negative

- I'm interpreting this data at the store level

1 REPLY 1
Damien_Mather
Lapis Lazuli | Level 10

I would recommend proc glmselect, which is at the heart of the predictive regression models task in SAS Studio. The distribution of your dependent, response or target variable is a convolution of several processes that is likely to have some strange distribution that would not meet the usual gaussian/normal residual assumption required for ordinary least squares regression provided by proc reg. If you have enough (aggregated) observations to be able to afford a sampling split into training and validation data that would yield the most reliable inferences, otherwise use AICC as the selection criteria, and allow the store hierarchy to be split up for model selection.

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
  • 1 reply
  • 1132 views
  • 0 likes
  • 2 in conversation