DATA Step, Macro, Functions and more

FROM MS -SQL TO SAS CODE (PROC RANK)

Reply
Occasional Contributor
Posts: 8

FROM MS -SQL TO SAS CODE (PROC RANK)

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

Super User
Posts: 13,293

Re: FROM MS -SQL TO SAS CODE (PROC RANK)

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.

Occasional Contributor
Posts: 8

Re: FROM MS -SQL TO SAS CODE (PROC RANK)

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
Super User
Posts: 13,293

Re: FROM MS -SQL TO SAS CODE (PROC RANK)


@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.

Ask a Question
Discussion stats
  • 3 replies
  • 76 views
  • 0 likes
  • 2 in conversation