BookmarkSubscribeRSS Feed
AngelinaNu
Calcite | Level 5

Hi community, At university I was using a version of SAS guide where I used to find the option Reverse ranking to be from largest to smallest (as shown in screenshot bellow) when running the Recency Frequency and Monetary model, specifically while running Recency variable as is needed the reverse ranking (from smaller to largest) and not the normal ranking (from largest to smallest) as when running frequency and monetary. I would like to know where to find Reverse ranking to be from largest to smallest option in SAS Enterprise Guide 7.1 (32-bit). The problem I have now is the model considers first in the ranking customers who made the purchase further in time and not as close as it should be. Thanks in advance. Angelina

SAS question.JPG

2 REPLIES 2
TomKari
Onyx | Level 15
Are you using the "Data" > "Rank" task? Because I'm running EG 7.1, and I'm seeing exactly the same screen that you've included.\
 
I'm using Enterprise Guide 7.15 HF8 (7.100.5.6214) (32-bit)
 
Tom
AngelinaNu
Calcite | Level 5

 

Hi Tom, I was creating the model from Tasks - Data Mining, I will try with the option you mention. Thanks a lot for your answer.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 458 views
  • 0 likes
  • 2 in conversation