Can I fine tune my request, please! I'm trying to regenerate bank statements. I have 5 million transactions in SAS and want to generate bank statements for 20,000 customers over a 20 year time span. One statement per customer. From a high level perspective, how do I generate 20,000 excel workbooks - one for each customer. The name of the excel file will be 99999.xlsx where 999 is the customer number from SAS. Is this pretty straightforward ? A loop thru the data generating 20,000 output files. This will only be run once. Where do I start? (My current expertise is querying the data but I've no idea how to generate output excel files). The data structures are simple.
... View more
