topic Re: proc report #byval in ODS and Base Reporting

proc report #byval

michellexu — Fri, 21 Apr 2017 23:18:48 GMT

Hi,

I currently use a macro to pull in all title and footnotes(holds in googledoc), and depending on which programs that is running, the relavent title and footnote will be selected.

I have tried with the compute before _page_, however I would like the title2 to be outside of the table, and underneath the rest of the titles.

After reading some of the papers, I have put #byvar(xx) into the title2 column and my proc report is:

proc report data = mydata nowindows headline headskip split='~'
missing spanrows style(header)={just=l} spacing=4;
columns dummy1 dummy2 dummy3 dummy4 dummy5;
by xx;
define ......
run;

then in the output( PDF and RTF), I get(i.e by value is Full analysis set)

xx= Full analysis set

studycode:xxxxxx

table xxxxx

Full analysis set

xx=Full analysis set

my question is :

1. Why does the text highlighted in red appear?

2. I suspect it could be my own macro problem, but the text in red only appear twice when it is the first page of a new set of sub-data. i.e. first page of full analysis set information, second page will only show the one at the bottom.

I have attached the screenshot, highlighted part is the one that I want to get rid off, but dont know how!

Would be greatful if someone could give me some suggestions?

Thanks

Michelle

Re: proc report #byval

Cynthia_sas — Sat, 22 Apr 2017 01:43:27 GMT

Hi:
You don't show all your code, including your options and your ODS statements. I suspect you need
options nobyline;
before your ODS invocation. Typically, when you use #byval or #byvar, you turn OFF the default byline.

But without data to test or your full code, that is just a guess.
cynthia

Re: proc report #byval

michellexu — Sat, 22 Apr 2017 19:31:28 GMT

Hi cynthia,

you were spot on! I did not have the options nobyline in the proc report!!!

I have since add that option into my proc report and it works perfectly!

thank you very much, I must have issed the option in the paper!!

Regards

Michelle