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

FROM MS -SQL TO SAS CODE (PROC RANK)

max_ros — Wed, 23 May 2018 14:06:45 GMT

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

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

ballardw — Wed, 23 May 2018 14:14:54 GMT

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.

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

max_ros — Thu, 24 May 2018 10:41:55 GMT

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

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

ballardw — Thu, 24 May 2018 15:28:00 GMT

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