topic Re: leading space in format in ODS and Base Reporting

leading space in format

abdullala — Wed, 09 Dec 2009 17:08:40 GMT

I defined the format with leading spaces. they look good when I output those in a dataset. But when I output it on the rtf file the leading spaces are all trimmed. I was using ods rtf and proc report.

Anyone knows how to preserve the leading spaces when output on an rtf file with proc report? thanks much!

Re: leading space in format

Cynthia_sas — Wed, 09 Dec 2009 18:36:06 GMT

Hi:
Check out the style attribute ASIS=ON -- it tells PROC REPORT, PROC PRINT or PROC TABULATE and ODS to preserve leading spaces. For example, in a PROC REPORT DEFINE statement you might have:
[pre]
define varname / display style(column) = {asis=on cellwidth=1in} ;

[/pre]

...if your varname variable was the one that contained leading spaces. If you wish to apply your format and have leading spaces preserved, then you would need to add the FORMAT= or F= option to your DEFINE statement.

cynthia

Re: leading space in format

abdullala — Wed, 09 Dec 2009 20:58:25 GMT

thank you very much Cynthia -- I will try it and let you know how it works for me!