Desktop productivity for business analysts and programmers

Inserting / Controlling text in EG 5.1 Custom Reports

Reply
Occasional Contributor
Posts: 13

Inserting / Controlling text in EG 5.1 Custom Reports

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

Make:  Toyota

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!

Occasional Contributor
Posts: 13

Re: Inserting / Controlling text in EG 5.1 Custom Reports

No suggestions?  Also I'm new here, so feel free to let me know if I'm asking in the wrong sub-forum,

Thanks

Grand Advisor
Posts: 17,297

Re: Inserting / Controlling text in EG 5.1 Custom Reports

How are you building your custom report?

Occasional Contributor
Posts: 13

Re: Inserting / Controlling text in EG 5.1 Custom Reports

Hi Reeza,

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.

Occasional Contributor
Posts: 13

Re: Inserting / Controlling text in EG 5.1 Custom Reports

Is there a different place to post this?

Thanks again,

Grand Advisor
Posts: 17,297

Re: Inserting / Controlling text in EG 5.1 Custom Reports

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 Smiley Sad

Occasional Contributor
Posts: 13

Re: Inserting / Controlling text in EG 5.1 Custom Reports

Ah, never mind, I suppose I'll have to settle for the terms appearing in a table in the report.

Thanks for checking though!

Grand Advisor
Posts: 17,297

Re: Inserting / Controlling text in EG 5.1 Custom Reports

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.

Ask a Question
Discussion stats
  • 7 replies
  • 585 views
  • 3 likes
  • 2 in conversation