topic ODS sample code - account balance in ODS and Base Reporting

ODS sample code - account balance

HGimenez — Tue, 26 Jun 2018 12:31:57 GMT

Hi everybody,

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!

Re: ODS sample code - account balance

RW9 — Tue, 26 Jun 2018 13:03:49 GMT

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.

Re: ODS sample code - account balance

ASHISH2525 — Sat, 31 Aug 2019 08:07:59 GMT

Hi,

Were you able to accomplish the task. Can you share the code with me. it will be very helpful

Thanks

Regards,

Ashish