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
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 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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.