How to give Rank number in SAS Enterprise guide?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

How to give Rank number in SAS Enterprise guide?

Hi everybody,

I'm using Enterprise Guide 5.1  here is my problem:

I have a table :

cust_id          payment_day_id

-----------          -----------------------     

12345                 201304

12345                 201305

12345                 201306

6789                   201307

6789                   201308

                  

I want to give a rank number to each row according to  payment_day   by grouping cust_id


above example rank must be like this


cust_id          payment_day_id    rank

-----------          -----------------------     -----

12345                 201304           1

12345                 201305           2

12345                 201306           3

6789                   201307           1

6789                   201308           2



How can I do this with enterprise guide or  in proc SQL ?


Accepted Solutions
Solution
‎09-27-2013 08:02 AM
SAS Super FREQ
Posts: 708

Re: How to give Rank number in SAS Enterprise guide?

Hi

Have a look at the following discussion

SAS Enterprise Guide has a Rank Task to find in the Daata category

View solution in original post


All Replies
Solution
‎09-27-2013 08:02 AM
SAS Super FREQ
Posts: 708

Re: How to give Rank number in SAS Enterprise guide?

Hi

Have a look at the following discussion

SAS Enterprise Guide has a Rank Task to find in the Daata category

Occasional Contributor
Posts: 9

Re: How to give Rank number in SAS Enterprise guide?

Posted in reply to Bruno_SAS

thank you very much,  Rank task is very helpful to me

Super User
Posts: 5,424

Re: How to give Rank number in SAS Enterprise guide?

There should be a Rank task within EG. I believe it uses PROC RANK, and should probably suit your needs.

Data never sleeps
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 3765 views
  • 3 likes
  • 3 in conversation