topic Creating an Instructions sheet in report output in ODS and Base Reporting

Creating an Instructions sheet in report output

Elliott — Tue, 27 Jun 2017 19:34:27 GMT

I run a daily report, and based on the entries in the report there are different instuctions on what to do. I wanted to put an instructions sheet in the report to refer to. How can I do that?

Thanks,

Elliott

Re: Creating an Instructions sheet in report output

Reeza — Tue, 27 Jun 2017 20:15:44 GMT

You can use ODS TEXT to write text to the output destination.

Re: Creating an Instructions sheet in report output

ballardw — Tue, 27 Jun 2017 21:24:44 GMT

Procs ODSTEXT and or ODSLIST, a bit different than ODS Text, might be a better joice for significant blocks of text. For one thing you can keep data in a data set and use that to generate output. So it may be possible to link data to your report data and customize the instrutions.

Re: Creating an Instructions sheet in report output

Reeza — Tue, 27 Jun 2017 22:50:19 GMT

So the answer is it depends. There are methods of adding information to various places. If you use HTML maybe it's a tooltip. If it's something else, the options can vary. Basically you need to provide more information if you need more details.

Re: Creating an Instructions sheet in report output

Elliott — Wed, 28 Jun 2017 00:02:39 GMT

I am using ods to create an excel report, I wanted to add an additional sheet with instructions on how to work the report.

Re: Creating an Instructions sheet in report output

Reeza — Wed, 28 Jun 2017 00:52:52 GMT

Add instructions as text to a dataset. Proc Print/Report the dataset to ODS.