topic Re: Please solve this query. Suppose there are two variable ( Account number , Transaction Amount ) and I want 3rd Transaction_Amount of each account number. Can you please solve this. in SAS Procedures

Please solve this query. Suppose there are two variable ( Account number , Transaction Amount ) and I want 3rd Transaction_Amount of each account number. Can you please solve this.

ManoharNath — Sun, 21 Dec 2014 11:51:08 GMT

Hi All,

Please solve this query. Suppose there are two variable ( Account number , Transaction Amount ) and

I want 3rd Transaction_Amount of each account number. Can you please solve this.

Regards,

Manohar

Account_number, Transaction_Amount

10001 250000

10001 256699

10001 155665

10001 789562

20001 985466

20001 856956

20001 155464

20001 145889

Re: Please solve this query. Suppose there are two variable ( Account number , Transaction Amount ) and I want 3rd Transaction_Amount of each account number. Can you please solve this.

naveen_srini — Sun, 21 Dec 2014 12:51:46 GMT

Hi,

Let me if this works for you

data inp;

input Account_number $ Transaction_Amount;

datalines;

10001 250000

10001 256699

10001 155665

10001 789562

20001 985466

20001 856956

20001 155464

20001 145889

;

data outp(drop=count);

set inp;

by account_number notsorted;

if first.account_number then count=0;

count+1;

if count=3 then output;

run;

Thanks

Naveen Srinivasan

L&T infotech

Re: Please solve this query. Suppose there are two variable ( Account number , Transaction Amount ) and I want 3rd Transaction_Amount of each account number. Can you please solve this.

FriedEgg — Mon, 22 Dec 2014 22:26:27 GMT

data have;

input account_number transaction_amount @@;

cards4;

10001 250000 10001 256699 10001 155665 10001 789562

20001 985466 20001 856956 20001 155464 20001 145889

;;;;

/*if you want in order with transaction_amount add a sort

proc sort;

by account_number transaction_amount;

data want;

do _n_=1 by 1 until (last.account_number);

set have;

by account_number;

if _n_=3 then output;

end;

run;