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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.