RFM score in SPSS

#1
Is there any faster way to calculate RFM score of 260000 records?

I have used SPSS to calculate Recency(Last date-First date)
Frequecy and Monetary formula.

How to i assign score.

For eg

Recency Max score=30

Last 13 months 20
14-24 15
25-36 10

Is there any way i can assign these scores using SPSS
 

mp83

TS Contributor
#2
You can use the RECODE (into new variable) menu, where you insert the conditional specification above for the Recency variable and the score assigned to the new variable.