topic Re: ods pdf text formatting in SAS Programming

ods pdf text formatting

Jeka — Thu, 23 Feb 2017 13:17:59 GMT

Hi All, i faced with a problem when creating .pdf output. At the moment output looks like this:

But i have to remove "~" symbols. For .rtf format it is working correctly ,just using escapechar="~". Is there any way to remove "~" using soome options or parameters in "ods pdf" ?

code:

%if &form=pdf %then %do;
ods pdf file="&path.out/&prefix. Incidence of all Adverse Events.pdf" style=Journal;
%end;
OPTIONS PAPERSIZE=A4 ORIENTATION=Portrait linesize=max;
ODS escapechar="~";

options missing=' ';

proc report data=final style={protectspecialchars=yes} nowd missing split='@';
columns col1 col2 col3 col4 ;
define col1 / display left 'System Organ Class@ Preferred Term' ;
define col2 / display center 'Number @ of Patients' ;
define col3 / display center 'Percentage @ of Patients';
define col4 / display center 'Number @ of Events';
run;
ods &form close;

I tried to use col1='a0'x||strip(col1); but it is working really strange, for some rows it is adding 1 blank and in some rows it is deleting combination of letters 'an' even in header ))).

Also i tried to use: col1= ' ~{nbspace 4} ' ||strip(col1); but in output it appeares as a text.

Re: ods pdf text formatting

nehalsanghvi — Thu, 23 Feb 2017 14:35:54 GMT

If the ~ is embedded in the column, have you tried using the tranwrd function ot take it out of the text string? It would work like this:

NewVar=tranwrd(Yourvar,'~','');

Re: ods pdf text formatting

nehalsanghvi — Thu, 23 Feb 2017 14:38:09 GMT

If the '~' is embedded in the column, have you tried using the tranwrd function ot take it out of the text string? It would work like this:

NewVar=tranwrd(Yourvar,'~','');

Re: ods pdf text formatting

Cynthia_sas — Thu, 23 Feb 2017 14:48:09 GMT

Looking at your report, it appears that someone tried to fake out indention for some of the report rows by padding the row with tildes (~). I don't know why you have the protectspecialchars=yes, unless your data also has RTF control strings embedded in the data. You did not post the data, so it is nearly impossible to guess.

You can accomplish the indention using the leftmargin style attribute, as I show here https://communities.sas.com/t5/ODS-and-Base-Reporting/Indent-different-rows-of-a-column-in-RTF/td-p/215812 and here https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-pdf-proc-report-indent-column-conditionally/td-p/85624 (with picture) and here https://communities.sas.com/t5/ODS-and-Base-Reporting/Proc-Report-Indent-and-background-color/td-p/131036 and there are many other postings about LEFTMARGIN or INDENT that you could search for. Also, if you want to use RTF control strings, then \tab usually works to indent, as shown here https://communities.sas.com/t5/ODS-and-Base-Reporting/formatting-multiple-line-statements-in-proc-report/td-p/43637, in which case you would need protectspecialchars=off.

cynthia

Re: ods pdf text formatting

Jeka — Thu, 23 Feb 2017 15:23:42 GMT

Thank you all for your attention! I found the solution :

col1='a0'x||'a0'x||'a0'x||'a0'x||'a0'x||strip(aeterm_pt); it is adding 5 spaces , but it works correctly for .pdf and .rtf when using next options in proc report definition:

proc report data=final style={protectspecialchars=on} nowd missing formchar(2)='_' split='@';

Re: ods pdf text formatting

Cynthia_sas — Thu, 23 Feb 2017 16:10:28 GMT

Formchar is a LISTING only option. should not work for PDF or RTF, per the doc
http://support.sas.com/documentation/cdl/en/proc/69850/HTML/default/viewer.htm#n1dz7jdasx5t56n1rmlx346dyk6n.htm

cynthia