Help using Base SAS procedures

dense_rank over (partitioning

Reply
Occasional Contributor
Posts: 15

dense_rank over (partitioning

Hi,

Following is oracle query and I am trying to do it in SAS. I did not find any alternative. Can someone please help me in this, I really appreciate.

SELECT APPS.*,

DENSE_RANK() OVER (PARTITION BY APPS.APP_NBR ORDER BY APPS.V_RANK_DAYS2APP, ABS(V_RANK_DAYS2APP),

    DECODE(MATCHED_ON,7,1, 5,2, 3,3, 6,4, 1,5, 4,6, 2,7, 9), ROWNUM) AS V_DAYS2APP_RANK

FROM APPS

Thanks,

Sunny

Respected Advisor
Posts: 3,889

Re: dense_rank over (partitioning

PROC RANK would allow you to do ranking using "dense". I've never used "decode()" and just looked it up in the Oracle documentation. From what I understand this would require some post processing of the result returned by PROC RANK (so an additional PROC SQL/Data Step on the output of the PROC RANK procedure via an additional pass through the data).

Ask a Question
Discussion stats
  • 1 reply
  • 1176 views
  • 0 likes
  • 2 in conversation