## 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.

Occasional Contributor
Posts: 10

# 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.

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

Frequent Contributor
Posts: 115

## 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.

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

Posts: 1,318

## 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.

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;

Discussion stats
• 2 replies
• 346 views
• 4 likes
• 3 in conversation