Hi Cynthia, Thanks for replying! That is indeed very interesting and useful. I have to admit the main reason that I'm using RTF to PDF is t hat most white papers I've read in the last two weeks always use ods RTF (including that old one of yours from 2008 I asked about last week). VBScript might not be required, but my script already is up and running, so if there is any advantage to sticking to RTF I might as well 🐵 Back to the original question, what would be a good practice to make sure I have enough padding between my columns without manually editing the column widths? My current solution is to add 1 character wide column, like the _empty column in this paper.: https://support.sas.com/resources/papers/proceedings11/246-2011.pdf data class; set sashelp.class(obs=3); _empty=''; run;
... View more
I dunno really. I was pushed that way here :
https://communities.sas.com/t5/ODS-and-Base-Reporting/Running-commands-in-windows-space-in-directory-and-filename/m-p/238500#M14861
I'm using a few commands that (may?) only work in ODS RTF, such as "pretext='\ql\li360" to indent some columns. Like here :
http://support.sas.com/resources/papers/proceedings09/027-2009.pdf
... View more
Hi Ballardw, Thanks for replying! I'm currently outputting to ODS RTF, then I have a VBScript that opens the RTF and saves to PDF. I'd answer "both" to your question. Basically, my problem is that I have wide headers (say 6 characters) but narrow data (say 1 digit). With a cellpadding of 1, the headers are hard to distinguish as the gap between each word is very small.
... View more
Found it (obviously, after 2 days of searching and exactly 15 minutes after posting). Just use an escape character like this:
ods escapechar='^'; ods listing close;
ods rtf file='c:\temp\usestyle1.rtf'; title "1) Justify ALL the Headers Left and then change the ones you do NOT want left-just"; proc report data=sashelp.class nowd style(header)={just=l}; column ('Left Justify' age name ) ('^S={just=r} Right justify' height weight); define age / order style(header)={cellwidth=1.25in} 'Laboratory Test'; define name / display style(header)={cellwidth=1.25in} 'The Name'; define height / display style(header)={just=c cellwidth=1.25in} 'height'; define weight / display style(header)={just=c cellwidth=1.25in} 'weight'; run; ods _all_ close;
... View more
Hi everyone,
I'd like to know if there is a way to keep some horizontal padding between my columns, but not between my rows in Proc Report. Currently, I am doing something like this:
proc report data=temp ls=120 ps=40 nowd style(report)=[frame=hsides rules=groups cellpadding=1 cellspacing=0 ];
,but I would like to increase the distance between the columns, without reducing the number of rows on my page. The only option I've found is to manually set the width of the columns.
Thanks!
... View more
Hi everyone,
I'd like the first spanned header to be left-aligned and the second one to be centered. How can I style spanned headers independently?
thanks!
edit: I'm using distinct columns to generate the report, not ACROSS.
edit2: here's a minimal non-working example stolen from another thread:
ods listing close;
ods rtf file='c:\temp\usestyle1.rtf'; title "1) Justify ALL the Headers Left and then change the ones you do NOT want left-just"; proc report data=sashelp.class nowd style(header)={just=l}; column ('Left Justify' age name ) ('Right justify' height weight); define age / order style(header)={cellwidth=1.25in} 'Laboratory Test'; define name / display style(header)={cellwidth=1.25in} 'The Name'; define height / display style(header)={just=c cellwidth=1.25in} 'height'; define weight / display style(header)={just=c cellwidth=1.25in} 'weight'; run; ods _all_ close;
... View more
Never mind - it was here all along: https://communities.sas.com/t5/ODS-and-Base-Reporting/Left-and-Right-aling-title-on-same-line-in-RTF-output/td-p/180639
... View more
Hi everyone,
I am hoping to find a way to hadd a three part header (left, center and right justified parts) to the output of my Proc REPORT into ODS RTF.
I know that I can justify, say "title1" to the left, right or center, but I would like to be able to put some details "left" centered and some others right-centered, like on can easily do in *gasp* MS Office.
thanks!
... View more
That last report (and its code) is exactly what I was looking for! Thanks for pointing me to it, I would never have made it until the part where it mentions sparklines.. cheers!
... View more
Hi Cynthia,
Thanks for replying. I've been wondering why in that paper you say that these reports are typically output to RTF instead of PDF or HTML?
Is it because you do post-processing before converting to PDF? Because my clients typically want a PDF, not a word file.
cheers
... View more
I hadnt seen the above link -looks promising, thanks!
How do you convert from RTF to PDF? I've been using VBscript fo convert from XLS to PDF.
Cheers
... View more
Proc Report and ODS PDF do seem to be the way to go. It's just that Proc report's output is so ugly and creating a nice template in Excel, filling it and converting it to PDF is just so easy.... Eye-candy is important since this report is sent to 1500 persons.
Here is a mock-up of what I am trying to achieve. There are 50 teams and large teams could span up to 3 or 4 pages.
I'll keep on reading. cheers
... View more
Hi Cynthia,
Thanks for the reply! I've read that paper already, but I couldnt find the Bissantz font anywhere. Also, I'm very interested in a "bar" sparkline.
cheers!
... View more
