topic Re: How to rank the id based on multiple conditions using first. in New SAS User

How to rank the id based on multiple conditions using first.

NagendraBS — Mon, 15 Jul 2019 14:24:26 GMT

Hi all,

I have one dataset as below,

MBR_ID	DATE	PTYPE	MBR	REGION
100097538	15-Jan-18	PTR	GOLD	AMRC
100097538	22-Jan-18	PTR	GOLD	AMRC
100097538	31-Jan-18	PTR	PLTN	AMRC

Now i need the new flag based on ID Date and MBR as below

MBR_ID	DATE	PTYPE	MBR	REGION	Flag
100097538	15-Jan-18	PTR	GOLD	AMRC	1
100097538	22-Jan-18	PTR	GOLD	AMRC	1
100097538	31-Jan-18	PTR	PLTN	AMRC	0

Can you please help on this using sas

Thanks in Advance.

Nagendra

Re: How to rank the id based on multiple conditions using first.

ballardw — Mon, 15 Jul 2019 14:54:35 GMT

"First" what?

You logic is not actually clear as the MBR=PLAT is the "first" MBR value for the date 31-Jan-18. So it really doesn't appear that "date" is that important from the very small sample provided.

You may need to show an example, which can be made up, but provides more examples that would clarify the rule(s) involved.

I can write code that would solve this particular example but would be very unlikely to extend to other combinations of dates or MBR values correctly.

Re: How to rank the id based on multiple conditions using first.

Reeza — Mon, 15 Jul 2019 16:08:14 GMT

Making assumptions, if this doesn't work, explain why in detail and show cases where it doesn't work.

proc sort data=have;
by mbr_id mbr;
run;

data want;
set have;
by mbr_id mbr;

flag = not(first.mbr and last.mbr);

run;

@NagendraBS wrote:

Hi all,

I have one dataset as below,

MBR_ID DATE PTYPE MBR REGION

100097538 15-Jan-18 PTR GOLD AMRC

100097538 22-Jan-18 PTR GOLD AMRC

100097538 31-Jan-18 PTR PLTN AMRC

Now i need the new flag based on ID Date and MBR as below

MBR_ID DATE PTYPE MBR REGION Flag

100097538 15-Jan-18 PTR GOLD AMRC 1

100097538 22-Jan-18 PTR GOLD AMRC 1

100097538 31-Jan-18 PTR PLTN AMRC 0

Can you please help on this using sas

Thanks in Advance.

Nagendra