Hi all,
Could you please help to code the line before Total:
The case was resolved by adding the following data to var3:
var3 = "(*ESC*)S={bordertopwidth=1}"||" Total # of Subjects Attended Visit = " || strip(put(number, 8.));
Use original code of RTF. ods escapechar="^"; proc report...; columns x ("^R'\brdrb\brdrs\brdrw15 'Powers" y z) ;
I bring my apolog
Hi:
It is really hard to do what you ask with code or data to test. It is impossible to "correct" your COMPUTE block out of context -- it needs the whole code and some data.
If you can't share your data then make some fake data or use one of the SASHELP datasets. I do not think your COMPUTE before will do what you want, because you would be writing the line at the TOP of the group when VAR3 changes. According to your picture, that is not where you want the LINE to be written.
Another reason why it is important to see all the code is that in your screen shot, it doesn't look like there's a column for VAR3, which implies that it might be a NOPRINT item. And, depending on the order of variables in the COLUMN statement, you might be testing VAR3 at the wrong place.
cynthia
The case was resolved by adding the following data to var3:
var3 = "(*ESC*)S={bordertopwidth=1}"||" Total # of Subjects Attended Visit = " || strip(put(number, 8.));
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.