About Adam93

Adam93 · ‎10-17-2018

Hi RW9, thanks for a speedy reply 🙂 I should have clarified the output goal better... The final outcome I am trying to reach is to have a separate excel document for each account. As it stands, my code will run 4 queries and produce an excel spreadsheet that contains 4 worksheets (for each query). I can run this code one account at a time for each account, but hoping to speed up the process for large batches... My thinking was to loop the accounts from my list into the " %let Master_Account = "123456789"; " section of the code.. this would allow the code to generate a separate spreadsheet for each set of queries. What are your thoughts?

Adam93 · ‎10-17-2018

SAS EG Hi there... I am new to the forum and a first time poster so please go easy ! I have basic understanding of loops from my experience with VBA although I need some help with doing the same in SAS.. My simplified code looks something like this: **************************************** Proc Import Excel data set; %let Master_Account = "123456789"; /*step 1*/ proc sql; create table HISTORY as select A from Table where ACCOUNT = &Master_Account; quit; /*step 2*/ Proc export to excel Sheet 1; quit; **************************************** The "&Master_Account" exists as there are 4 repetitions of the above code with different select queries. There is a local excel file that contains a list of account numbers that I import and save to 'work' where I then need to loop through each account number and run the above query. In the end there should be excel reports generated based off the inputted. Thanks in advance you for your help!

Online Status	Offline
Date Last Visited	‎10-25-2018 08:40 AM

Re: How do I loop a SQL Query - Different Variables

How do I loop a SQL Query - Different Variables

Re: How do I loop a SQL Query - Different Variables

How do I loop a SQL Query - Different Variables