06-26-2018 08:31 AM
I need to generate ~1,000 statements with SAS, one statement for each customer in PDF format and e-mail them. Something similar to the account balance you get from your bank, very close to a credit card statement.
1- I guess ODS is the way to go. Is there other alternative?
2- I am sure somebody has done something like this. If you are so kind to share your code, I will really appreciate it. I am new to ODS and I don't have a clue on where to start. Any suggestions or comments are welcome
3- Is it possible to design a template with a graphic desing tool and "fill the blanks" with SAS?
Thanks a lot!
06-26-2018 09:03 AM
Start by writing the code for 1 statement. This could be as simple as:
data tmp; str="hello"; run; ods pdf file="c:\tmp.pdf"; proc print data=tmp noobs; run; ods pdf close; filename tmp email "..." attach="c:\tmp.pdf"; data _null_; file tmp; put 'Hi your file.'; run; filename tmp clear;
Once you have it working for one, then you can start to replace key parts with macro to be able to run it for X number of times.