topic How to Looping All Accounts at same time in SAS Programming

How to Looping All Accounts at same time

Mohan_Reddy — Thu, 06 Aug 2020 11:06:43 GMT

I have 10 Bank accounts Numbers.Now i want accounts statements from June 29 to Aug 1.But i want a code automatically like when i run that code it will looping and get all accounts statements .So kindly suggest a best code for me.

Bank Accounts Numbers :

Re: How to Looping All Accounts at same time

PaigeMiller — Thu, 06 Aug 2020 11:08:09 GMT

Kindly explain further. What does "get all accounts statements" mean? Please show a small example.

Re: How to Looping All Accounts at same time

Kurt_Bremser — Thu, 06 Aug 2020 11:12:31 GMT

Please supply source data in usable form (in a data step with datalines, do not skip this!), and what you expect to get out of it.

Re: How to Looping All Accounts at same time

Mohan_Reddy — Thu, 06 Aug 2020 11:13:24 GMT

For example i have bank account numbers like this : 9022145682

9025478991

9120456897

9789456125 etc 10 Accounts.

Now i want all this 10 accounts transactions statements from june 29 to aug 1 through single code only..Like Looping .So kindly help in this code . once code will run we need to get all 10 accounts transaction statements outputs at same time.

Re: How to Looping All Accounts at same time

PaigeMiller — Thu, 06 Aug 2020 11:29:26 GMT

I'm afraid these incredibly brief descriptions have not led me to understand what you want or how we can help you. You have not explained what it means when you want all accounts transactions statements, or where these statements are, or how a SAS program can access them.

Also, any SAS program is "single code", so any SAS program would meet that need.

How to get multiple bank account transaction statements output ??

Mohan_Reddy — Thu, 06 Aug 2020 11:50:18 GMT

For example i have bank account numbers like this : 9022145682

9025478991

9120456897

9789456125 etc 10 Accounts.

Re: How to get multiple bank account transaction statements output ??

PaigeMiller — Thu, 06 Aug 2020 11:51:52 GMT

Please don't post the same question twice. You have already asked this question in your other thread at https://communities.sas.com/t5/SAS-Programming/How-to-Looping-All-Accounts-at-same-time/td-p/674950

Re: How to get multiple bank account transaction statements output ??

Mohan_Reddy — Thu, 06 Aug 2020 11:53:45 GMT

Soory for post.Before i had not asking properly so that why cause ask properly question right.So kindly help in this code

Re: How to get multiple bank account transaction statements output ??

Kurt_Bremser — Thu, 06 Aug 2020 12:00:34 GMT

I merged this back to the original question. Please provide example data and expected output; read my previous post.

Re: How to Looping All Accounts at same time

ghosh — Thu, 06 Aug 2020 12:11:38 GMT

Mohan

This is a very common question and there are may threads here on this topic. However, since your question is so vague I will point to a solution that will enable you to write your own code

https://blogs.sas.com/content/sastraining/2015/01/30/sas-authors-tip-getting-the-macro-language-to-perform-a-do-loop-over-a-list-of-values/

Re: How to Looping All Accounts at same time

Shmuel — Thu, 06 Aug 2020 12:24:24 GMT

If I understand you correctly then you can subset your data using a code like:

%let acnts = 1111 22222 3333 ....; /* accounts list */
%let period = BETWEEN <from_date> AND <last_date>;
/* enter dates literal in a format:  '06AUG2020'd */

data want;
  set have(where=(account in (&acnts) and date &period));
run;

if you have a long list of accounts then better use next skeleton code:

data _acnts;
   input account;
cards;
11111
22222
33333
.....
; run;
proc sql;
   create table want as
   select * from have
   where account in (select account from _acnts) and
              date &period;  /* period defined by %let or typed here */
quit;

Re: How to get multiple bank account transaction statements output ??

Reeza — Thu, 06 Aug 2020 15:05:42 GMT

1. Make sure you have a working program that works for one account

2. Follow the instructions here to generalize it for many accounts https://github.com/statgeek/SAS-Tutorials/blob/master/Turning%20a%20program%20into%20a%20macro.md

FYI - vague questions get vague answers and your question is incredibly broad. It could require something like above or could be as simple as changing an = to a IN but unless you show an example of what you're trying to do we have no idea of how to answer your question.