Help using Base 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.

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

Posted in reply to ManoharNathGupta

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

Trusted Advisor
Posts: 1,301

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.

Posted in reply to naveen_srini

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;

Ask a Question
Discussion stats
  • 2 replies
  • 329 views
  • 4 likes
  • 3 in conversation