BookmarkSubscribeRSS Feed
MoniqueParmar
Calcite | Level 5

Hi, I have built 8 clusters using proc fastclus and I now want to apply it to a new dataset - how do I do this?

 

Is there something similar like proc score that is used in logistic regression?

5 REPLIES 5
MoniqueParmar
Calcite | Level 5

Thank you

 

Tried to apply this and the clusters are completely different

 

is there another method to use similar to proc score?

 

How else would you be able to score customers with a cluster once you have built a segmentation?

Rick_SAS
SAS Super FREQ

Please post the code that you tried to use.

MoniqueParmar
Calcite | Level 5


/* original dataset and cluster */

PROC FASTCLUS
DATA=WORK.SEGBASEMIG
OUT=WORK.SEGBASEMIGTEST
outstat= OUTCLUS
MAXCLUSTERS = 8
MAXITER=1000
DELETE= 100
;
VAR

TICKETS_2_ORMORE
PARTNER_FLAG
/*PARTNER_DOMINANT*/
/*DIRECT_ONLINE_FLAG*/
DIRECT_ONLINE_DOMINANT
/*ONTHEDAY_FLAG*/
ONTHEDAY_2_ORMORE
LONG_JOURNEY_2_ORMORE
/*SINGLE_DOMINANT_FLAG*/
RETURN_DOMINANT_FLAG
OPENRETURN_DOMINANT_FLAG
/*WEEKPEAK_FLAG*/
WEEKPEAK_DOMINANT
WEEKOFFPEAK_DOMINANT
/*WEEKEND_DOMINANT*/
/*WEEKORMORE_FLAG*/
WEEKORMORE_DOMINANT
/*SAMEDAY_RETURN_FLAG*/
/*ANCIL_FLAG*/
ANCIL_2_ORMORE
TYPES_2_ORMORE
COUPLE_FLAG
/*COUPLE_2_ORMORE*/
FAMILY_FLAG
/*FAMILY_2_ORMORE*/
GROUP_FLAG
/*GROUP_2_ORMORE*/
/*SOLO_DOMINANT_FLAG*/
ROUTES_2_ORMORE
EVENT_FLAG
/*CATEGORIES_2_ORMORE*/
FREQ_JOURNEY_FLAG
/*UNI_STOP_FLAG*/
/*UNI_CITY_FLAG*/
/*UNI_PROMO_FLAG*/
/*AIRPORT_FLAG*/
AIRPORT_DOMINANT
HIGHVALUE_FLAG



;
RUN;

 

/* new dataset and cluster */

 

PROC FASTCLUS
DATA=WORK.SEGBASEMIG2
OUT=WORK.SEGBASEMIGTEST2
INSTAT= OUTCLUS
MAXCLUSTERS = 8
MAXITER=1000
DELETE= 100
;
VAR

TICKETS_2_ORMORE
PARTNER_FLAG
/*PARTNER_DOMINANT*/
/*DIRECT_ONLINE_FLAG*/
DIRECT_ONLINE_DOMINANT
/*ONTHEDAY_FLAG*/
ONTHEDAY_2_ORMORE
LONG_JOURNEY_2_ORMORE
/*SINGLE_DOMINANT_FLAG*/
RETURN_DOMINANT_FLAG
OPENRETURN_DOMINANT_FLAG
/*WEEKPEAK_FLAG*/
WEEKPEAK_DOMINANT
WEEKOFFPEAK_DOMINANT
/*WEEKEND_DOMINANT*/
/*WEEKORMORE_FLAG*/
WEEKORMORE_DOMINANT
/*SAMEDAY_RETURN_FLAG*/
/*ANCIL_FLAG*/
ANCIL_2_ORMORE
TYPES_2_ORMORE
COUPLE_FLAG
/*COUPLE_2_ORMORE*/
FAMILY_FLAG
/*FAMILY_2_ORMORE*/
GROUP_FLAG
/*GROUP_2_ORMORE*/
/*SOLO_DOMINANT_FLAG*/
ROUTES_2_ORMORE
EVENT_FLAG
/*CATEGORIES_2_ORMORE*/
FREQ_JOURNEY_FLAG
/*UNI_STOP_FLAG*/
/*UNI_CITY_FLAG*/
/*UNI_PROMO_FLAG*/
/*AIRPORT_FLAG*/
AIRPORT_DOMINANT
HIGHVALUE_FLAG



;
RUN;

ballardw
Super User

Try running the second FASTCLUS code without the options MAXCLUSTERS MAXITER or DELETE

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 994 views
  • 0 likes
  • 3 in conversation