11-27-2014 06:43 PM
Hi SAS folks,
I use custom reports all the time in EG, and despite their quirks they are a huge time-saver.
My problem: I'd like to control various things like report section headings, dates etc via macro variables or similar, but I cannot seem to get them to evaluate within the custom reports.
For example, if I use a prompt in the report ("&CarMaker") to select Toyota and run my process flow, I'd like to have the word 'Toyota' and the current date (i.e. from the date() function) appear in the report title, preferably with some control over formatting:
BIG SAS CAR REPORT
Run Date: 28 November 2014
I can easily enough get those bits of information into tables and insert in the report that way, but I'd really love to get single lines of nice plain text in there as well that I can control procedurally.
Thanks for your time!
12-03-2014 06:06 PM
I the pick the output of an existing task, e.g. summary table or chart or map etc, then select Create > Report. This creates a 'Custom Reports' process flow.
I then continue adding results of other task within the Modify Report > Edit Report Contents UI.
12-11-2014 08:29 PM
No, this is the correct forum. I did look into it, but couldn't get any macro variables to resolve in header/footer.
I'm not sure if it's possible
12-11-2014 09:11 PM
If you have them in a table, you can use a customized list or proc print or data _null_ step to get them to display nicely though. Not a great workaround, but a workaround.