topic Re: Ranking in proc sql in SAS Programming

Ranking in proc sql

abhinayingole — Thu, 01 Dec 2022 12:26:15 GMT

Hi there,

data want;
set have;
by id;
if first.id then rank =1;
else rank+1;
run;

For the above code, I wanted to get this RANK variable by using proc sql.

is there any method ?

Thanks,

Abhinay

Tom — Thu, 01 Dec 2022 12:37:25 GMT

No. SQL does not have the concept of processing records in any particular order.

If you want to use a PROC you might try PROC RANK, but you would need to see if it handles ties in the same way or not.

PeterClemmensen — Thu, 01 Dec 2022 12:40:48 GMT

No. You can do something similar using SQL Naitive Window Functions, but sadly, they're not supported in Proc SQL.