topic Re: SAS Rows in SAS Programming

Create rank from a flag

Haritha1 — Mon, 28 Nov 2016 14:31:03 GMT

Hi Everyone,

Could you please help me to code the below logic.

I have a flag variable in my data set and I want to create a Rank variable in the following way.

PS: I'm using SAS 9.4.

Thanks a lot in Advance.

Kurt_Bremser — Mon, 28 Nov 2016 14:25:15 GMT

data want;
set have;
by flag notsorted;
retain rank 0;
if first.flag then rank + 1;
run;

Haritha1 — Tue, 29 Nov 2016 09:15:47 GMT

This is helpful.

Thanks..)