topic Re: ROW_NUMBER() in sas in SAS Programming

ROW_NUMBER() in sas

Son_Of_Krypton — Tue, 08 Dec 2020 06:58:29 GMT

I have following sql code that i want to do it in sas datastep.

ROW_NUMBER() OVER(PARTITION BY member_key ORDER BY 
joindate asc, (case when status='Existing' then 1 when Status='Pending' then 2 else 3 end) asc,
savings desc) as CustRank

How we can do this in sas datastep need some help here.. It would be great if anyone post solution here with example.

Re: ROW_NUMBER() in sas

andreas_lds — Tue, 08 Dec 2020 07:06:24 GMT

I don't know what the function row_number() exactly does, but maybe _n_ is what you are looking for.

Re: ROW_NUMBER() in sas

Kurt_Bremser — Tue, 08 Dec 2020 07:11:17 GMT

data want;
set have;
by member_key;
if first.member_key
then counter = 1;
else counter + 1;
run;

Re: ROW_NUMBER() in sas

Son_Of_Krypton — Tue, 08 Dec 2020 07:35:44 GMT

but in Row_Number() there are several columns which are cimbined in CustRank column

Re: ROW_NUMBER() in sas

Kurt_Bremser — Tue, 08 Dec 2020 08:11:35 GMT

Please supply source data in usable form (data step with datalines), and what you expect out of it.

Re: ROW_NUMBER() in sas

ballardw — Tue, 08 Dec 2020 17:16:24 GMT

@Son_Of_Krypton wrote:

but in Row_Number() there are several columns which are cimbined in CustRank column

Which leads to more variables on the BY statement and modifications to first.logic.

Really need to provide examples of your data and expected results. I have no access to any SQL with this (mythical to me) Row_number function or "Partition over" operation so cannot tell what you expect in any case.