topic Re: Design a table header flexibly in ODS and Base Reporting

Design a table header flexibly

wikich — Tue, 04 Sep 2018 08:59:33 GMT

I want to create a table head for a table, replacing the orignal table head.

The table head contains two rows:

head1 = !!!SS!FAS!PPS!

head2 = !Index!!(N=30)!(N=30)!(N=30)!

Here the ! meaning column delimiter. The head1 is the first row of table head .In head1, the first and second column are blank and the content of third, fourth and fifith are SS, FAS and PPS.

The head2 is the second row of table head, the content of the first column is index; the second is blank; the third to fifth are (N-30).

I want to form the following table head:

Re: Design a table header flexibly

RW9 — Tue, 04 Sep 2018 09:36:21 GMT

Your question is a bit vague I am afraid. Creation of Table output for clinical reports is pretty simple, just apply some bits in the proc report:

proc sql noprint;
  select count distinct usubjid) from adsl where ss="Y" into :ss;
  select count distinct usubjid) from adsl where fas="Y" into :fas;
  select count distinct usubjid) from adsl where pps="Y" into :pps;
quit;

ods rtf...;

proc report data=yourdata split="*";
  columns _all_;
  define ss_count / "SS*(%trim(&ss.))";
  define fas_count / "FAS*(%trim(&fas.))";
  define pps_count / "PPS*(%trim(&pps.))";
run;

ods rtf close;

Re: Design a table header flexibly

Reeza — Tue, 04 Sep 2018 13:26:58 GMT

There’s an old paper by Cynthia Zender that walks through how to create clinical tables. It’s titled Creating Complex Reports amd has the ful code and data attached for practice.

Re: Design a table header flexibly

wikich — Tue, 04 Sep 2018 13:54:52 GMT

Thanks for your answer. I want to write a macro mreport to deal with the table head. The table data has been calculated before.

I want to use the header parameters (in above case the parameters are head1 and head2) only, to form the table head, without other information of the table. This will make the macro more general. If there is rtf grammer to recognize such form(!!!SS!FAS!PPS!)directly?

If exists, it will make the macro more easier.

Re: Design a table header flexibly

Cynthia_sas — Tue, 04 Sep 2018 14:03:29 GMT

Thanks, Reeza for the shout out about that paper. It was a popular one. But, yes, hard to believe it is 10 years old! However, that paper does not show using RTF control strings or RTF "grammar" to format something like (!!!SS!FAS!PPS!) that the OP wants to use.

Cynthia

Re: Design a table header flexibly

RW9 — Tue, 04 Sep 2018 14:09:23 GMT

Yes, I have seen this type of thing before. What I can tell you is that using such a macro is a real pain in the neck and they do not work half the time or do what you want. It is far simpler to either create a report for each output, or have a template file that then gets updated per the output requirements. Remember, SAS is very flexible, wrapping it in macro code reduces the flexibility (and simplicity in understanding the code). Up to you of course, just I have seen it a lot.

Re: Design a table header flexibly

Tom — Tue, 04 Sep 2018 14:23:14 GMT

It is hard to create the header to a table in a report without also creating the actual table.

Can you show a simple example of how you intend to use this in a program?

Re: Design a table header flexibly

wikich — Tue, 04 Sep 2018 14:50:33 GMT

Thank you Reeza. I have found the article and begin to read her code.

Re: Design a table header flexibly

Reeza — Tue, 04 Sep 2018 15:01:05 GMT

Just a last note, rather than tags, you can use templates to control layout and styles.

The RTF style here, originally written by a colleague, was what we used to create our clinical reports for journal submissions. There's a little example at the bottom of the code that illustrates the output.

https://gist.github.com/statgeek/9603140

This is a bit more complex but may help. It uses the Report Writing Interface and is fairly well documented:

https://www.pharmasug.org/proceedings/2013/CC/PharmaSUG-2013-CC13.pdf