How to give Rank number in SAS Enterprise guide?

[sayginf]

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 ?

[BrunoMueller · Accepted solution]

Hi

Have a look at the following discussion

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

[sayginf]

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

[LinusH]

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