I have a question about using PROC RANK function. I usually use SQL in the company however I need to edit SAS query as well. Problem : I want to express below SQL query in SAS RANK() OVER (PARTITION BY GROUP_NAME ORDER BY START_DATE DESC) AS SEQ I tried below query but I need to make a rank based on START_DATE order by descending. If anybody can give the answer of it, please let me know. PROC RANK
DATA = WORK.DATA_EXTRACTION1
OUT = WORK.DATA_EXTRACTION2;
BY GROUP_NAME;
VAR START_DATE;
RANKS SEQ;
RUN;
... View more