topic Re: Top two records by customer/group in SAS Programming

Top two records by customer/group

Mona1 — Sat, 13 May 2017 19:20:47 GMT

Hi,

I am having following dataset with me-:

The first column is customerid and second one is spend. Can anyboby explain the logic for calculation top two transactions of each customer.

1 500

1 200

1 100

2 900

2 550

2 200

3 1900

3 1300

3 750

3 500

Thanks & Regards

Mona

Re: Top two records by customer/group

Reeza — Sat, 13 May 2017 19:22:16 GMT

Hi Mona,

the solution I posted here, is exactly what you need, expect you want to use 2 instead of 4.

https://communities.sas.com/t5/Base-SAS-Programming/Selecting-the-closest-4-propensity-scores-as-controls/td-p/358457

proc sort data=have;
by customerID descending amount;
run;

data want;
set have;
by customerID;

if first.caseID then count=0;
count+1;

if count <= 2;

run;