FROM MS -SQL TO SAS CODE (PROC RANK)

[max_ros]

Goood aftenoon at all,

i need to translate MS-SQL code in proc rank sas code. It is possible?

If yes, how? in particular i'm intersted in "translate" "RANK () OVER .." . IN SAS CODE "PROC RANK"

This is MS-SQL code :

tmp_ as (

                    select

                           accntnum,

                           policytype,

                           userdef1,

                           usertxt2,

                           RANK() OVER ( PARTITION BY accntnum, usertxt2 order by RT_RANK ) as RN

                    from

                           tmp

Thanks a lot in  advance.

massimo

[ballardw]

Please provide an example of the input data and what the result would be.

Not everyone here knows MS-SQL and perhaps that do have some acquaintance do no use those features. However we can often provide an example of pounding data into the desired form.

And a solution may not require proc rank.

[max_ros]

Thanks for the suggestion. I have however arrived at a solution without using the proc rank but instructions like "first" "last" (ordering the dataset for the variables of interest).
thanks a lot

[ballardw]

---

@max_ros wrote:
Thanks for the suggestion. I have however arrived at a solution without using the proc rank but instructions like "first" "last" (ordering the dataset for the variables of interest).
thanks a lot

---

Please post your solution code and mark that as the accepted solution so that others searching this forum have an example of a solution if they have a similar problem/ question.