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
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
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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: