topic Re: displaying space charactere with proc report in ods RTF/PDF in SAS Programming

displaying space charactere with proc report in ods RTF/PDF

reznac — Thu, 14 Apr 2016 13:29:09 GMT

hello,

i use the proc report to display data of sas dataset in RTF/PDF
same value of columns contain a blank spaces character in the beginning of data followed by other printable characters
we can replace the blank byte(32) by Non-breaking space byte(160) but the length of the space is not the same in the output
is there an option or any way to do that ?
bellow a sas example :

data test ; 
a=' aaaaaa'; output ; 
a=' bbbbbb'; output ; 
a=' cccccc'; output ; 
run ;
ods rtf ; 
proc report data=test ; 
column a ; 
run ; 
ods rtf close ;

best regard

Re: displaying space charactere with proc report in ods RTF/PDF

ballardw — Thu, 14 Apr 2016 13:48:44 GMT

The most likely cause is the use of a proportional font. You could use an ods style that uses a monospace type font such as Courier or SAS Monospace.

Depending on exactly what you need to do there may be other options to control justification. If the intent is to create indented text then adding spaces often does exactly what you describe.

Re: displaying space charactere with proc report in ods RTF/PDF

RW9 — Thu, 14 Apr 2016 14:01:27 GMT

To preserve leading spaces in your text, you will want the little document asis=on option:

data test ; 
  a=' aaaaaa'; output ; 
  a=' bbbbbb'; output ; 
  a=' cccccc'; output ; 
run ;
ods rtf ; 
proc report data=test ; 
 column a style(column)={asis=on}; 
run ; 
ods rtf close ;